HostMonster Web Hosting Help

MySQLi Troubleshooting

MySQLi is not working.

If the PHP version is PHP 5.2+ or higher, MySQLi will work without any problems.

Common problems with MySQLi are incorrect connection setting such as user_name, datebase_name and password.

The error is as follows for these types:

  Warning: mysqli_real_connect() [function.mysqli-real-connect]:
          (28000/1045): 
          Access denied for user 'username_name'@'localhost' (using password: YES/NO) 
        
          Couldn't connect :
          localhost: Connection error to server 'localhost' with user 'username_user'

The fastest fix is to look at the error and read it. For example, if "(using password: NO)", then you need to make sure your connection is using a password.
If "(using password: YES)", then make sure you are using the correct password.

If the error reports

  Couldn't connect :
          localhost: Connection error to server 'localhost' with user 'username_user'
Make sure you have added the user to the database and granted permissions to this user.

For more information on MySQLi, please visit PHP.net/mysqli

Keywords: mysqli
Knowledgebase Article 23,506 views bookmark tags: (updated 1729 days ago)


Was this resource helpful?

Did this resolve your issue?


Please add any other comments or suggestions about this content:





Recommended Help Content

How to enable telnet in Microsoft Windows 7. Telnet is a great tool for troubleshooting email, MySQL and other connection issues. (updated 1644 days ago)
Video "How-to" Tutorial 75,319 views tags: email microsoft troubleshooting windows

Rails Troubleshooting! (updated 625 days ago)
Knowledgebase Article 27,974 views tags: rails

Explains how to create screenshots(screen captures). (updated 658 days ago)
Knowledgebase Article 34,342 views tags: troubleshooting

Related Help Content

Troubleshooting with telnet on different operating systems? (updated 1877 days ago)
Knowledgebase Article 69,436 views tags: command mac macintosh windows

My Google AdWords offer is not working. (updated 958 days ago)
Knowledgebase Article 62,409 views tags: adwords code coupon google invalid

While trying to deploy my Django application, I am getting error pages. (updated 1631 days ago)
Knowledgebase Article 60,280 views tags: django

General Email issues where should I start? (updated 91 days ago)
Knowledgebase Article 52,910 views tags: blacklisted email

How to install the php.ini file and then increase the PHP Memory limit. (updated 17 days ago)
Video "How-to" Tutorial 146,143 views tags: limit troubleshooting wordpress

Need to change the URL in WordPress so that you can access your site? This tutorial will show you how to change the URL using phpMyAdmin so you can access your site using the temporary URL. (updated 1644 days ago)
Video "How-to" Tutorial 105,898 views tags: login troubleshooting wordpress

"Publish to the Web" isn't working in MS Publisher. Is there another way? (updated 2104 days ago)
Knowledgebase Article 112,889 views tags: microsoft publisher

FAQMasterFlex doesn't let me login to admin area (updated 2123 days ago)
Knowledgebase Article 50,865 views tags: register