Linux 安装mysql

yum install mysql-server -y

chkconfig --list | grep mysql
chkconfig mysqld on

# /etc/init.d/mysqld start     
# service mysqld start

show databases;

grant all on *.* to root@'%' identified by 'youpassword';

flush privileges;

use mysql;

show tables;

select host,user from user;

delete from user where host !='%';

update user set password=password("new password") where user='root';

exit;
mysql -u root -p