centos7 安装mysql

1.下载rpm包 

wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm

 

2.yum安装rpm

yum -y install mysql57-community-release-el7-11.noarch.rpm

 

3.安装mysql服务

yum -y install mysql-community-server

 

4.启动mysql

service mysqld start

 

5.查看mysql初始密码

grep "password" /var/log/mysqld.log

 

6. 进入数据库

mysql -uroot -p

 

7. 修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

 

8.开启mysql远程访问权限

 

mysql -u root -p

 

mysql>use mysql;

 

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

 

mysql>select host, user from user; 

 

mysql> FLUSH PRIVILEGES;

 

mysql> quit;

 

 

9.修改mysql 端口

vim /etc/my.cnf  添加 port=3300