步骤一:安装MySQL
(1)更新YUM源
# rpm -Uvh http://dev.mysql.com/get/mysql57-community- release-el7-9.noarch.rpm
(2)安装MySQL
# yum -y install mysql-community-server
(3)查看MySQL版本号
# mysql -V
步骤二: 配置MySQL
(1) 启动并开机自启动MySQL
# systemctl start myslqd
# systemctl enable mysqld
(2)获取root用户的初始随机密码
# grep 'temporary password' /var/log/mysqld.log
(3)对MySQL进行安全性配置
# mysql_secure_installation
- 重置root用户的密码
Enter password for user root: #输入上一步获取的root用户初始密码
Change the password for root ? ((Press y|Y for Yes, any other key for No) : Y #是否更改root用户密码,输入Y
New password: #输入新密码,长度为8至30个字符,必须同时包含大小写英文字母、数字和特殊符号。特殊符号可以是()` ~!@#$%^&*-+=|{}[]:;‘<>,.?/
Re-enter new password: #再次输入新密码
Estimated strength of the password: 100 Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : Y
- 输入Y删除匿名用户账号
By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment.Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y #是否删除匿名用户,输入YSuccess.
- 输入Y禁止root账号远程登录
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y #禁止root远程登录,输入YSuccess.
- 输入Y删除test库以及对test库的访问权限
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Y #是否删除test库和对它的访问权限,输入Y- Dropping test database...Success.
- 输入Y重新加载授权表
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y #是否重新加载授权表,输入YSuccess.All done!