• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Issue MySQL server no longer available in Plesk UI

MichaelCa

New Pleskian
Plesk 17.5.3

MySQL 3306 instance db server is no longer showing up in the UI... not under Tools and Settings > database servers. Nor under customer subscriptions for adding adding databases.

If I try to add the db server, I get a message that it is already registered.

When I look in psa under databaseservers, it does how an entry for it. I'm not seeing any issues with that entry.

+----+-------------------+------+-------+----------------+---------------+------------+
| id | host | port | type | server_version | parameters_id | last_error |
+----+-------------------+------+-------+----------------+---------------+------------+
| 1 | localhost | 3306 | mysql | 5.6.35 | [NULL] | no_error |
+----+-------------------+------+-------+----------------+---------------+------------+

How do I get the database server to show again in the UI?

I have considered removing the record for it from the databaseservers table and then going into the UI and adding it again. I tried this, get no error. But MySQL still does not appear in the panel.
 
Last edited:
What about

plesk repair db

Have you tried? Any errors in output?
 
Back
Top