远程的root用户不具备有授权的权限 ~~~ mysql> show grants for 'root'@'%'; +------------------------------------------------------------------+ | Grants for root@% | +------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD <secret> | | 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 <secret> WITH GRANT OPTION | | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION | +-----------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec)