CentOS 7下mysql 5.7 安装教程

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server[/code]

systemctl start mysqld.service

grep "password" /var/log/mysqld.log

mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new@password';

systemctl restart mysqld.service

show variables like '%character%';

vi /etc/my.cnf

#add by tangxiaobai
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

use mysql;
update user set host = '%' where user = 'root';

yum -y remove mysql57-community-release-el7-10.noarch