Apache Friends Support Forum

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
http://localhost:82/phpmyadmin/
#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

Hello,

Running the 'resetroot.bat' file in the /xampp/mysql folder should wipe the password that is set for root.