grant all privileges on yourDatabaseName to 'user'@'databaseIPAddress' identified by 'password' with grant option
授权生效
flush privileges
grant all privileges on yourDatabaseName to 'user'@'databaseIPAddress' identified by 'password' with grant option
授权生效
flush privileges
转载于:https://www.cnblogs.com/xcx-bwt/p/10604905.html