Know your MySQL database details

Database Location: The database location will always be localhost

Database Name: To find your database name login to the cPanel for your hosting package, commonly found at http://www.yourdomainname.com/cpanel (yourdomainname.com should be replaced with your actual domain name) and click on the MySQL Databases module. If you've already created your database you should see a table listing your database and database usernames. Your database name will be listed under the Database column.

Database name

Database Username: To find your database username login to the cPanel for your hosting package, commonly found at http://www.yourdomainname.com/cpanel (yourdomainname.com should be replaced with your actual domain name) and click on the MySQL Databases module. If you've already created your database you should see a table listing your database and database usernames. Your database username will be listed under the Users column.

Database username

Database Password: At the time that you chose setup your database, a password would've been assigned either by you or by cPanel, so you should have a record of this somewhere.

If you don't you can create a new username and password in the MySQL Databases module of cPanel.  Scroll down to the MySQL Users section and create a new username and password and click "Create User".

Once the user is created, attach that user to the database by going to the Add User to Database section of the MySQL Databases module and pair your username with the correct database.

If you have any questions about this, please contact us.

  • 16 Users Found This Useful
Was this answer helpful?

Related Articles

How to set up a remote MySQL connection

These instructions are for expert users only. Follow them at your own risk. You may be able to...

How to Setup a MySQL database

1. Login to the cPanel for your hosting package, commonly found at...