MYSQL Error in XAMPP server

0
votes

I Installed XAMPP server(xampp-win32-1.8.3-4-VC11-installer.exe) in windwos 7 64 bit machine.

First changed the Apache port to Listen 81. So that's fine.

As I have seperately installed MYSQL in the same machine, changed the PORT to 3307 [port= 3307] in my.ini configuration file.

So now my XAMPP control panel looks like following screenshot

enter image description here

When I check the status it says MySql database status as "Deactivated" even when MySql have started from control panel.

enter image description here

Also not allowing me to access to phpmyadmin and giving me the following Error message...

enter image description here

Does anybody know where I am going wrong.... Thanks

Edits

The values modified (in "my.ini" configuration file) when changing mysql port number is highlighted in the following screenshot. (Values changed to 3307 from default 3306)

enter image description here

1
phpmysqlxampp
Did you read "Some changes to the configuration may sometimes cause false negatives." below the status table? – VMai
In other words: Access denied for user 'root'@'localhost' (using password: YES). Wrong password? – Álvaro González
@Álvaro G. Vicario, That was just a test done by changing password to check if it works according to a solution explained in a tutorial. I removed not to have password and still the same.... I just updated it with that screenshot now. Thanks – JibW
Can't you just use the clipboard to copy the error message? It's hard to spot anything in those rescaled pictures. Whatever: you have a pretty good hint that MySQL is running: it returns error messages! – Álvaro González
I am confused as haven't set any password and all others are default settings except the PORT numbers I changed as explaibned in the question. This is what in the message. ---------> "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." ----------------- – JibW

1 Answers

1
votes

Try to change your MySQL password. The easiest way is to use the security console, which you can access at http://localhost/security/ This console creates a password for the MySQL user root and adjusts the phpMyAdmin configuration.

Another approach is to configure it with the "XAMPP Shell" (command prompt). Open the shell and execute this command: mysqladmin.exe -u root password secret

Or you could try to think on moving to Linux or Mac ;)