centos7下安装MySQL

2019独角兽企业重金招聘Python工程师标准>>>

###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
service mysqld restart
mysql -uroot -p
(输入密码)
mysql> set password for 'root'@'localhost' = password('admin');

####OK,搞定！！

####授权MySQL远程连接

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin' WITH GRANT OPTION;
FLUSH PRIVILEGES;

####如果还是无法连接，那么可能是防火墙的问题

service iptables stop
systemctl stop firewalld.service

####MySQL主从配置请参考

http://my.oschina.net/ironwill/blog/657247

转载于:https://my.oschina.net/ironwill/blog/667734