Databases

1. How do I create MySQL database and its user?

Login to Plesk control panel >> Click on Databases >> Add new database >> Enter DB name and select database type 'MySQL' >> Ok > Add new user >> Enter DB user and password >> Ok

Now click on DB-WeAdmin to access PHPMyAdmin area for database management.

2. What hostname, user and password do I use to connect to my MySQL database?

To connect to your MySQL database using a PHP script, you will need the following information:

Database (The database name would have been assigned at the time you created the database in Plesk Control Panel)
Username (The username to your database would have been configured at the time you created the database in Plesk Control Panel)
Password (The password to your database would have been configured at the time you created the database in Plesk Control Panel)
Hostname (The hostname for connecting to your MySQL database is 'localhost')