Here is my problem: I am try to config a sv XAMPP 1.7.3.

No problem. I tested, it works also in shell.

Now, when I type localhost, it loads perfectly as long as it is the xampp defaut.

If I am trying to upload my site with mysql DB, it says: Access denied for user rootlocalhost (using password: NO).

I tried all the methods, modifying the config.php in my adminphp no result.

I must say that if I delete the root pass (leave it blank), my website (localhostmysite) loads perfectly.

You are getting this while trying to log into phpMyAdmin or via another method How are you setting the password How are you importing this database What is the value of cfgServersiauthtype in xamppphpmyadminconfig.inc.php.

In phpmyadmin I am entering without problems with the root and its password.

The database is imported and its working perfectly when I put no password for root.

But when I define the password.

BANG. error. trying from my IE to access 127.0.0.1mysite.

Serversiauthtype in xamppphpmyadminconfig.inc.php the value is cookie.

I also tried the other var, but without success as long as root has a password.

October 2008 05:10 Location: Yeppoon, Australia Time Zone: GMTUTC10.

Much simple, when I put a pass for the root, I cant access the php prg.

If you change the database for the SQL server, you need to adjust your website to use the new password.

Also, it is generally not a good idea to use the root user as a general purpose account or for website interactions.

It would be better to create a user that can only access the databases it needs and only has the permissions that it needs.

Access Denied For User 'Root'@'Localhost' On Mac