Linux 下安装mysql5.7

1.下载mysql

wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz

2.解压安装包

tar -xzvf mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz

3.修改文件名

mv mysql-5.7.13-linux-glibc2.5-x86_64 mysql 

4.删除linux自带的mysql

rpm -qa | grep mysql

5.添加mysql用户

groupadd mysql

useradd -r -g mysql mysql

6.mysql的安装目录

chown -R mysql mysql/

chgrp -R mysql mysql/

7.修改my.cnf

support-files/目录下 my-default.cnf复制到my.cnf

cp mysql.server /etc/mysql.server

8.初始化(这个时候data目录需要为空，否则报错)

./mysqld --initialize --user=mysql --basedir=/opt/mysql/--datadir=/opt/mysql/data/

生成一个密码，保存

9.启动mysql

server mysql start

10.bin目录下登陆 ./mysql -u root -p ,输入刚刚保存的密码

11.更新host

mysql> use mysql; 

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> update user set host = '%' where user = 'root';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1  Changed: 1  Warnings: 0

mysql> select host, user from user;

+-----------+-----------+

| host      | user      |

+-----------+-----------+

| %         | root      |

| localhost | mysql.sys |

+-----------+—————+

12.关闭防火墙

systemctl stop firewalld.service

13.这样就可以远程连接了