How to create a new MySQL user and database (video)

As you’ve probably learned, each new PHP Melody installation requires a MySQL database and a MySQL user for that database. In the following article we’ll show you how to create your MySQL user and database. The example was created using cPanel. If you’re using Plesk or Godaddy, the video might not make match sense.

In broad terms, here are the steps you need to follow:

Step 1: Log into your hosting control panel (cPanel, Plesk, etc.)

Step 2: Go to your MySQL database manager

Step 3: Create a new MySQL database

Step 4: Create a new MySQL user

Step 5: Add the new user to the new database by granting “All Privileges”.

The video might be a bit too fast to follow. Feel free to use the pause button.