breaker of stuff, destroyer of things

I’ve gotten a few hit’s this morning looking for answers about plesk and mysql. I’m guessing they we’re trying to figure out how plesk handles mysql.

manual changes

Simply put plesk will only work for mysql via it’s web frontend. (should note, i’m referring to listing db’s and users). Plesk actually has no awareness of your actual mysql db. what i mean by this is that if you manually make changes to mysql, they won’t be reflected in plesk.

updating plesk’s domain database’s tables

if you go to the master phpadmin interface you’ll see a database for plesk that has tables that tell it about your databases. after adding a database you’ll have to update this db with the proper associations (domain, client).

no root

Another gotta is that root won’t work on a mysql server setup by plesk. You’ll have to access the database as ‘admin’ using the same password used to access plesk.

adding db’s and users manually, via sql

I don’t know if plesk suports mysql 5, or maybe i just have a really old version. the only way to add a user is via grant. the new ways are not supported. you can add a db as normal, but will need to be ‘admin’ to do it.

last thoughts

If your doing anything manually, document it, and just don’t worry about adding it to plesk. I’ve killed the elsid server a few times playing around with the plesk tables to so that they would reflect a manual change i did.

Seriously it’s touchy, you can change everything back to how it was, and plesk will somehow remember that you touched it. If you go with plesk either do as much as you can via plesk, and handle the rest by hand, or do everything via hand, and let plesk sit there until you can’t get a terminal.

Hopefully this helps.