Issue Adding MySQL database: There are no database servers available for this subscription

[Michael Lodes]

After updating Plesk from Onyx to Obsidian I can't add new databases anymore. I get the error message: "There are no database servers available for this subscription.".

In windows event viewer I got the error from mysqlmng.exe:

MySQL configurator installation is corrupted: data directory 'C:\Program Files (x86)\Plesk\Databases\MySQL\Data' does not exist
at (LocalServiceHelper::LocalServiceHelper line 45)
at Unable to execute console command: '--repair-local-service'(vconsoleapp::start line 95)
at Unable to execute command: '"C:\Program Files (x86)\Plesk\admin\bin\mysqlmng.exe" --repair-local-service'(vconsoleapp::run line 117)
Execute file name: C:\Program Files (x86)\Plesk\admin\bin\mysqlmng.exe

I looked into "C:\Program Files (x86)\Plesk\Databases\MySQL\" and actually there is no "Data" directory. But i see while update time there was created a new directory called "Data" in "C:\Program Files (x86)\MySQL" !!!!!!!!!!!

I think the "Data" directory got created in the wrong directory. How could that happen? Is there now a quick solution for me? A workaround?

BTW: MySQL56 service is running without problems. I just cannot add new databases

 

[IgorG]

Try to use solution from this KB article for resolving the issue: How to change default MySQL directory %plesk_dir%\Databases\MySQL\data to another one?