CentOS7安装mysql

yum search mysql

yum remove mariadb.x86_64

yum localinstall mysql

yum search mysql

yum install mysql-community-server.x86_64

ps -ef | grep mysql

service mysqld start

service mysqld restart

service mysqld stop

cat /var/log/mysqld.log | grep password

mysql -uroot -p密码

SET PASSWORD = PASSWORD(' xxxx ');

use mysql;

show tables;

select * from user \G

select host, user from user \G

update user set host="%" where Host='localhost' and user = "root";

flush privileges;