GRANT ALL PRIVILEGES ON *.* TO 'shsadmin'@'%'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;执行上面的sql语句:
提示:GRANT ALL PRIVILEGES ON *.* TO 'shsadmin'@'%'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;执行下面的语句则没问题
GRANT SELECT ON *.* TO 'shsuser'@'%'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;请指教,在线等
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;执行上面的sql语句:
提示:GRANT ALL PRIVILEGES ON *.* TO 'shsadmin'@'%'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;执行下面的语句则没问题
GRANT SELECT ON *.* TO 'shsuser'@'%'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;请指教,在线等
Access denied for user 'root'@'%' (using password: YES)上面标红的部分写错了
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.*
TO 'root'@'%' IDENTIFIED BY PASSWORD '*6FA1243E7B0D53304796DEB887543FFD702D35AB'
WITH GRANT OPTION感觉root的权限相当饱满啊
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'shsadmin'@'%'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;奇怪了 这样是可以执行成功的
IDENTIFIED BY 'f,d,r5080';去掉后面的with grant option;试试看吧。
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'shsadmin'@'%'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE,
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'shsadmin'@'localhost'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;有什么区别吗 请指教一下