centos安装mysql

1.下载

wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.13-1.el6.x86_64.rpm-bundle.tar

2.解压

tar -xvf mysql-5.7.13-1.el6.x86_64.rpm-bundle.tar

3.安装

rpm -ivh mysql-community-common-5.7.13-1.el6.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.13-1.el6.x86_64.rpm --force --nodeps

rpm -ivh mysql-community-client-5.7.13-1.el6.x86_64.rpm

rpm -ivh mysql-community-server-5.7.13-1.el6.x86_64.rpm

4.初始化服务

mysqld --initialize --user=mysql

5.查看生成的临时密码

grep 'temporary password' /var/log/mysqld.log

6.登入客户端

mysql -u root -p

将第5步的临时密码输入进去

7. 修该mysql密码

update user set authentication_string = password('123456'), password_expired = 'N', password_last_changed = now() where user = 'root';

8.设置远程访问

use mysql;

update user set user.Host='%' where user.User='root';

flush privileges;

quit