# service mysqld restart
初次安装mysql是root账户是没有密码的
设置密码的方法
# mysql -uroot
mysql> set password for 'root'@'localhost' = password('123456');
mysql> exit
搞定!
查询用户表
use mysql
select host,user,password from user;
通过mysql命令进入之后
执行sql:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
delete from user where host !='%';
flush privileges;