Connection settings for MySQL databases

To connect to a MySQL database on your account, you will require the following 5 pieces of info:

  1.     Hostname
  2.     Database name
  3.     Database username
  4.     Database password
  5.     Connection settings

If connecting from a script on the server, the hostname is “localhost”.

If connecting remotely, the hostname is your domain name.

If you encounter difficulties when using “localhost”, try using the IP address 127.0.0.1.

The database name and database username must be entered exactly as they appear in the MySQL Databases section of your control panel (cPanel).

Remember that when you name a database or create a username, your cPanel username will always be added to the beginning. For example, if your cPanel username is “zebra123” and you create a database called “savanna”, your database name will actually be: zebra123_savanna.

Note that there is an 8-character limit on database usernames. If you enter a username longer than 8 characters, those extra characters will be automatically dropped.

Although it is possible to have more than one username assigned to a database, HostPapa strongly recommends against doing this.

The database password refers to the password you specified when creating the database username. Forget your user password? You may be able to find it in the script’s config file or you can remove the username from the database and then create a new password by adding the username back again. Note, though, that you may need to edit the script’s config file if you use the latter method.

Make sure you have added the database user to the database by selecting the user and the database from the drop-down lists and then clicking on the Add User to DB button. You should see connection code provided if you have done this.

Here’s a helpful video tutorial about how to set up MySQL databases in cPanel:
http://hostpapasupport.com/tutorials/demos/cpanel-x3-voice-new/cpanel-x3-createmysql.html

If you will be connecting to your database remotely, check out this article about remote connection settings:
http://hostpapasupport.com/kb/connecting-remotely-to-mysql/

Useful tutorials on using phpMyAdmin are here:
http://www.hostpapasupport.com/tutorials/Tutorials_phpMyAdmin.shtml

This article is also available in: French, Spanish, German

  • Was this article helpful ?

  • yes   no

Related Articles