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.这样就可以远程连接了