pinchaiconos.com

TUCuando el servidor Plesk no te deja crear usuarios para una base de datos MySQL y te muestra el error:

Error: La conexión con el servidor de base de datos ha fallado:

Table 'mysql.servers' doesn't exist

Tienes que tener acceso root al servidor para poder arreglar (fix) las tablas de permisos.

Para arreglarlo accedes por ssh como root y ejecutas el siguiente script:

mysql_fix_privilege_tables --user=admin --password=(TUPASSWORDDEADMIN) --verbose

This script updates all the mysql privilege tables to be usable by
the current version of MySQL
You can safely ignore all 'Duplicate column' and 'Unknown column' errors
because these just mean that your tables are already up to date.
This script is safe to run even if your tables are already up to date!

ERROR 1060 (42S21) at line 132: Duplicate column name 'File_priv'
ERROR 1060 (42S21) at line 138: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 139: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 140: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 151: Duplicate column name 'ssl_type'
ERROR 1061 (42000) at line 161: Duplicate key name 'Grantor'
ERROR 1054 (42S22) at line 188: Unknown column 'Type' in 'columns_priv'
ERROR 1060 (42S21) at line 210: Duplicate column name 'type'
ERROR 1060 (42S21) at line 220: Duplicate column name 'Show_db_priv'
ERROR 1060 (42S21) at line 237: Duplicate column name 'max_questions'
ERROR 1060 (42S21) at line 247: Duplicate column name 'Create_tmp_table_priv'
ERROR 1060 (42S21) at line 250: Duplicate column name 'Create_tmp_table_priv'
ERROR 1060 (42S21) at line 375: Duplicate column name 'Create_view_priv'
ERROR 1060 (42S21) at line 378: Duplicate column name 'Create_view_priv'
ERROR 1060 (42S21) at line 381: Duplicate column name 'Create_view_priv'
ERROR 1060 (42S21) at line 387: Duplicate column name 'Show_view_priv'
ERROR 1060 (42S21) at line 390: Duplicate column name 'Show_view_priv'
ERROR 1060 (42S21) at line 393: Duplicate column name 'Show_view_priv'
ERROR 1060 (42S21) at line 410: Duplicate column name 'Create_routine_priv'
ERROR 1060 (42S21) at line 413: Duplicate column name 'Create_routine_priv'
ERROR 1060 (42S21) at line 416: Duplicate column name 'Create_routine_priv'
ERROR 1060 (42S21) at line 422: Duplicate column name 'Alter_routine_priv'
ERROR 1060 (42S21) at line 425: Duplicate column name 'Alter_routine_priv'
ERROR 1060 (42S21) at line 428: Duplicate column name 'Alter_routine_priv'
ERROR 1060 (42S21) at line 431: Duplicate column name 'Execute_priv'
ERROR 1060 (42S21) at line 434: Duplicate column name 'Execute_priv'
ERROR 1060 (42S21) at line 447: Duplicate column name 'max_user_connections'
ERROR 1060 (42S21) at line 456: Duplicate column name 'Create_user_priv'
ERROR 1060 (42S21) at line 478: Duplicate column name 'Routine_type'
ERROR 1054 (42S22) at line 603: Unknown column 'Event_priv' in 'where clause'
ERROR 1060 (42S21) at line 619: Duplicate column name 'sql_mode'
ERROR 1060 (42S21) at line 658: Duplicate column name 'originator'
ERROR 1060 (42S21) at line 662: Duplicate column name 'time_zone'
ERROR 1060 (42S21) at line 665: Duplicate column name 'character_set_client'
ERROR 1060 (42S21) at line 671: Duplicate column name 'collation_connection'
ERROR 1060 (42S21) at line 677: Duplicate column name 'db_collation'
ERROR 1060 (42S21) at line 683: Duplicate column name 'body_utf8'
ERROR 1054 (42S22) at line 693: Unknown column 'Trigger_priv' in 'where clause'
done

Con un poco de suerte habras corregido las tablas del MySQL.

P.D.: No me gusta nada el Plesk, al final siempre te toca acceder directamente al servidor...