mysql创造数据库后出现Access denied for user 'root'@'%' to database ‘xxxx’

mysql创建数据库后出现Access denied for user root@% to database ‘xxxx’grant all on xxxx.* to ro

mysql创建数据库后出现Access denied for user 'root'@'%' to database ‘xxxx’
 

    grant all on xxxx.* to 'root'@'%' identified by 'password' with grant option;    xxxx代表创建的数据库;    password为用户密码,在此为root的密码



完成后即可!