phpMyAdmin Error; "Access denied!"

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

phpMyAdmin Error; "Access denied!"

Postby EdwardMcm » 09. December 2015 12:50

Recently I came across an issue with MySQL, it wouldn't allow me to run on port '3306' the default port for MySQL. So I simply just changed the MySQL port, easy enough. Editing MySQL's port via; "Control Panel > Config > Service and Port Settings > MySQL > Main Port" and changing '3306' to '8080' then continuing by editing MySQL's config document 'my.ini'. I do not know if this was the correct method for changing the port however MySQL has run fine ever since (hope that helps anyone who's facing problem running MySQL on their current port).

I'm now currently facing another issue since I overcame the port error. PHPMyAdmin's repeatedly denying me access. Coming up with; "Cannot connect: invalid settings". I've checked through the settings and have found no issue? Anyone know how this can be solved?

Full error code:

Welcome to phpMyAdmin

Error

MySQL said:

Cannot connect: invalid settings.

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.

Retry to connect


Control panel seems to be running perfectly fine, both Apache and MySQL are starting on their set ports without any error codes appearing on the panel. I only came across this issue when trying to access /phpmyadmin.
EdwardMcm
 
Posts: 1
Joined: 09. December 2015 01:41
Operating System: Windows

Re: phpMyAdmin Error; "Access denied!"

Postby Altrea » 09. December 2015 18:14

You need to edit the phpMyAdmin config.inc.php to tell phpmyadmin the new MySQL port.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: phpMyAdmin Error; "Access denied!"

Postby geowebber » 11. December 2015 04:06

I have encountered the same problem with Xampp v. 5.6.15-1. I have changed the port from port 80 to 85 so that Apache will run. It did! Of course, MySQL is also running. So I presumed that all other things will run smoothly, but it didn't. When I tried to go to the Localhost, the homepage of the Php did not appear. It was pitch blank! What happened? What's the problem?

Please help.
geowebber
 
Posts: 1
Joined: 11. December 2015 03:28
Operating System: Windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 167 guests