CentOS7安装MySql5.7完整教程

rpm -qa | grep mariadb

rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

cd /opt/

wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

rpm -ivh mysql57-community-release-el7-9.noarch.rpm

cd /etc/yum.repos.d/

yum install mysql-server -y --nogpgcheck

systemctl start mysqld

grep 'temporary password' /var/log/mysqld.log

mysql -uroot -p

exit;

vim /etc/my.cnf

socket下添加：

skip-grant-tables
character_set_server=utf8
init_connect='SET NAMES utf8'

systemctl restart mysqld

mysql -uroot -p

use mysql;

flush privileges;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'ok';

update user set Host='%' where User='root';

flush privileges;

exit;