Set Up cPanel MySQL Database and User
Posted by SEO Admin on 21 April 2015 04:09 PM
Each database you use on your account needs to have a distinct name. Each database you connect to needs a database username assigned to the database so your scripts/website can connect to it. For this document, we'll assume you have the domain name example.com, and your cPanel login/username is example.
Create a New Database
Your database name will automatically be prefixed with your cPanel username. Anytime you need to reference the database, it will look like this: example_mydb.
Create a Database User
Each database needs a username to allow connections. To create a database user:
Your database username will automatically be prefixed with your cPanel username, so be sure to reference the full username in your scripts:
Add User to Database
Finally, you need to associate the new username with the database. To do so:
That's it. You've created a database, a database user and connected the two together. Here's the information you will use for your scripts (such as Wordpress or vBulletin):