Creating a database in MySQL is a very easy task but with the newbie in mind I’ll show it here step by step.
Step by Step Tutorial
- Find the MySQL Databases icon on your CPANEL dashboard.
- Click the MySQL Database icon and you should be redirected to the database page. Find this:
- Enter your desired database name. For this tutorial I used weht725
- Click “Create Database” button and you should be redirected to a page like this:
- We have successfully created a database. Copy the created database name to a notepad. In this case, the database name is warrior5_weht725. You will be using this later.
- Click “Go Back” button and then scroll down and find the MySQL Users portion.
- Enter your desired username. In this tutorial I used wthy982. Click “Password Generator” button to automatically generate your database password.
- Click “Use Password” button.
- Click “Create User” button.
- Database username now created. Don’t forget to copy your new database username and generated database password to your notepad. You will be using this later.
In this example the database username is warrior5_wthy982 and the database password is aa-1P(xi*l7v.
Note: Your database password should be different from your cpanel password. I noticed some folks using the same password on the cpanel login and database!
Now, it’s time to connect your new MySQL database and new Database user.
- Click the “Go Back” button. Scroll down until you find the “Add User To Database” portion. If you have a lot of existing databases, simply match the new database you just created with the new username.
- Click “Add” button. (See Image above)
- Tick the box beside the “ALL PRIVILEGES” to select all boxes then click the “Make Changes” button.
- That’s it! You now a have a new functioning MySQL database.