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

Aquellos que tengáis un servidor virtual con Plesk, podéis encontraros que, al actualizarlo, no os deja crear usuarios o bases de datos MYSQL. El error que suele dar es:

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

Esto es porque la base de datos tiene algún error de permisos o está corrupta. La manera de arreglarlo es entrar en el servidor por SSH y poner:

mysql_fix_privilege_tables --user=admin --password=<admin passord> --verbose

Donde tenemos que substituir el usuario y la contraseña por los nuestros. Esto dará una lista de errores y arreglará los mismos. Verás que después de esto ya podremos hacerlo.

 

Os recomendamos los siguientes productos relacionados con la informática:

 

INIU Cable USB A USB C, [2m] QC 3,0 y 3,1A Cable USB C Carga Rapida, Aleación Trenzado de Nylon Cable USB Tipo C Cargador Compatible con iPhone 15 Pro Samsung S21 Huawei Xiaomi Pixel Android auto ECC.

(42259)

6,99 € (a partir de 25 abril, 2024 11:18 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

instax Link Wide Impresora para teléfonos, Color Blanco Ceniza.

(960)

111,88 € (a partir de 26 abril, 2024 02:16 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

kacbuy Memoria USB 982GB Alta Velocidad USB 3.0 Pen Drive Portátil Pendrive Metal Disco Duro Externo para Computadora TV Portátil Tableta Almacenamiento, con Llavero

(52)

17,99 € (a partir de 26 abril, 2024 02:16 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

WACOM BAMBOO SLATE LARGE,DIGITALIZADOR,DIESTRO Y ZURDO,21 X 29.7 CM,ELECTROMAGNETICO,INALAMBRICO,BLUETOOTH,GRIS MEDIO CON DETALLES NARANJA

(217)

202,66 € (a partir de 26 abril, 2024 02:17 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Philips 10 Unidades de Memoria USB 2.0 de 16 GB, para PC, portátil, Ordenador, 10 x 16 GB de Memoria de hasta 21 MB/s

(4)

36,12 € (a partir de 26 abril, 2024 02:16 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Rodzon Grabadora Externa USB 3.0, Unidades Portátil CD/DVD /-RW/ROM Estable con Lector/Quemador/Re - Quemador para Win 10/8 / 7 / XP/Vista/Linux/Mac OS

(12520)

18,99 € (a partir de 26 abril, 2024 02:16 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

TP-Link Archer AX58 - Router WiFi 6 AX3000, Doble Banda 2.4Ghz/5Ghz,1xWAN/4xLAN Puertp Gigabit, WPA3, OFDMA, WPS, Latencia Ultrabaja, HomeShield, Tecnología OneMesh, Negro

(1756)

64,99 € (a partir de 26 abril, 2024 02:17 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Blackview Tablet 10 Pulgadas, WiFi6 Tablet Android 13, Tab30WiFi Quad-Core Tablets, 6GB RAM 64GB ROM/TF 1TB, Widevine L1 FHD+ Tabletas, Cámara Dual/5100mAh/BT 5.2/Google GMS/Tipo C 2024 PC Tablet

(162)

75,98 € (a partir de 26 abril, 2024 02:16 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

alptte Memoria USB 256GB USB 3.0 Pendrive Impermeable Pen Drive Metal Disco Duro Externo para Computadora Tableta, con Llavero (256gb)

(79)

13,99 € (a partir de 26 abril, 2024 02:16 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Logitech M90 Ratón con Cable USB, Seguimiento Óptico 1000 DPI, Ambidiestro, PC, Mac, Portátil, Negro

(29457)

5,79 € (a partir de 25 abril, 2024 11:18 GMT +02:00 - Más informaciónProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)