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