Your are here: Home // // Hostmonster MySQL Database and user name convention

Hostmonster MySQL Database and user name convention

Since we run a shared hosting environment, we have to uniquely identify your MySQL Users to your account ONLY. We do this by attaching your system username and an underscore("_") before all the MySQL Databases and MySQL Users YOU create. Example:

I added a new database (or user) and I filled in the name: mydatabase
The Real Database Name: username_mydatabase

This applies to ONLY your database name and database user, your password stays normal. Things to keep in mind:

* Your MySQL User that you enter can only be up to 7 characters long. We chop off everything else.
Example: testuser -> username_testuser
* 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 it is stored on your account, the server/host address will always be: localhost. Just like that, lowercase and one word.

If you're using remote database management software, the server would either be your domain name: example.com or the Shared Server IP
The shared server IP is found in the Stats section of the cPanel on left side.

filed under:

Leave a reply

Copyright © 2009 Web Hosting Reviews.
Designed by Theme Junkie. Converted by Wordpress To Blogger for WP Blogger Themes. Sponsored by iBlogtoBlog.