The first method is using Finder and the TextEdit app, and the second is using the Terminal app. To solve this problem all we need to do is change the phpMyAdmin configuration file to use the actual password of the MySQL root user. If you changed your root password you have to edit this file and change the password in it. Thus, after changing the password of the MySQL root user, I forgot to set up the phpMyAdmin configuration file. There is a shell script for that: /Applications/MAMP/bin/stopMysql.sh. Recently I bought a new computer and I decided not to transfer the settings from the old computer, but to set up a new computer from scratch.
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. PhpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. Mysqli_real_connect(): (HY000/1045): Access denied for user (using password: YES) To find out the exact cause of the problem, you need to look in the phpMyAdmin error message.
The reasons for this problem with access to the phpMyAdmin web page can be different in different cases.
#Mamp for windows how to access mysql server pro
If you use the non-standard version of the app, but the PRO one, then in the following steps, replace “MAMP” with “MAMP PRO”, respectively.
I’m using version 5.1 of the MAMP app, but in your case there can be any other version of the MAMP app. When I try to access the phpMyAdmin web page located at localhost/phpMyAdmin/index.php, the following error message appears: Remote access is necessary to remotely access the database from an application running on a different machine or host. It can only be accessed by applications running on the same host. On my macOS devices I use MAMP app by appsolute GmbH for local web development. How to Allow Remote Access to a MySQL Server The MySQL server communicates only from the localhost by default.
0 kommentar(er)
