HOWTO enable MySQL on your Plesk VPS

[charles]

Plesk comes with MySQL support, but doesn't have it installed by default. To install and enable it,

rdp/rdesktop to the vps

Go to Start -> control panel -> Add/remove Programs

Select Plesk 7.5.4 for windows -> Modify -> Expand "Database Management" option and select "MySQL server" continue and finish.

Thats it, mysql is now running on the vps on port 3306. "MySQL server" will now be listed in "plesk services monitor" in the taskbar on desktop.

Login to plesk now and in Server-> Databases -> MySQL tab, you can enter the port (3306) server (localhost) admin user and password for mysql and start using phpmyadmin and create mysql dbs for domains etc.

Thanks to Veena for writing this up.

charles

How would you do the same on a linux plesk ?

There is no support for Mysql on my server exept for maybe being able to check the version number and create a database....nothing else.

Thanks for your help.

[charles]

max_m, please open a ticket with support and they can help you with this. This has to be enabled on linux. I am guessing your just looking in the wrong place, or expecting to see something else.

One thing: It may happen that once you install MySQL in a way that Charles mentioned above it does not get properly configured with Plesk for Windows. Since, by default, Plesk puts a random generated password for client's end MySQL (the one you just installed per the first post), you need to reset it.

Open my.ini that is located in c:\SWSoft\Plesk\Databases\MySQL\Data (if not here, look in c:\Program Files\SWSoft\Plesk\Databases\MySQL\Data).

Add the following line:

skip-grant-tables

Then save, close and restart MySQL like this: double click the red icon in the right-down corner (Plesk Service Monitor), check MySQL and press 'restart' button.

Then open CMD (start -> run -> cmd) and navigate to c:\SWSoft\Plesk\Databases\MySQL\bin (or c:\Program Files\SWSoft\Plesk\Databases\MySQL\bin - if you are using older version of Plesk for Windows) and type the following command:

mysql -uadmin mysql

You should be logged in. Type the following command:

update user set password=password('newpassword')where user='admin';

Of course, change the "newpassword" with the password you wish to use.

After that, make sure to remove that "skip-grant-tables" line from my.ini and when you do so, restart MySQL again.

Login to Plesk and configure MySQL in the "Database" section as Charles already mentioned above.