mysql不能远程连接解决办法（Host is not allowed to connect to this MySQL server）

重启服务。
service mysqld restart




mysql -uroot -p




show databases;


root用户现在没有密码，你希望的密码修改为123456
mysqladmin -u root password 123456
root现在有密码了（123456），修改密码为abcdef：
mysqladmin -u root -p123456 password abcdef 




修改密码
use mysql;
update user set password=password("12345") where user="root";
flush privileges;


创建
CREATE DATABASE  `finance` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;




mysql不能远程连接解决办法（Host is not allowed to connect to this MySQL server）


use mysql;


update user set host = '%' where user = 'root';出现Duplicate entry '%-root' for key 1，不用管。


select host, user from user; 


GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;