Knowledgebase

Problem:

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

Solution:

We have to uniquely identify your MySQL Users to your account ONLY, since we run a shared hosting environment. We can do this by attaching your system username and an underscore("_") before all the MySQL Databases and MySQL Users YOU create. Example: I inserted 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: billybob -> username_billybo - 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: whatever.com, or the Shared Server IP(if dns/nameservers aren't pointing to us): found in the stats section of the cPanel. If the left column of cPanel shows a Dedicated IP address instead of a Shared Server IP, then please contact us so we can inform you of the correct IP address to use. Also, you will need your ip whitelisted on our firewall so you can access our server via port 3306.

Keywords: mysql user name hostname server address can not connect disconnected

Add to Favourites

Print this Article