Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community!
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.Start your free trial
random Joshua136 Points
I cannot get into phpMyAdmin
It says: 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 have checked the host, username and password, they are correct.
Besides, there is no greenlight in front of "MySQL Server" in the panel of MAMP.
Yes all makes sense when you mentioned you are using a VPN, and seeing you don’t permissions.
It totally depends what your actually doing with MAMP, but your vpn will send all traffic through the proxy so when you go in mamp the users don’t match up.
There is a potential work around, in my current job we set our proxy’s in our environmental variables to work through the proxy, you could possibly try the same although I’m not sure if it will have the same affect with a VPN.
Glad it’s sorted though!
Hard to tell without seeing the log file but there are a number of reasons for this.
Before you do any of this, back up your files:
Stop mamp running
If you have another mysql service running, stop them running or change mysql port.
if that doesnt work, the log file could be corrupted, go to your mamp directory "MAMP\db\mysql" and move the 2 log files from the folder (Dont delete them, just move them) and restart the server, if that doesn't work put the log files back
I would probably reinstall if none of the above work
There is an error log file which may hold some information which is loacted : "MAMP\logs\mysqp_error_logs"
Can you try:
open the task manager > Performance tab > Open Resource Montiror (at the bottom) > Network tab > Listening Ports
And make sure the port your running mamp on is not being used, I believe default is 3306
If there is nothing running at 3306, start MAMP again and let me know what you see in the listening ports, you should have 2 mysql exe applications
in your task manager can you quit httpd before restarting mamp too.
The issue is with your mysqld.exe file, can you go to "D:\MAMP\bin\mysql\bin\" and check that you have a "mysqld.exe" file there.
If you do have that file:
Check that you have the correct permissions, you're getting
Errcode: 13 - Permission denied, this is probably due to having permissions set up by a different user, MySQL cannot read some of the logs or it is trying to find a file that doesn't exist.
for the user, I would just recommend a complete remove and re-download
for the MySQL can't read logs and try to find a file that doesn't exist, check that you dont have any proxy settings or antivirus blocking it from executing.
If you don't have that file:
your mamp is corrupted and you will have to completely uninstall and remove and re-download the latest.
If none of the above works, I'm afraid I don't know what it could be.