Mysql error mysql.servers doesn't exist when running flush privileges command

From thelinuxwiki
Revision as of 15:39, 17 May 2013 by Nighthawk (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

error:

 mysql> flush privileges;
 ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist

solution:

 # mysql_upgrade -u root -p
 ...
 ... some output excluded
 ...
 Running 'mysql_fix_privilege_tables'...
 OK