phpmyadmin - error on login
Posted by: TheDragon (
Date: June 10, 2006 11:11PM

yes - I read all the posts here
most gave different instructions
try to access from tray icon:
apache local host = works great
myphpadmin = got opening error MSG
researched FAQ at
followed these instructions:
We are now going to modify the 'root' user's password on host localhost. Click on the link "Edit" which is near to this user.

On this news page, you will see a "change password" zone.Fil in this zone and click on "Go".
Your password has just been modified. The rights in MySQL are loaded on startup so our modifications shouldn't be effective until we reboot our MySQL server or execute the "flush privileges" command. Actually, phpmyadmin should do that for you so privileges should be reloaded and you shouldn't be able to use phpmyadmin for the moment (phpmyadmin uses a root user with no password) :


MySQL said:

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

If not, just restart your MySQL server.

We are now going to change phpmyadmin configuration to reflect our changes. Open the file which is located in the phpmyadmin directory.

First, replace this line :

$cfg['PmaAbsoluteUri'] = '';


$cfg['PmaAbsoluteUri'] = 'localhost/phpmyadmin/';

This is to make disappear one of the error messages on phpmyadmin homepage.

Now you just need to add your new password :

$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'your new password'; // MySQL password (only needed with 'config' auth_type)

Save your file and it's done...++

2 points - I never got any line in the web page to edit
and - does this matter? -->
in the files it states in the beginning:
so, as I WAS editing the correct file anyway

I STTTTTTTTTTTTTTTill get a login error message ! ! ! !

Re: phpmyadmin - error on login
Posted by: TheDragon (
Date: June 10, 2006 11:19PM

I just changed
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?

from "config" to "http"
now, I get a pop-up box asking for my name/pwd smiling smiley
so . . . some progress
but when I fill in the prompts
I am denied

so. my guess is the username and pwd is stored somewhere else?

Re: phpmyadmin - error on login
Posted by: TheDragon (
Date: June 11, 2006 12:02AM

this is totally bizarre !!!!!!!!!
after trying 20 different ways to change the password though the command console
and getting a different syntax error EVERY time
I "Googled" --> [[ set password syntax MySQL ]]
and guess what I learned?
new installs for My SQL has NO PASSWORD for root access !
Guess what = logged in as Root and left the password field empty and I got in!
now why was this not covered in the readme files????????????????????????????

Sorry, only registered users may post in this forum.