mysql> grant select on *.* to 'na'@'%' identified by 'na';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
mysql> select user,host from mysql.user;
+--------+-----------------+
| user | host |
+--------+-----------------+
| na | % |
| root | 127.0.0.1 |
| root | localhost |
+--------+-----------------+
5 rows in set (0.00 sec)
mysql> source /data/soft/mysql/share/mysql/mysql_fix_privilege_tables.sql;
Query OK, 0 rows affected (0.00 sec)
mysql> grant select on *.* to 'nss'@'%' identified by 'na';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> drop user nss@'%';
Query OK, 0 rows affected (0.00 sec)
mysql>
转载于:https://blog.51cto.com/gaizaoren/307459