1
2
3
4
5
6
7
$ mysql -uroot -p123456
> use mysql;
> GRANT ALL PRIVILEGES ON *.* TO "root"@"%" IDENTIFIED BY "123456" WITH GRANT OPTION;
> FLUSH PRIVILEGES;
> select host,password,user from user;
> quit
$ /etc/init.d/mysql restart