mysql5.7.20tar.gz安装

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!

# useradd -g mysql -d /home/mysql mysql                   # 在用户组下创建用户

# 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系统，
#  mysql -uroot -p
Enter password: 【输入原来的密码】




;

这时候如果直接use mysql会提示密码修改










alter  user 'root'@'localhost' identified by 'xxxxxxxx';




以新密码的命令进去就 ok了