Friday, February 23, 2018
Set password in Xampp mySql
Set password in Xampp mySql
How I can set a "root" password in MySQL? (method 1)
The easiest way is to use the security console, which you can access at 
http://localhost/security/.This "console" creates a password for the MySQL user "root" and is adjusting the phpMyAdmin configuration.
This "console" creates a password for the MySQL user "root" and is adjusting the phpMyAdmin configuration.
http://localhost/security/.This "console" creates a password for the MySQL user "root" and is adjusting the phpMyAdmin configuration.
How I can set a "root" password in MySQL? (method 2)
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
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"xamppphpMyAdminconfig.inc.php" change the lines:
to:
$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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.