yum下载安装mysql服务

• 1.下载mysql源码

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

 

• 2.安装mysql源

yum localinstall mysql57-community-release-el7-8.noarch.rpm

 

• 3.检查mysql源是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

 

• 4.真正安装mysql

yum install mysql-community-server

 

• 5.启动mysql服务(先启动然后才能查看默认生成的mysql密码)

systemctl start mysqld.service

 

• 6.查看mysql第一次安装默认生成密码

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

 

• 7.进入mysql

mysql -uroot -p

 

 

配置mysql，修改密码与配置远程连接

• 1.修改密码（password('要设置的密码，设置简单的密码不行，也是可以修改，不过设置复杂的就ok了')）

mysql> set password for 'root'@'localhost' = password('root123');

 

• 2.开启mysql的root用户远程连接服务(%号即远程连接，IDENTIFIED BY后面跟的密码)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root123' WITH GRANT OPTION;

 

• 3.刷新

mysql> flush privileges;

 

来自  http://blog.youxiu326.com/view/4