MySQL5.7 Linux安装流程

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;