HostMonster Web Hosting Help

MySQL Errors

Summary

If you are having connections errors, please make sure you have followed the instructions on our Remote Database Connection Setup article.

Note: The most common problem in connecting is due to an incorrect username and/or password. Please make sure the username you use matches the username created in the "MySQL Database" section of your cPanel.


Examples of MySQL Errors:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'Username'@'localhost' (using password: YES) in /home1/examplec/public_html/config.php on line 3
Couldn't connect to server.

This kind of error clearly shows the issue. Access denied lets you know immediately that the database user or password is incorrect in your php file. The database and username must always have the appropriate prefix of username_ (replace username with your actual cPanel username and don't forget the underscore "_"). You can copy the correct spelling from your cPanel, under "MySQL Databases" section.

Parse error: syntax error, unexpected T_STRING in /home1/examplec/public_html/index.php on line 31

This kind of error means you have made a mistake in your coding. Generally, it is a missing punctuation, as PHP code is very sensitive. Unfortunately, our support staff is not trained to deal with coding issues and this may fall beyond our scope of support. Issues dealing with scripting, coding, or third party products may be best consulted with a professional programer, design group, or developer of the third party product.

Knowledgebase Article 14,782 views bookmark tags: errors mysql (updated 887 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 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 65 days ago)
Knowledgebase Article 103,757 views tags: blocked connection host localhost mysql

Optimizing MySQL: Queries and Indexes Article 2 of 4 Courtesy of: Ian Gilfillan Some knowledge of how indexes work allows you to use them more efficiently. Firstly, note that when you update a table w (updated 1402 days ago)
Knowledgebase Article 84,592 views tags: indexes mysql optimize optimizing queries query

Optimizing MySQL: Queries and Indexes Article 1 of 4 Courtesy of: Ian Gilfillan Badly defined or non-existent indexes are one of the primary reasons for poor performance, understanding and then fixing (updated 1011 days ago)
Knowledgebase Article 95,866 views tags: indexes mysql optimize optimizing queries query

Related Help Content

Optimizing MySQL: Queries and Indexes Article 4 of 4 Courtesy of:Ian Gilfillan Most systems need to be highly optimized for selects - take a news site which performs millions of queries per day, but w (updated 1401 days ago)
Knowledgebase Article 70,305 views tags: cpu exceeded index indexes mysql optimize optimizing queries query

Optimizing MySQL: Queries and Indexes Article 3 of 4 Courtesy of: Ian Gilfillan Ordering by surname is a common requirement, so it would make sense to create an index on surname. But in this example o (updated 1403 days ago)
Knowledgebase Article 76,715 views tags: cpu exceeded index indexes mysql optimize optimizing queries query

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

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

This article will describe connections strings, what they are used for, and give examples. (updated 523 days ago)
Knowledgebase Article 69,273 views tags: connection databases mysql

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

How do I avoid Outlook IMAP timeout errors? (updated 2097 days ago)
Knowledgebase Article 122,440 views tags: errors imap outlook

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