1、解压MySQL压缩包
tar -xvf Percona-Server-5.7.23-23-r500fcf5-el7-x86_64-bundle.tar
2、卸载废弃的依赖包
yum remove mariadb*
3、进入到解压目录进行rpm安装,注意顺序不能乱
rpm -ivh Percona-Server-57-debuginfo-5.7.23-23.1.el7.x86_64.rpm
rpm -ivh Percona-Server-shared-compat-57-5.7.23-23.1.el7.x86_64.rpm
rpm -ivh Percona-Server-shared-57-5.7.23-23.1.el7.x86_64.rpm
rpm -ivh Percona-Server-client-57-5.7.23-23.1.el7.x86_64.rpm
rpm -ivh Percona-Server-server-57-5.7.23-23.1.el7.x86_64.rpm
4、启动MySQL服务
service mysqld start
5、修改默认密码
(1) 查看默认密码
cat /var/log/mysqld.log | grep "A temporary password" | awk -F " " '{print$11}'
(2)使用默认密码登录
mysql -u root -p
(3)修改密码
mysqladmin -u root password "root"
update user set authentication_string=passworD("root") where user='root';
6、常见错误
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
密码错误
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
修改 /etc/my.conf
在[mysqld] 下添加skip-grant-tables 这个配置然后保存文件。
MySQL5.7操作:
查找错误日志地址:SHOW VARIABLES LIKE '%error%'
-- /var/log/mysqld.log
查找变量地址:SHOW VARIABLES LIKE '%general%'
-- /var/lib/mysql/localhost.log
修改变量:SET GLOBAL general_log=ON;