unable to login to mysql after install

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

unable to login to mysql after install

Postby mnewing » 18. November 2011 23:06

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.
Posts: 1
Joined: 18. November 2011 22:56
Operating System: windows XP

Re: unable to login to mysql after install

Postby Sharley » 18. November 2011 23:18

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. :)
User avatar
AF Moderator
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 85 guests