

PS: I just post it here so I know where to look and find it next time.

#Xampp phpmyadmin root password how to
Restart XAMPP This should often work in Windows and Linux. By default, when you install XAMPP in your windows machine, the root password for the MySQL is set to empty. How to set phpmyadmin password on xampp phpmyadmin xampp - how-to-set-phpmyadmin-password-on-xampp.md. Change it to: cfg Servers i password yourpassword 4. sudo /Applications/XAMPP/xamppfiles/bin/mysqladmin -u root password root /Applications/XAMPP/xamppfiles/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root''localhost' (using password: NO)'.
#Xampp phpmyadmin root password pro
Sorry I was first time user of xampp on macbook pro and was not knowing its directory structure and other details so adding this answer for first time users.įrom XAMPP interface click to 'go to Terminal' and from there use below commands cd /opt/lampp/phpmyadmin Open file in the phpmyadmin directory 2.

If you are using macbookpro and getting this error on XAMPP then you also need to change the permission of file. 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: NO) #1045 - Access denied for user (using password: NO) I am unable to connect to my MySQL in xampp I have this error:
