MySQL Invalid setting, Cannot Connect to phpmyadmin

[mikhailmcinally]

Hello,

I've recently installed xampp so that I can start using php in one of my applications.

When I started up xampp I got an error message ('Port 3306 in use by "Unable to open process"!') which I solved by simply
changing the port number in the my.ini file to 3307.

Than when I tried to access localhost/phpmyadmin I got a mySQL authentication error (you can view it in the attached link).

I suspect that there are some conflicts between the mySQL software I already installed, possibly the wamp software which I installed(recently uninstalled to see if it would help) to use the developer version of wordpress , and xampp. However, I don't know enough to determine what the source of the problem actually is.

I hope this information helps you assist me,

https://drive.google.com/open?id=1x7l7DA7SkS4eeG24OOHSKftWEC-3A7Rf (phpmyadmin error)
https://drive.google.com/open?id=1K6t95dE1mu3be0PAXbr3luWknYxcESpD (xampp control panel log)


Thank you very much

[Altrea]

Hi,

It is always the better way to get information about the other software already blocking port 3306.
The xampp control panel can gather and display some more information about this if started with elevated administrator rights (rightclick -> run as administrator).
The control panel log window then contains information about process ID (PID) and or Path of the program.

If you need to change the MariaDB port you need to tell the control panel and phpmyadmin, and all of your web applications the new port too in their own configuration files.

best wishes,
Altrea