MySQL dba用户_系统用户 · MySQL DBA · 看云

远程的root用户不具备有授权的权限

~~~

mysql> show grants for 'root'@'%';

+------------------------------------------------------------------+

| Grants for root@% |

+------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD |

| GRANT ALL PRIVILEGES ON `champion`.* TO 'root'@'%' |

+------------------------------------------------------------------+

2 rows in set (0.00 sec)

mysql> CREATE USER 'log'@'*' IDENTIFIED BY 'log2018';

ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation

~~~

mysql> show grants for 'root'@'localhost';

+-----------------------------------------------------------------------------------------------------+

| Grants for root@localhost |

+-----------------------------------------------------------------------------------------------------+

| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD WITH GRANT OPTION |

| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |

+-----------------------------------------------------------------------------------------------------+

2 rows in set (0.00 sec)