centos7安装mysql5.6

centos7安装mysql5.6

标签（空格分隔）： linux

yum install wget -y
yum list installed | grep mysql
yum -y remove mysql*
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
yum install mysql-community-release-el7-5.noarch.rpm -y
yum repolist all | grep mysql

启动mysqld服务 有两种方式service 或者 systemctl

systemctl start mysql

service mysqld start
service mysqld status

进入mysql 第一次直接回车，不用输入密码

mysql -u root

修改root用户密码

mysql> use mysql;
mysql> update user set password=PASSWORD("123456") where User='root';
mysql> flush privileges;

设置远程主机登陆

GRANT ALL PRIVILEGES ON . TO root@"%" IDENTIFIED BY "123456";