I usually find Plesk to be extremely limiting, but there are servers where I just have no choice but to use it. Just now I needed to create two separate databases that could be used by the same user -- something that Plesk simply won't let you do.
I found this article to be extremely helpful, and the only elements that were different (probably because of differing versions of the software) were:
- The plesk database was called psa
- There were many more columns in the mysql.db table
- I also had to run the following command as the root db user:
51&q=GRANT&lr=lang_en">GRANT 51&q=ALL&lr=lang_en">ALL 51&q=PRIVILEGES&lr=lang_en">PRIVILEGES 51&q=ON&lr=lang_en">ON `[new_db]`.* 51&q=TO&lr=lang_en">TO '[user]'@'%'
Other than that, it worked like a charm, thank goodness!