Page 1 of 1

unable to login to mysql after install

PostPosted: 18. November 2011 23:06
by mnewing
I have installed XAMPP version 1.7.5 on window XP onto a USB stick but am unable to connect to MYSQL

steps taken
installed XAMPP
start the controller
started apache
started mysql
went to a browser and entered localhost
picked my language
selected phpmyadmin off the menu on the left
observed the following error messages

Welcome to phpMyAdmin

MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

I then tried a connection from the command line as follows:
E:\xamppwin\mysql\bin\mysql.exe -u root

and i get the follow message
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N

Any ideas please. I have not altered any configuration files or connected to anything so i am mystified. I have use XAMPP for many years and installed many different versions and never had such a fundamental problem before.

Re: unable to login to mysql after install

PostPosted: 18. November 2011 23:18
by Sharley
To speed things up see if there is a solution in these Forum Search Results as your issue has been resolved many times before.

Good Luck. :)