HostMonster Web Hosting Help

MySQL Database and user name convention

Problem:

I cannot connect to my database locally or remotely, do I have the correct server, username and password?

Solution:

Since we run a shared hosting environment, we uniquely identify your MySQL users to your account ONLY. We do this by attaching your system's username and an underscore("_") before all the MySQL databases and MySQL users YOU create.

Example:

    In creating a New Database, you enter "db01"
    The real database name: username_db01.
This applies to both your database name and database user, your password stays normal or is not pre-pended like the name or user.

Things to keep in mind:

  • Your MySQL User can only be up to 7 characters long.
  • You also need to remember to add your MySQL User to your database after the two are created.
Database Server/Host Address:

If your script or program is going to be accessing our database locally, meaning script and database are on same account, the server/host address will always be: localhost, just like that, lowercase and one word.

If you are using Remote Database Management Software, the server would either be your domain name: example.com or the Shared Server IP (preferred choice). The shared server IP is found in the Stats section of the cPanel on left side.

Knowledgebase Article 125,668 views bookmark tags: cannot connect mysql name (updated 2021 days ago)


Was this resource helpful?

Did this resolve your issue?


Please add any other comments or suggestions about this content:





Recommended Help Content

I am prompted to set a new MySQL password. What does this mean and how do I change it? (updated 1095 days ago)
Knowledgebase Article 68,738 views tags: connect database mysql password phpmyadmin username

This article will explain how to change the password for a database in the event that the original password is lost. (updated 947 days ago)
Knowledgebase Article 31,486 views tags: database mysql password

This article will explain how to change or reset the password for a MySQL user. (updated 68 days ago)
Knowledgebase Article 1,392 views tags: change mysql password reset user

Related Help Content

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database. (updated 12 days ago)
Knowledgebase Article 476,643 views tags: creation database mysql

How can I connect to our MySQL database from Dreamweaver? (updated 1160 days ago)
Knowledgebase Article 101,340 views tags: connecting database dream mysql weaver

How do I grant permissions to cPanel for my MySQL database administrator without giving them the domain password? (updated 2149 days ago)
Knowledgebase Article 86,085 views tags: access mysql password permission

This article will explain how to connect your scripts to your MySQL databases. (updated 947 days ago)
Knowledgebase Article 30,373 views tags: database mysql scripts

How do I make my MySQL database compatible with the version you provide? (updated 2151 days ago)
Knowledgebase Article 84,627 views tags: database mysql

This article will explain how to convert a MySQL database to UTF-8. (updated 53 days ago)
Knowledgebase Article 861 views tags: character database encoding mysql utf

How do I import a backup of my database (.sql file) using phpMyAdmin? (updated 122 days ago)
Knowledgebase Article 169,011 views tags: database mysql phpmyadmin

I get the following database connection error: Warning: mysql_connect() [function.mysql-connect]: Host 'host#.HostMonster.com' is blocked because of many connection errors; unblock with 'mysqlad (updated 122 days ago)
Knowledgebase Article 105,795 views tags: blocked connection host localhost mysql