Centos7 安装MySQL

Posted on | In

下载MySQL源安装包

1
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

安装MySQL源

1
yum localinstall mysql57-community-release-el7-8.noarch.rpm

检查MySQL源是否安装成功

1
yum repolist enabled | grep "mysql.*-community.*"

修改源，改变默认安装的MySQL版本

1
vim /etc/yum.repos.d/mysql-community.repo

如果要使用5.6，就将5.6下方的 enabled=1 ，其他的设为 enabled=0 。

安装MySQL

1
yum install mysql-community-server

启动MySQL服务

1
systemctl start mysqld

开机启动

1
2
systemctl enable mysqld
systemctl daemon-reload

修改本地登录密码

查看MySQL密码

1
grep 'temporary password' /var/log/mysqld.log

连接MySQL

1
mysql -uroot -p

修改密码

1
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass1!';

或

1
SET PASSWORD FOR 'root'@'localhost'=password('MyNewPass1!');

或 5.7以上的版本使用:

1
update mysql.user set authentication_string=password('MyNewPass1!')where user='root' ;

检查密码

1
SHOW VARIABLES LIKE '%password%';

添加远程登录用户

1
GRANT ALL PRIVILEGES ON *.* TO 'REMOTE_USER'@'%' IDENTIFIED BY 'MyNewPassword2!' WITH GRANT OPTION;