【原文链接】
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数据库了