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";