#1045 - Access denied for user 'root'@'localhost'

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

#1045 - Access denied for user 'root'@'localhost'

Postby eurico » 12. June 2013 13:03

Hi I've installed and reinstall xampp few times now but I cannot get access to phpmyadmin I get the following error
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

The only thing I've changed was the appache port to use port 82 I can run php but not admin
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I've never set up a password I am not sure if the previous person that was using this computer as set up username and password but is there a way to reset, delete add new password so I can gain access to phpmyadmin.

I've checked config file and this what I've got

Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

I've tried some cmd command line but I can this

user_mysql and i get this
"Access denied for user 'ODBC'@'localhost' (using password: NO)".

I've tried cmd
mysql> user_mysql
"Access denied for user 'root'@'localhost' (using password: NO)".

help Please
Posts: 1
Joined: 12. June 2013 12:42
Operating System: windows

Re: #1045 - Access denied for user 'root'@'localhost'

Postby hackattack142 » 12. June 2013 22:50


Running the 'resetroot.bat' file in the /xampp/mysql folder should wipe the password that is set for root.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
Posts: 703
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 60 guests