|
Why am I having trouble accessing my MySQL database?
The three most common errors when your connection to a database through telnet or through a PHP or JSP script fails are that 1) you are using the incorrect hostname 2) you are using the wrong username and database name or 3)your user is not added to the database. 1) Your hostname will need to be either 127.0.0.1 or localhost. 2) All database names and usernames are prepended with the main username and an underscore. If, for instance, you create a database called db1 and the main username is user, the database name is really user_db1. The username follows the same naming conventions. 3) Log into your control panel. Select advanced features. Then select SQL Databases. Now make sure that your user that you created is assigned to the database. If it is not just select the data base and user name. Now click "Add user to DB" support@mercuryd.com |