How I can set a “root” password in MySQL?
With the”XAMPP Shell” (command prompt) you can also change the password. Open the shell and execute this command: mysqladmin.exe -u root password secret Of course, your password should not be “secret”, too. In the next step you must adjust the phpMyAdmin configuration for this new password. In the file “\xampp\phpMyAdmin\config.inc.php” change the lines: $cfg[‘Servers’][$i][‘user’] = ‘root’; $cfg[‘Servers’][$i][‘password’] = ”; to: $cfg[‘Servers’][$i][‘user’] = ‘root’; $cfg[‘Servers’][$i][‘password’] = ‘secret’; Instead in the XAMPP Shell, you can also change the password with phpMyAdmin, and then adjust the phpMyAdmin configuration.
Related Questions
- Id like to change the MySQL "scrutinizer" user password from the default to something more secure. Is there anything else I need to do other than set the password in MySQL?
- I added the new user and a password in MySQL but I can connect to the "freealeir" database. What is wrong?
- How to change mysql administrator password?
