CentOS 7 安装MySQL 5.6

MySQL

安裝 MySQL Repository

rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

安裝 MySQL 套件

yum install mysql-community-server

启动MySQL

systemctl start mysqld

开机自启动 mysqld

/usr/bin/systemctl enable mysqld

设置 MySQL 密码

/usr/bin/mysql_secure_installation

登录 MySQL

mysql -uroot -p

远程访问授权

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)