userdel mysql # 删除用户
# groupdel mysql # 删除用户组名
# mkdir /home/mysql # 在home文件夹下创建文件夹mysql
# mkdir /home/mysql/data # 在mysql文件夹下创建文件夹data
# groupadd mysql # 创建一个名为mysql的用户组
# cd /home/mysql
# ./support-files/mysql.server start
Starting MySQL.. OK!
# tar -xzvf mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz # 解压文件
# cd mysql-5.7.13-linux-glibc2.5-x86_64 # 进入
# mv * /home/mysql # 移动到之前我创建的mysql文件夹下
mysql5.7新特性:由上面可以看出, mysql_install_db
已经不再推荐使用了,建议改成 mysqld --initialize
完成实例初始化。
1
2
3
4
5
|
# ./bin/mysqld
--user=mysql --basedir=/home/mysql --datadir=/home/mysql/data --initialize
# ./mysqld
--user=mysql --basedir=/home/mysql --datadir=/home/mysql/data --initialize
[Warning]
TIMESTAMP
with
implicit
DEFAULT
value
is
deprecated. Please use
--explicit_defaults_for_timestamp server option (see documentation for more details).
[ERROR]
--initialize specified but the data directory has files in it. Aborting. 2016-04-08T01:46:53.155879Z 0
[ERROR] Aborting
|
cd /home/mysql/data # 进入安装目录下的data目录
# rm -fr * # 清空数据
# cd /home/mysql
# ./bin/mysqld
--user=mysql --basedir=/home/mysql --datadir=/home/mysql/data --initialize
[Warning]
TIMESTAMP
with
implicit
DEFAULT
value
is
deprecated. Please use
--explicit_defaults_for_timestamp server option (see documentation for more details). 2016-04-08T01:47:59.945537Z 0
[Warning] InnoDB: New log files created, LSN=45790 2016-04-08T01:48:00.333528Z 0 [Warning] InnoDB: Creating
foreign
key
constraint
system tables. 2016-04-08T01:48:00.434908Z 0
[Warning]
No
existing UUID has been found, so we assume that this
is
the
first
time
that this server has been started. Generating a new UUID: ece26421-fd2b-11e5-a1e3-00163e001e5c. 2016-04-08T01:48:00.440125Z 0
[Warning] Gtid
table
is
not
ready
to
be used.
Table
'mysql.gtid_executed'
cannot be opened. 2016-04-08T01:48:00.440904Z 1
[Note] A
temporary
password
is
generated
for
root@localhost: **mjT,#x_
1
2
3
4
5
6
7
8
9
# vim support-files/mysql.server
--------------------------
...
basedir=/home/mysql
datadir=/home/mysql/data
...
--------------------------
# ./support-files/mysql.server start
start Starting MySQL.. OK!
--------------
第四在bin目录下,点击./mqsql -u root -p
# mysql -uroot -p
Enter password: 【输入原来的密码】
;
这时候如果直接use mysql会提示密码修改
alter user 'root'@'localhost' identified by 'xxxxxxxx';
以新密码的命令进去就
ok了