changing mysql password

[darkfun3 5]

Is there a way to change the navicat password that i connect without changing the password my serverfiles connect with the db?

[.©ore™ 7]

How i can read it out of ur text u already have a root user with an existing password.

Just login into MySQL via Navicat, login into ur data's and click on "User".

 

After that just make a double click on the right one that u would change the password and done «3

[Galet 589]

You can use mysql -u root -p then connect and then :

 

USE mysql

UPDATE user

SET password=password("password")

WHERE user="root";

 

apply privileges :

 

flush privileges;

 

then quit

 

exit

 

then reboot

 

reboot

 

[.InyaProduction 1722]

You can use mysql -u root -p then connect and then :

 

USE mysql

UPDATE user

SET password=password("password")

WHERE user="root";

 

apply privileges :

 

flush privileges;

 

then quit

 

exit

 

then reboot

 

reboot

Why the fuck a reboot? ^^

[Galet 589]

I don't know, but you can do it without reboot xD

[darkfun3 5]

well this changes the password only when someone connects with navicat right i do not need to change anything in the config files?