在搭建完成之后输入正确的密码登陆失败,ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES),经仔细研究重新安装问题解决。
<1>检查是否安装:
rpm -qa | grep -i mysql
<2>卸载之前的安装:
rpm -e --nodeps 软件名 //强力删除,对相关依赖的文件也进行强力删除
<3>下载mysql的repo源
# wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
<4>安装mysql-community-release-el7-5.noarch.rpm包
# sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
安装这个包后,会获得两个mysql的yum repo源:/etc/yum.repos.d/mysql-community.repo,/etc/yum.repos.d/mysql-community-source.repo。
<5>安装mysql
# sudo yum install mysql-server
<6>重头戏:修改文件夹及文件的权限:
chown -R mysql:mysql /var/run/mysqld
chown -R mysql:mysql /var/lib/mysql/
<7>启动 mysql 服务
systemctl start mysqld
查看初始化随机生成的 root 密码:
sudo grep 'temporary password' /var/log/mysql/mysqld.log
执行shell> mysql -uroot -p,输入临时密码,登陆mysql成功
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxx'; /*XX为密码*/
<8>开启远程访问
update user set `host` = '%' where `user` = 'root' LIMIT 1;
<9>退出,重启mysql服务
systemctl restart mysqld