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 o开发者_如何学Pythonther 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).
- I ended up changing the root security password inside phpMyAdmin
- 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 !!!
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.
Have you tried with root
as both the username and password?
you might try searching your browser cookies for "localhost". you could then delete any pma related items as they may contain outdated credentials
Simply to add the password or remove the existing one
1. Go to your root of phpmyadmin. Select the user tab.
2. Select the user that you assign.
3. Click on Edit Privileges.
4. Find on login information fieldset
5. Adjust the password you wanna set
That's it may helpful
I know this sounds sounds bizarre, but on my new installation on Win7, using the Xampp stack, I typed '127.0.0.1' in 'username' field, and left 'password' blank. It took me straight to the control panel!
XAMPP has a weird default configuration and accepts any user from any host. So the first time you open phpMyAdmin just use localhost for the server and don't type any user/pass. Once you're in delete both "Any" user accounts and create your own.
精彩评论