MySQL----CentOS7系统安装部署MySQL

【原文链接】

1 进入/opt/ 目录下，下载mysql-server的源安装包

cd /opt
wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

2 安装下载的rpm包

yum localinstall mysql57-community-release-el7-11.noarch.rpm

3 通过yum 安装mysql-server

yum -y install mysql-community-server

4 启动mysql服务

systemctl start mysqld
systemctl status  mysqld

5 将mysql服务添加开机自启动

systemctl enable mysqld

6 查看默认密码

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

7 使用查找到的默认密码登录mysql

mysql -uroot -p

8 设置新密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password'

9 若需要远程链接数据库，则需要使用如下命令开启远程访问

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'new password';
flush privileges;

此时，即可以通过root和设置的新密码远程连接mysql数据库了