CentOS7下安装MySQL

下载安装软件源：

# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
# rpm -ivh mysql-community-release-el7-5.noarch.rpm
# yum install mysql-community-server

安装成功后重启 mysql 服务

service mysqld restart

初次安装mysql，root账户没有密码

# mysql -u root

设置密码：

mysql> set password for 'root'@'localhost'=password('password');
Query OK, 0 rows affected (0.00 sec)
 
mysql> exit
Bye

设置允许远程连接

mysql> grant all privileges on *.* to root@'%'identified by 'password';
Query OK, 0 rows affected (0.00 sec)
 
mysql> 

如果允许root账号远程连接要对系统数据库的root账户设置远程访问的密码，与本地的root访问密码并不冲突。

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option; #123456为你需要设置的密码

参考连接：

https://www.cnblogs.com/chxuyuan/p/7707392.html