6/30/2023 0 Comments Login to phpmyadmin xamppWhen you stop MySQL this way, the XAMPP control panel will reflect that it is stopped. To stop MySQL, you’ll need to open a command window (Start->Run “cmd”), and execute c:\xampp\mysql_stop.bat. You can still use it to start MySQL, but stopping it via the control panel will fail. Consequence to using XAMPP control panel if pma password is changedĪfter you change your pma password, it seems that you are no longer able to use the XAMPP control panel to stop MySQL. If you get an error when you try to sign on, which says this: “#1045 – Access denied for user (using password: NO)”, it means that you didn’t put the correct password into the file. Exit phpmyadmin (click this button:, which is at the top of the left sidebar), and try to sign in again first as “root” and then as “pma”. It is a good idea to check if you have done this properly. Now you are finished setting the password for “pma”. You need to add your pma password to this file (shown in red below) mysql\\bin\\mysqladmin -user=pma -password= password shutdown By default, this file has this on the 3rd line: mysql\\bin\\mysqladmin -user=pma -password= shutdown This is in the file c:\xampp\mysql_stop.bat. There is one other place where you need to enter in your pma password. Find this line: $cfg = '' // access to the "mysql/user"Īnd place the password between the two ‘ on the right side of the “=”: $cfg = ' password' // access to the "mysql/user" Open the file c:\xampp\phpmyadmin\ in your favorite text editor. Now we need to let the phpMyAdmin config file know what the password is so that phpMyAdmin will continue to work. Type in the old and new passwords and click on “Go” just underneath where you entered these passwords. I suggest using a password that is different than the phpMyAdmin password. Scroll down a little on the next page to see where you can change the password.On the right side of the row for “pma” is this symbol:, click on it to edit the properties for “pma”. The next page will show 2 users, “pma” and “root”.In the phpMyAdmin page, click on “Privileges”.If you are presented with a login screen, enter username “root” and the password you assigned to it.On the same machine that Apache is running on, navigate to.Make sure Apache and MySQL are running. First, you change the password using phpMyAdmin, and then you need to edit the file to let phpMyAdmin know what the password is. There are 2 steps involved in changing the password for “pma”. This should be changed to increase your security. You should have already given a password to the “root” user, but the “pma” user still has a blank password. The “pma” user is used by the phpMyAdmin application. Change the password of the “pma” user in phpMyAdminīy default, the MySQL database provided by XAMPP contains 2 users, “root” and “pma”. There are more folders and users that should be protected. The XAMPP built-in security only gives password protection to phpMyAdmin root user and to the /xampp folder. See the overview page for all the security measures. This article is part of a series of articles about making XAMPP more secure.
0 Comments
Leave a Reply. |