Help MySql

[FactorX]

Hello everyone. I install Xampp cuz it's more easy to use...but..i no have password for MySql. How i can do that?

[SamDev-Coder]

if you mean that it has no password and you want to set password then go to mysql bin folder, open command line there and then run thing command :

Quote

mysql -h localhost -u root -p

Hit enter, it will ask you for a password just click enter, then run this command :

Quote

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('you password here');

if not work try : 

Quote

ALTER USER 'root'@'localhost' IDENTIFIED BY 'your password here';

if both not work try :

Quote

UPDATE mysql.user SET authentication_string = PASSWORD('your pass word here') WHERE User = 'root' AND Host = 'localhost';

After that to take effect you have to flush privileges with this command

Quote

FLUSH PRIVILEGES;