Many times after compiling mysql to newer version, mysql always quitting with an error Table ‘mysql.servers’ doesn’t exist during flush privileges command. Apparently this issue arises sometimes with an incomplete MySQL upgrade.\u00a0 Beyond just installing new binaries you\u2019ll often need to run mysql_fix_privilege_tables command to ensure the \u2018mysql\u2019 database contains all the needed stuff.
\n{code type=css}[root@jfserver1 ~]# mysql_fix_privilege_tables –user=root –password=<root-pwd> –verbose
\nThis script updates all the mysql privilege tables to be usable by
\nthe current version of MySQL<\/p>\n
You can safely ignore all ‘Duplicate column’ and ‘Unknown column’ errors
\nbecause these just mean that your tables are already up to date.
\nThis script is safe to run even if your tables are already up to date!<\/p>\n
ERROR 1060 (42S21) at line 102: Duplicate column name ‘File_priv’
\nERROR 1060 (42S21) at line 108: Duplicate column name ‘Grant_priv’
\nERROR 1060 (42S21) at line 109: Duplicate column name ‘Grant_priv’
\nERROR 1060 (42S21) at line 110: Duplicate column name ‘Grant_priv’
\nERROR 1060 (42S21) at line 121: Duplicate column name ‘ssl_type’
\nERROR 1061 (42000) at line 131: Duplicate key name ‘Grantor’
\nERROR 1054 (42S22) at line 158: Unknown column ‘Type’ in ‘columns_priv’
\nERROR 1060 (42S21) at line 180: Duplicate column name ‘type’
\nERROR 1060 (42S21) at line 190: Duplicate column name ‘Show_db_priv’
\nERROR 1060 (42S21) at line 207: Duplicate column name ‘max_questions’
\nERROR 1060 (42S21) at line 217: Duplicate column name ‘Create_tmp_table_priv’
\nERROR 1060 (42S21) at line 220: Duplicate column name ‘Create_tmp_table_priv’
\nERROR 1060 (42S21) at line 328: Duplicate column name ‘Create_view_priv’
\nERROR 1060 (42S21) at line 331: Duplicate column name ‘Create_view_priv’
\nERROR 1060 (42S21) at line 334: Duplicate column name ‘Create_view_priv’
\nERROR 1060 (42S21) at line 340: Duplicate column name ‘Show_view_priv’
\nERROR 1060 (42S21) at line 343: Duplicate column name ‘Show_view_priv’
\nERROR 1060 (42S21) at line 346: Duplicate column name ‘Show_view_priv’
\nERROR 1060 (42S21) at line 363: Duplicate column name ‘Create_routine_priv’
\nERROR 1060 (42S21) at line 366: Duplicate column name ‘Create_routine_priv’
\nERROR 1060 (42S21) at line 369: Duplicate column name ‘Create_routine_priv’
\nERROR 1060 (42S21) at line 375: Duplicate column name ‘Alter_routine_priv’
\nERROR 1060 (42S21) at line 378: Duplicate column name ‘Alter_routine_priv’
\nERROR 1060 (42S21) at line 381: Duplicate column name ‘Alter_routine_priv’
\nERROR 1060 (42S21) at line 384: Duplicate column name ‘Execute_priv’
\nERROR 1060 (42S21) at line 387: Duplicate column name ‘Execute_priv’
\nERROR 1060 (42S21) at line 400: Duplicate column name ‘max_user_connections’
\nERROR 1060 (42S21) at line 409: Duplicate column name ‘Create_user_priv’
\nERROR 1060 (42S21) at line 431: Duplicate column name ‘Routine_type’
\nERROR 1060 (42S21) at line 499: Duplicate column name ‘character_set_client’
\nERROR 1060 (42S21) at line 505: Duplicate column name ‘collation_connection’
\nERROR 1060 (42S21) at line 511: Duplicate column name ‘db_collation’
\nERROR 1060 (42S21) at line 517: Duplicate column name ‘body_utf8’
\nERROR 1060 (42S21) at line 528: Duplicate column name ‘Event_priv’
\nERROR 1060 (42S21) at line 533: Duplicate column name ‘Event_priv’
\nERROR 1060 (42S21) at line 542: Duplicate column name ‘sql_mode’
\nERROR 1060 (42S21) at line 581: Duplicate column name ‘originator’
\nERROR 1060 (42S21) at line 585: Duplicate column name ‘time_zone’
\nERROR 1060 (42S21) at line 588: Duplicate column name ‘character_set_client’
\nERROR 1060 (42S21) at line 594: Duplicate column name ‘collation_connection’
\nERROR 1060 (42S21) at line 600: Duplicate column name ‘db_collation’
\nERROR 1060 (42S21) at line 606: Duplicate column name ‘body_utf8’
\nERROR 1060 (42S21) at line 618: Duplicate column name ‘Trigger_priv’
\nERROR 1060 (42S21) at line 621: Duplicate column name ‘Trigger_priv’
\nERROR 1060 (42S21) at line 624: Duplicate column name ‘Trigger_priv’
\ndone
\n[root@jfserver1 ~]# mysql -uroot -p -e “flush privileges”
\nEnter password:
\n[root@jfserver1 ~]#{\/code}
\nAs you may see, always flush privileges to test the table is already fix.<\/p>\n
Have fun.<\/p>\n","protected":false},"excerpt":{"rendered":"
Many times after compiling mysql to newer version, mysql always quitting with an error Table ‘mysql.servers’ doesn’t exist during flush privileges command. Apparently this issue arises sometimes with an incomplete MySQL upgrade.\u00a0 Beyond just installing new binaries you\u2019ll often need to run mysql_fix_privilege_tables command to ensure the \u2018mysql\u2019 database contains all the needed stuff. {code […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,9],"tags":[],"_links":{"self":[{"href":"https:\/\/www.jfdesignnet.com\/index.php?rest_route=\/wp\/v2\/posts\/21"}],"collection":[{"href":"https:\/\/www.jfdesignnet.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jfdesignnet.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jfdesignnet.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jfdesignnet.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=21"}],"version-history":[{"count":0,"href":"https:\/\/www.jfdesignnet.com\/index.php?rest_route=\/wp\/v2\/posts\/21\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.jfdesignnet.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=21"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jfdesignnet.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=21"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jfdesignnet.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=21"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}