[solved] http://localhost/phpmyadmin/ Access Denied

[davidjws]

Hi, please help, I've been searching in vain for a solution to this.

I've installed Xampp and it was working fine, I am using it to develop some Joomla sites on my localhost.

The problem is due to me inadvertantly (I think) nulling out some password fields in the database, I'd forgotton one of the Joomla admin passwords and may have wiped out something I shouldn't have.

I now cannot login to PHPMyAdmin as it says the credentials are wrong: "Wrong username/password. Access denied."

I've amended the config file in phpmyadmin thus:

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

But I still cannot get access even when I use user "root" and password as null.

I've spent about two hours trying to solve this, what am I doing wrong?

[davidjws]

Fixed it by using the following (from the Stack Overflow Site)

Go to your xampp\mysql\bin\ folder
Edit my.ini and insert skip-grant-tables below [mysqld]
Restart MySQL
Set new password for your root user by running UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root' in phpMyAdmin in the mysql database (or just leave it like this if MySQL cannot be accessed from remote hosts)