If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
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.
January 30th, 2008 at 2:06 pm
Hi!
This is great info. I’m trying to work in the restricted world of plesk to setup a shared database between three related websites. Any ideas as to how to do that?
Thanks,
Tim
January 30th, 2008 at 3:04 pm
hey Tim,
In order to share a db across multipule sites use the same username, password, and db across each site. also you might have to add a % domain entry for the user
Sid