[root
创建数据data目录并修改权限
@orclmysql]
# mkdir data[root
@orclmysql]
# chown -R mysql.mysql .[root
@orclmysql]
# lltotal
56drwxr-xr-x
2mysql mysql
4096Jul
122016-rw-r--r--
bin
1mysql mysql
17987Jul
122016drwxr-xr-x
COPYING
2mysql mysql
4096Feb
421:
49drwxr-xr-x
data
2mysql mysql
4096Jul
122016drwxr-xr-x
docs
3mysql mysql
4096Jul
122016drwxr-xr-x
include
5mysql mysql
4096Jul
122016drwxr-xr-x
lib
4mysql mysql
4096Jul
122016-rw-r--r--
man
1mysql mysql
2478Jul
122016drwxr-xr-x
README
28mysql mysql
4096Jul
122016drwxr-xr-x
share
2mysql mysql
4096Jul
122016[root
切换目录,并初始化数据库(nunaSZDJn1,/为初始密码 牢记)
support-files
@orclbin]
#cd /usr/local/mysql/bin[root
@orclbin]
# ./mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --initialize2017-
02-
04T13:
50:
51.147996Z
0[Warning] TIMESTAMP
withimplicit DEFAULT value
isdeprecated. Please use --explicit_defaults_for_timestamp server option (see documentation
formore details).
2017-
02-
04T13:
50:
51.155737Z
0[Warning]
'NO_AUTO_CREATE_USER'sql mode was
notset.
2017-
02-
04T13:
50:
51.557455Z
0[Warning]
InnoDB: New log files created, LSN=
457902017-
02-
04T13:
50:
51.627576Z
0[Warning]
InnoDB: Creating foreign key constraint system tables.
2017-
02-
04T13:
50:
51.704370Z
0[Warning] No existing UUID has been found, so we assume that
thisisthe first time that
thisserver has been started. Generating a
newUUID: f0ed6926-eae0-
11e6-a746-
005056be5b20.
2017-
02-
04T13:
50:
51.706481Z
0[Warning] Gtid table
isnotready to be used. Table
'mysql.gtid_executed'cannot be opened.
2017-
02-
04T13:
50:
51.709430Z
1[Note] A temporary password
isgenerated
forroot
@localhost[root
下面修改权限
basedir为安装目录 datadir为存放数据路径
: nunaSZDJn1,/
@orcllocal]
# pwd[root
/usr/local
@orcllocal]
# lltotal
598100drwxr-xr-x.
2root root
4096Jan
814:
06drwxr-xr-x.
bin
2root root
4096Jun
282011drwxr-xr-x.
etc
2root root
4096Jun
282011drwxr-xr-x.
games
2root root
4096Jun
282011drwxr-xr-x.
include
2root root
4096Jun
282011drwxr-xr-x.
lib
2root root
4096Jun
282011drwxr-xr-x
libexec
10mysql mysql
4096Feb
421:
49-rw-r--r--
mysql
1root root
612408403Feb
421:
32mysql-
5.7.14-linux-glibc2
.5drwxr-xr-x.
-i686.tar.gz
2root root
4096Jun
282011drwxr-xr-x.
sbin
5root root
4096Jul
32015drwxr-xr-x.
share
2root root
4096Jun
282011[root
src
@orcllocal]
# chown -R root mysql[root
@orcllocal]
# lltotal
598100drwxr-xr-x.
2root root
4096Jan
814:
06drwxr-xr-x.
bin
2root root
4096Jun
282011drwxr-xr-x.
etc
2root root
4096Jun
282011drwxr-xr-x.
games
2root root
4096Jun
282011drwxr-xr-x.
include
2root root
4096Jun
282011drwxr-xr-x.
lib
2root root
4096Jun
282011drwxr-xr-x
libexec
10root mysql
4096Feb
421:
49-rw-r--r--
mysql
1root root
612408403Feb
421:
32mysql-
5.7.14-linux-glibc2
.5drwxr-xr-x.
-i686.tar.gz
2root root
4096Jun
282011drwxr-xr-x.
sbin
5root root
4096Jul
32015drwxr-xr-x.
share
2root root
4096Jun
282011[root
src
@orcllocal]
# chown -R mysql mysql/data/ 将数据权限修改回来[root
@orcllocal]cd mysql
/bin/[root
@orclbin]
# ./mysqld_safe --user=mysql &[root
再开启另一个命令窗口
@orcl~]
# ps -ef|grep mysql 服务起来了root
1162410029021:
57pts/
000:
00:
00mysql
/bin/sh ./mysqld_safe --user=mysql
1184911624221:
57pts/
000:
00:
00/usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/orcl.err --pid-file=/usr/local/mysql/data/orcl.pid --socket=/
var/lib/mysql/mysql.sock --port=
22101root
1190711885021:
57pts/
100:
00:
00[root
grep mysql
@orcl~]
#[root
@orcl~]
# clear[root
@orcl~]
# cd /usr/local/mysql/bin/[root
@orclbin]
# ./mysql -uroot -p 进入mysql命令窗口回车后,需要输入初始化数据库时显示的密码Enter
passwordWelcome to the MySQL monitor. Commands end
:
with;
orYour MySQL connection id
\g.
is2Server
version:
5.7.14Copyright (c)
2000,
2016,
and/
orOracle
its affiliates. All rights reserved.
isa registered trademark
ofOracle Corporation
and/
oraffiliates. Other names may be trademarks
its
ofType
owners.
their respective
'help;'or'\h'forhelp. Type
'\c'mysql> SET PASSWORD = PASSWORD(
to clear the current input statement.
'jfhr@rhvh23'Query OK,
); 修改密码
0rows affected,
1warning (
0.00mysql> update user set host=
Database changed
mysql> use mysql; 进入mysql数据库
sec)
'%'where user=
'root'Query OK,
;修改可以远程登录
1row affected (
0.00Rows
sec)
matched:
1Changed:
1Warnings:
0Query OK,
mysql> FLUSH PRIVILEGES; 立即生效
0rows affected (
0.01[root
设置软件连接
mysql> exit
sec)
@orclbin]
# ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock[root
@orclbin]
# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql[root
@orclbin]
# vim /etc/init.d/mysql[root
设置开机启动与服务命令
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
修改
@orclbin]
# cd /etc/init.d/[root
@orclinit.d]
# chkconfig --add mysql[root
@orclinit.d]
# chkconfig --level 2345 mysql on[root
@orclinit.d]
# chmod 777 mysql[root
@orclinit.d]
#[root
关闭第一个窗口,在第二个窗口里面删进程
@orclinit.d]
# ps -ef|grep mysqlroot
1162410029021:
57pts/
000:
00:
00mysql
/bin/sh ./mysqld_safe --user=mysql
1184911624021:
57pts/
000:
00:
00/usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/orcl.err --pid-file=/usr/local/mysql/data/orcl.pid --socket=/
var/lib/mysql/mysql.sock --port=
22101root
1211011885022:
03pts/
100:
00:
00root
vim /etc/init.d/mysql
1216211885022:
06pts/
100:
00:
00[root
grep mysql
@orclinit.d]
# kill -9 11624[root
@orclinit.d]
# kill -9 11849[root
@orclinit.d]
# ps -ef|grep mysqlroot
1211011885022:
03pts/
100:
00:
00root
vim /etc/init.d/mysql
1216711885022:
06pts/
100:
00:
00[root
grep mysql
@orclinit.d]
#[root
@orclinit.d]
# service mysql start 启动数据库[root
Starting MySQL [ OK ]
@orclinit.d]
# ps -ef|grep mysqlroot
1211011885022:
03pts/
100:
00:
00root
vim /etc/init.d/mysql
122111022:
07pts/
100:
00:
00mysql
/bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/orcl.pid
1245212211022:
07pts/
100:
00:
00/usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/orcl.err --pid-file=/usr/local/mysql/data/orcl.pid --socket=/
var/lib/mysql/mysql.sock --port=
22101root
1249511885022:
08pts/
100:
00:
00[root
grep mysql
@orclinit.d]
#chown -R
如果出现Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/dxwx140.pid)
单机版数据就到此结束,关于主从和集群会在下次更新时发布。
mysqlchmod -R
:mysql data
755/usr/local/mysql/data
来源: