bradkoch2007 wrote:I went into the task manager to make sure the mysql daemon was running. mysqld.exe was not present, but mysqld-nt.exe was...
mysqld.exe is the non XP Service version of mySQL and
mysqld-nt.exe is the XP Service version selectable in the XAMPP Control Panel. For most things I use the XAMPP Control Panel and only go manual if I need to fix or solve problems with the server or its parts.
Now we have established you have mySQL running the next step is to investigate the
'access denied' error message.
Open
xampp/phpmyadmin/config.inc.php in your fav. text editor and find the following entry, which is the default settings as used with an XAMPP install:
- Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)
As you can see you need to enter a password if the Authentication method used is
'config'I remember having some issues like you have at the moment until I changed the Authentication method to
'cookie' as in the below code which is what I use at the moment and which is the method that best works for me:
- Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)
So, you need to change the Authentication method to another method other than
'config' or enter your root password in the required field (between the
' ' as in
'password') if you use the
'config' Authentication method.
As a side note here, when I tried entering my root password in the
'config' authentication method the error message changed from:
"Access denied for user 'root'@'localhost' (using password: NO)"
To:
"Access denied for user 'root'@'localhost' (using password: YES)"
Thats when I plumped for the
'cookie' Authentication method which has worked ever since.
You may have to stop then restart mysql for the changes to be recognised.
This hopefully will solve the
access denied issue.