How to create a MySQL database in CPanel
By Eddie Machaalani
Once your Database and User have been created, you need to give that user permission to use that database. We do this by selecting the username we created from the drop down and the database we created from the drop down, making sure the "All" checkbox is selected and clicking the "Add User to DB" option. 
The last thing you will need is the MySQL server hostname. If this hasn't been supplied to you by your web host, you can get it from this screen in this location: 
Note that the Username and Database will be prepended with your Cpanel login name. For example, if you created a database called DB and your cpanel login was mysite then your new database will be mysite_db.
That's it. You're now ready to use the MySQL database that you just created.
5 Responses to "How to create a MySQL database in CPanel"
Fill in the form below to leave a comment and share your thoughts.|
said this on 30 Apr 2006 8:21:41 PM CST
Excellent - thanks for using pictures...perfect and what I am looking for.
|
Author/Admin)|
said this on 25 Jun 2006 7:49:29 PM CST
I agree with Deb...this is fantastic!!
|
|
said this on 01 Mar 2007 9:12:48 AM CST
Excellent help i really used it
|
|
said this on 26 Aug 2007 3:06:32 PM CST
Thanks! Obviously, this is a 'foundation' step, and so it's good to know that I've definitely done it right haha.
|
