ERROR 1142 CREATE command denied to user 'root'@'xxxxx

mysql>grant all on . to root@’%’ identified by ‘密码’;

mysql>flush privileges;