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. Thus, after changing the password of the MySQL root user, I forgot to set up the phpMyAdmin configuration file. 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. 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: MySQL installed with Zend Server CE Socket File /usr/local/zend/mysql/tmp/mysql.On my macOS devices I use MAMP app by appsolute GmbH for local web development. MySQL installed with XAMPP Socket File /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock Data Files /Applications/XAMPP/xamppfiles/var/mysql Configuration File /Applications/XAMPP/xamppfiles/etc/my.cnf MAMP PRO shares many paths with MAMP, with the following difference: Data Files /Library/Application Support/appsolute/MAMP PRO/db/mysql MySQL installed with MAMP Socket File /Applications/MAMP/tmp/mysql/mysql.sock Data Files /Applications/MAMP/db/mysql/ Base Directory /Applications/MAMP/Library/ Error Log /Applications/MAMP/logs/mysql_error_log MySQL 5 installed with MacPorts Socket File /opt/local/var/run/mysql5/mysqld.sock Data Files /opt/local/var/db/mysql5/ Error Log /opt/local/var/db/mysql5/HOSTNAME.err (insert your hostname) MySQL pre-installed on Mac OS X Server Socket File /var/mysql/mysql.sock pkg installer Socket File /tmp/mysql.sock Data Files /usr/local/mysql/data/ Error Log /usr/local/mysql/data/HOSTNAME.err (insert your hostname) Base Directory /usr/local/mysql/ (this is a symbolic link) If you can connect to your MySQL server, you can find many of these paths by selecting Show Server Variables. from the Database Menu in Sequel Pro. If your installation has no option file ( my.cnf), you can create it in the base directory of your installation (see 'Using Option Files' section of the MySQL manual for more information). Some of the files only exist while the MySQL server is running (eg. If you can't find the files in the locations given here, it could be because you changed the configuration - these are only the default locations. It is recommended to use Sequel Pro's Export and Import features (use a MySQL dump) to accomplish this. If you want to backup your data or copy data from one server to another, please don't copy the data files directly. This page documents the locations of commonly used files, for some often used MySQL installations. Your default path to PHP is likely to be /usr/. MySQL stores and accesses files in various places on your hard drive. MAMP comes packaged with its own versions of MySQL & PHP which we need to give WP CLI access to.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |