Plesk Table ‘mysql.servers’ doesn’t exist

Merhaba Arkadaşlar,

Error: Connection to the database server has failed:
Table ‘mysql.servers’ doesn’t exist

Hatası alıyor iseniz sunucuya ssh girişi yaptıktan sonra aşağıdaki komutu çalıştırmanız yeterlidir.

[root@server ~]# mysql_fix_privilege_tables –user=admin –password= –verbose

Aşağıdaki gibi bir sonuç ortaya çıkması ile problem giderilmiş olacaktır.

This script updates all the mysql privilege tables to be usable by
the current version of MySQL

ERROR 1060 (42S21) at line 102: Duplicate column name ‘File_priv’
ERROR 1060 (42S21) at line 108: Duplicate column name ‘Grant_priv’
ERROR 1060 (42S21) at line 109: Duplicate column name ‘Grant_priv’
ERROR 1060 (42S21) at line 110: Duplicate column name ‘Grant_priv’
ERROR 1060 (42S21) at line 121: Duplicate column name ‘ssl_type’
ERROR 1061 (42000) at line 131: Duplicate key name ‘Grantor’
ERROR 1054 (42S22) at line 158: Unknown column ‘Type’ in ‘columns_priv’
ERROR 1060 (42S21) at line 180: Duplicate column name ‘type’
ERROR 1060 (42S21) at line 190: Duplicate column name ‘Show_db_priv’
ERROR 1060 (42S21) at line 207: Duplicate column name ‘max_questions’
ERROR 1060 (42S21) at line 217: Duplicate column name ‘Create_tmp_table_priv’
ERROR 1060 (42S21) at line 220: Duplicate column name ‘Create_tmp_table_priv’
ERROR 1060 (42S21) at line 345: Duplicate column name ‘Create_view_priv’
ERROR 1060 (42S21) at line 348: Duplicate column name ‘Create_view_priv’
ERROR 1060 (42S21) at line 351: Duplicate column name ‘Create_view_priv’
ERROR 1060 (42S21) at line 357: Duplicate column name ‘Show_view_priv’
ERROR 1060 (42S21) at line 360: Duplicate column name ‘Show_view_priv’
ERROR 1060 (42S21) at line 363: Duplicate column name ‘Show_view_priv’
ERROR 1060 (42S21) at line 380: Duplicate column name ‘Create_routine_priv’
ERROR 1060 (42S21) at line 383: Duplicate column name ‘Create_routine_priv’
ERROR 1060 (42S21) at line 386: Duplicate column name ‘Create_routine_priv’
ERROR 1060 (42S21) at line 392: Duplicate column name ‘Alter_routine_priv’
ERROR 1060 (42S21) at line 395: Duplicate column name ‘Alter_routine_priv’
ERROR 1060 (42S21) at line 398: Duplicate column name ‘Alter_routine_priv’
ERROR 1060 (42S21) at line 401: Duplicate column name ‘Execute_priv’
ERROR 1060 (42S21) at line 404: Duplicate column name ‘Execute_priv’
ERROR 1060 (42S21) at line 417: Duplicate column name ‘max_user_connections’
ERROR 1060 (42S21) at line 426: Duplicate column name ‘Create_user_priv’
ERROR 1060 (42S21) at line 448: Duplicate column name ‘Routine_type’
ERROR 1054 (42S22) at line 573: Unknown column ‘Event_priv’ in ‘where clause’
ERROR 1060 (42S21) at line 589: Duplicate column name ‘sql_mode’
ERROR 1060 (42S21) at line 628: Duplicate column name ‘originator’
ERROR 1060 (42S21) at line 632: Duplicate column name ‘time_zone’
ERROR 1060 (42S21) at line 635: Duplicate column name ‘character_set_client’
ERROR 1060 (42S21) at line 641: Duplicate column name ‘collation_connection’
ERROR 1060 (42S21) at line 647: Duplicate column name ‘db_collation’
ERROR 1060 (42S21) at line 653: Duplicate column name ‘body_utf8′
ERROR 1054 (42S22) at line 663: Unknown column ‘Trigger_priv’ in ‘where clause’
done

Eksik mysql güncellemelerde veya yeni sürümü derleme sırasında hata oluşabilmektedir. Bu yüzden arada bir mysql_fix_privilige_tables komutunu çalıştırmanızı tavsiye ederim.

Saygılar,
Admin

188 Responses to “Plesk Table ‘mysql.servers’ doesn’t exist”

Sayfalar: « 4211 10 9 8 7 6 5 4 3 2 [1] Show All

  1. 5
    payday loans Says:

    I’m amazed, I have to admit. Rarely do I come across a blog that’s both equally educative and entertaining, and without a doubt, you’ve hit the nail on the head. The problem is an issue that not enough people are speaking intelligently about. I am very happy I found this in my hunt for something regarding this.

  2. 4
    philippine singles Says:

    Is it possible to copy and paste news articles for my blog or is that copyright infringement?

  3. 3
    dating site philippines Says:

    my sister and I want to start a blog page together?

  4. 2
    Issac Maez Says:

    I just want to say I am all new to blogs and absolutely enjoyed this web-site. Very likely I’m want to bookmark your blog post . You surely have remarkable articles and reviews. Kudos for sharing with us your web site.

  5. 1
    Salvador Sciacca Says:

    I simply want to mention I am just all new to blogging and site-building and certainly loved this page. More than likely I’m want to bookmark your site . You really come with remarkable writings. Many thanks for revealing your web page.

Sayfalar: « 4211 10 9 8 7 6 5 4 3 2 [1] Show All

Leave a Reply

 Characters available