Apache Friends Support Forum

I installed xampp and tried to add a root password. After I did that, every time I try to get to phpMyAdmin I get this error:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

I have uninstalled xampp and reinstalled it, yet I still get this error.

Also, SMTP was disabled when I installed xampp and I don't know if it should be active or not. If it should be enabled, how do I do it please?

You should be able to edit the file c:\xampp\phpMyAdmin\config.inc.php (your config.inc.php could be in a slightly different location).
Modify the line that reads

Code: Select all

$cfg['Servers'][$i]['password'] = '';

If your new password is porcupine, you should end up with

Code: Select all

$cfg['Servers'][$i]['password'] = 'porcupine';

I hope this helps.

--Jeff

Yes, either that, or change the config_type to "cookie" so you actually have to log in.

Thanks for your help but how to I edit the file. When I try to open it Windows tells me it doesn't recognise it and doesn't know what program to use to open it.

You can use your Windows notepad or better a php editor

I recommend using Aptana Radrails, but Notepad works just fine.

Thanks. I've downloaded Aptana and used that.

If you need PHP coloring, search for "Aptana Eclipse plugins".

Since we are getting into that, I'll cast my vote for Notepad++

I'll just try getting used to Aptana Studio first I think

I prefer something lite-weight. I'm thinking of trying Vim. I hear it has color coding and bracket matching. I want to see if there is a way to get xDEBUG running in Vim.