I have an Apache server set up on my local machine and have been using phpMyAdmin to manage MySQL. I was installing a new program today and added a password to my root access. Now I get the error:

MySQL said:


Access denied for user: 'root@localhost' (Using password: NO)

Running a server on my local machine is new to me and I do not know how to get a login screen when using phpMyAdmin so that I can enter a password. My other option would be to clear the password that I set but I don't know how to do this either.

I would appreciate any help - it all goes into the learning curve.

Thanks in advance

Hello austinstace,

Perhaps this is obvious but you didn't mention that you already checked it, in your post.

Did you update the config.inc.php file inside the phpmyadmin folder?

If not, open it up and look for where you can add the password in it.

I've installed PHPMyAdmin on my Linux box and I have a different problem. Mysqld seesm to be running, but when I open the PHPMyAdmin page, I get this:

"Access denied for user: 'root@localhost' (Using password: YES)"

The password for root isn't wrong, but do I even want mysql accessing things as root? I noticed that during the install procedure there was an mysql account created. I don't see it in the /home directory though.

Thanks for any help!

Hello ruzel,

Access denied for user root@

That nearly always means you're trying to access a database that you do not have permissions to access... or not? It's really odd how you cannot seem to access the databases as 'root' though...

I remember once when I accidentally dropped the 'root' permissions in the `mysql` database; boy, that was a mess! I had to delete the mysql files, re-install MySQL and restore all the databases off a recent backup.

I really don't know about MySQL on Linux, I am still struggling with Linux at the moment so unless someone who uses Linux extensively, reads this and replies, I am also interested to know how you will eventually solve this.

It turned out that I was setting the password in the config file for PHPMyAdmin but had neglected to restart the mysqld server (It's always something like that with me).

For those that want to know, you can restart mysqld (on Linux RedHat 7) with

shell>service mysqld restart

That seemed to solve the problem.

/r

Hi
I've solved this problem, it's simple.
For some reason our phpmyadmin don't read the config.inc file, put your details in libraries/config.default file instead.

I don't know why but sometimes the phpmyadmin don't read the config file, so rename it to config.sample and use the other config file instead.

It works for me

Hi All,

when i go to localhost (phpMyAdmin folder is in htdocs folder in apache 2.2)
i am getting the following error
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
--------------------
config.inc.php
------------------------
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['PmaAbsoluteUri'] = '/localhost/phpMyAdmin/';
//$cfg['Servers'][$i]['host'] = 'MySQL.localhost.com'
$cfg['Servers'][$i]['host'] = 'localhost'
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'mysql';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;

please help
thanks
sumi

I find the easiest way to do this (not to mention most secure), is to set:
$cfg['Servers'][$i]['auth_type'] = 'http';

in config.inc.php

that way you dont have to write your password into the settings files and you just get handed a uername and password dialog when you want to use phpMyAdmin.

This means you can use root or any other user you know the password to at your leasure.

Hope this helps

More flexible as far as multiple users, yes...
However, caution that HTTP, alone, with PMA is NOT the "most secure" without HTTPS...note this from the PMA documentation: (yes, they DO claim "more secure" -- because it removes the need to store login information [as Couling mentioned] in the config files, but...)
--just my $0.02.