Login with your username and password you edited or created earlier. Then type this command: SET PASSWORD FOR 'root''localhost' PASSWORD ('yourrootpassword') Also change to this line in : cfg 'Servers' i 'authtype' 'cookie' To make phpMyAdmin prompts for your MySQL username and password. We should now get a login page to enter userame and password to enter phpmyadmin successfully on XAMPP.Īlternatively, if you like the more simplified login box like http, you can use this: 161 Open phpMyAdmin and select the SQL tab.
Xampp phpmyadmin root password code#
At line # 90 to 95, is the code that looks like this:Īlias / phpmyadmin "C:/Servers/XAMPP/phpMyAdmin/" AllowOverride AuthConfig Require local ErrorDocument 403 / error / XAMPP_FORBIDDEN.Find the file "nf" edit with Notepad ++.
Notepad++ should prompt you if you want to run it in Admin mode if it cannot save changes. Most people store their XAMPP server in the C:\ and for changes of those files usually requires administrator. Make sure to run notepad++ or the editor of your choice in Administrator mode. 1 C:xamppmysqlbinmysql.exe -userroot In the above command, we issued the mysql.exe application with only one parameter, the -userroot, which instructs the client to ignore the default login username and use root instead. You just changed the root password in the users interface and now you cannot login.
0 kommentar(er)
