grant all on *.* to user_name@% identified by "your password"; revoke ALL ON mysql.* TO user_name@% identified by "your password";
你好,报如下错误 mysql> revoke ALL privileges ON mysql.* to u1@'%' identified by "123"; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to u1 @'%' identified by "123"' at line 1
revoke ALL ON mysql.* from user_name@%
mysql> revoke ALL ON mysql.* from u1@%; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%' at line 1 mysql> revoke ALL ON mysql.* from u1@'%'; ERROR 1141 (42000): There is no such grant defined for user 'u1' on host '%'
revoke ALL ON mysql.* TO user_name@% identified by "your password";
mysql> revoke ALL privileges ON mysql.* to u1@'%' identified by "123";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'to u1
@'%' identified by "123"' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '%' at
line 1
mysql> revoke ALL ON mysql.* from u1@'%';
ERROR 1141 (42000): There is no such grant defined for user 'u1' on host '%'