CODEWITHSUNDEEP
phpmysqlxampp
JibW
JibW

Reputation: 4562

MYSQL Error in XAMPP server

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

Upvotes: 0

Views: 3112

Answers (1)

JokiRuiz
JokiRuiz

Reputation: 311

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 ;)

Upvotes: 1

Related Questions