Table ‘mysql.servers’ doesn’t exist Error en MYSQL

El otro día al trabajar con algunos de nuestros servidores vimos que no podían manejar unas tablas de SQL porque daba un error: Table ‘mysql.servers’ doesn’t exist. En nuestro caso en Virtualmin.

Este error parece que suele dar cuando ha habido una actualización de mysql que no está hecha correctamente del todo.Os decimos los pasos para arreglarlo.

1. Paso 1:  Ejecutar: mysql_upgrade -u “mysql admin account” -p   En mysql admin account poned vuestro usuario administrador de mysql. Os va a preguntar una contraseña (la de admin).
   Después de ejecutar esto las unas tablas. Puede que algunas de el error siguiente:

   error    : Table upgrade required. Please do "REPAIR TABLE `xxxx`" or dump/reload to fix it!

2. Paso 2:  Parece ser que este error es por un fallo en los índices. Se puede arreglar fácil, no os preocupéis. Para ello corred el siguiente comando:
   mysqlcheck –check-upgrade –all-databases –auto-repair -u “mysql admin account” -pRecordad sustituir mysql admin account por vuestra contraseña de administrador de mysql. Después de poner la contraseña os arreglará las bases de datos.

Con esto ya podréis trabajar con el Virtualmin o con las bases de datos como lo estuvierais haciendo.

 

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

 

Lenovo Tab M11 - Tablet de 11" 1920 x 1200 px (MediaTek Helio G88, 8GB RAM, 128GB Ampliables hasta 1 TB, 4 Altavoces, WiFi, Bluetooth, Android 13) - Color Gris Luna - Incluye Tab Pen

(571)

191,99 € (as of 20 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.)

SHUBEIEUMI USB Bluetooth 5.4 Adaptador Bluetooth para PC, PC Dongle Bluetooth Adapter USB, para PC Windows 7/8.1/10/11, para Computadora Portátil Impresora Auricular Ratón

(22)

7,29 € (as of 20 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.)

Mochila antirrobo para laptop, mochila de viaje de negocios con bloqueo de puerto de carga USB, resistente al agua, mochila de trabajo para hombres y mujeres, se adapta a portátiles de 15.6 pulgadas,

(14094)

39,99 € (as of 20 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.)

Acer Aspire 3 A315-44P-R4SS, Ordenador Portátil 15,6” Full HD (‎AMD Ryzen 5 5500U, 8 GB RAM, 512 GB SSD, AMD Radeon Graphics, Windows 11 Home) Plata, Teclado QWERTY Español

(53)

399,99 € (as of 20 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.)

Apple Mac Mini Ordenador de Mesa con Chip M4, CPU de 10 núcleos y GPU de 10 núcleos: diseñado para Apple Intelligence, 16 GB de Memoria unificada, SSD de 256GB, Gigabit Ethernet

(5)

718,00 € (as of 20 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.)

Cable USB C a Lighting 1M 2Pack[Certificado MFi], Cable Cargador iPhone Carga Rapida Cable iPhone USB C Cable Tipo C a Lighting iPhone Charger Cable para iPhone 14 Pro Max/13/12/11/X/XS/XR/8/7/6/SE

(24)

6,99 € (as of 20 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,99 € (as of 20 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.)

Lápiz para Pantalla Táctil, Lápiz para iPad 2018 a 2024, Lápiz Stylus de Rechazo de Palma Lápiz, Lápiz iPad con 3 Puntas, Lapiz Táctil con Función Detección de Inclinación

(21570)

25,89 € (as of 20 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.)

Aioneus Cable iPhone 1M Cable iPhone Carga Rápida MFi Certificado Cable USB iPhone, Cable Cargador iPhone Nylon Trenzado Lightning Cable para iPhone 14 13 12 11 Pro XS MAX XR X 8 7 6S 6 Plus 5 5S,iPad

(32274)

4,99 € (as of 20 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.)

HP Cartucho de tinta original negro de alto rendimiento 305XL

(19894)

20,99 € (as of 20 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.)