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:

 

Toshiba 2TB Canvio Basics Portable External Hard Drive, USB 3.2. Gen 1, Black (HDTB420EK3AA)

(49304)

79,75 € (as of 21 noviembre, 2024 08:46 GMT +01:00 - More infoProduct 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.)

Samsung Tablet 64 GB 4 GB RAM Gris Grafito

(1331)

165,44 € (as of 21 noviembre, 2024 08:46 GMT +01:00 - More infoProduct 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.)

Tarjeta Gráfica Gigabyte GEFORCE RTX 4070 SUPER 12 GB RAM

(316)

635,99 € (as of 21 noviembre, 2024 08:45 GMT +01:00 - More infoProduct 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.)

Unidad de disco para consolas PS5® Edición Digital (grupo de modelos slim)

(92)

290,00 € (as of 21 noviembre, 2024 04:06 GMT +01:00 - More infoProduct 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 K380 Teclado inalámbrico multidispositivo - Arena

(2068)

19,99 € (as of 21 noviembre, 2024 04:06 GMT +01:00 - More infoProduct 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.)

Bamkey Cable iPhone 2M 2Pack, Cable Cargador Original iPhone Carga Rapida [MFi Certificado], Cable iPhone USB Lightning Cable Carga Rapida Cable para iPhone 14/13/12/11 Pro Max/XS/8/7/6/5/SE, iPad

(38)

6,39 € (as of 21 noviembre, 2024 08:46 GMT +01:00 - More infoProduct 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.)

Canon Pixma TS3550i Impresora Multifunción 3 en 1, Sistema de Inyección de Tinta, Impresión, Escaneo y Copia, WiFi, Pixma Print Plant, Impresión Doble Cara, Impresión Fotográfica, Negro

(9859)

44,50 € (as of 21 noviembre, 2024 04:06 GMT +01:00 - More infoProduct 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.)

Amazon Basics - MicroSDXC, 128 GB, con Adaptador SD, A2, U3, velocidad de lectura hasta 100 MB/s, Negro

(96174)

10,89 € (as of 21 noviembre, 2024 08:45 GMT +01:00 - More infoProduct 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.)

Samsung Galaxy Tab S9 FE - Tablet + Cargador, 128 GB, Wifi, S Pen incluido, Batería de Larga Duración, Clasificación IP 68, Gris (Versión Española)

(101)

335,04 € (as of 21 noviembre, 2024 08:46 GMT +01:00 - More infoProduct 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.)

Seagate Technology Expansion Card para Xbox Series X|S, 2 TB, Plug and Play Unidad de Estado sólido NVMe, oficialmente autorizado ,2 años Rescue Services (STJR2000400)

(17844)

203,99 € (as of 21 noviembre, 2024 08:45 GMT +01:00 - More infoProduct 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.)