Bluehost 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 16,883 views bookmark tags: (updated 1267 days ago)


Was this resource helpful?

Did this resolve your issue?


Please add any other comments or suggestions about this content:





Recommended Help Content

Video

How to enable Telnet in Windows 7

How to enable telnet in Microsoft Windows 7. Telnet is a great tool for troubleshooting email, MySQL and other connection issues. (updated 1182 days ago)

Knowledgebase Article

FrontPage will not publish and my Wordpress is not working

Have FrontPage extensions and Wordpress installed on account. Was working fine in the past, but now cannot connect with FrontPage and Wordpress does not link properly. (updated 705 days ago)

Knowledgebase Article

Rails Troubleshooting

Rails Troubleshooting! (updated 163 days ago)

Related Help Content

Knowledgebase Article

How to take a Screenshot (Screen Capture)

Explains how to create screenshots(screen captures). (updated 196 days ago)

Knowledgebase Article

Telnet

Troubleshooting with telnet on different operating systems? (updated 1415 days ago)

Knowledgebase Article

Google AdWords offer is not working

My Google AdWords offer is not working. (updated 496 days ago)

Knowledgebase Article

Django Troubleshooting

While trying to deploy my Django application, I am getting error pages. (updated 1169 days ago)

Video

How to Increase the PHP Memory Limit

How to install the php.ini file and then increase the PHP Memory limit. (updated 744 days ago)

Video

How to change the WordPress URL

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 1182 days ago)

Knowledgebase Article

Email Troubleshooting

General Email issues where should I start? (updated 366 days ago)

Knowledgebase Article

FrontPage Extensions Corruption

Cannot publish site any more with FrontPage or FrontPage features stop working. (updated 1658 days ago)