Menu
Im getting this error message:
MySQL said:
Cannot connect: invalid settings. 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.
The user and pass are the default ones - both 'root'. I haven't set them anywhere. Ive tried various answers on here but nothing is working
448
In MAMP, you need to open phpMyAdmin to create a MySQL database. If you have installed MAMP with the default ports, open the Welcome page in your browser (http://localhost:8888/MAMP/), then click the phpMyAdmin link at the top of the screen.
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.
The issue is usually due to another MySQL service running on the same port. The easiest solution is to kill all MySQL processes and restart MAMP. On macOS, you can do this using the Activity Monitor, which you'll find in the Utilities folder on your computer.
I was having the same problem, tried all these suggestions but nothing worked. So I did the only thing I could think off, restarted the machine...started MAMP, mysql server was off, so I just hit start server and it worked.
113
answered Oct 18 '22 00:10
In Preferences pane of MAMP switch back from PHP 7 to 5.6.10 and it should work again.
43
/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin/config.inc.php
Try changing the $cfg['Servers'][$i]['host'] from "localhost" to "127.0.0.1"
43
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
