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

Problems with the Windows version of XAMPP, questions, comments, and anything related.

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

Postby davidjws » 09. February 2012 11:24

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?
Last edited by davidjws on 09. February 2012 11:52, edited 1 time in total.
davidjws
 
Posts: 2
Joined: 09. February 2012 11:17
Operating System: Windows7

Re: http://localhost/phpmyadmin/ Access Denied

Postby davidjws » 09. February 2012 11:51

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)
davidjws
 
Posts: 2
Joined: 09. February 2012 11:17
Operating System: Windows7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 45 guests