Ted Ted - 4 years ago 97
MySQL Question

Access denied for user 'root'. PHP/MYSQL/XAMPP

I have been using XAMPP for a while now, but this morning seems like something kinda went wrong.
I am using XP with XAMPP 5.3.5.

I develop at home, and I use my other computer as a server. running PHP/APACHE/MYSQL on XAMPP.
I am using phpMyAdmin to manage my db.
I noticed that my webpage was not responding too quickly, would lag and return an error about not being able to connect to the DB. (I lost that error message, I tried too many times).

  1. I ended up changing the root security password inside phpMyAdmin

  2. changed the config.inc.php for that very same password

Still I get this message:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in C:\xampp\htdocs\MyProject\includes\connection.php on line 5
Database connection failed: Access denied for user 'root'@'localhost' (using password: NO).

Why does it say "using password: NO" ? I did create a password for root, and also for the directory, and also updated config.inc.php
How do I recover from this, seems like a work day has passed by.
Thanks !!!

Answer Source

Rule #1: DO NOT USE root for application programming.

Try logging onto the database using the mysql client and your root password. If that doesn't work, you may have to reset your root password. The MySql docs have instructions for that.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download