Page 1 of 1

mysql question

Posted: Wed Jun 08, 2005 6:23 pm
by method_man
is it possible to change your mysql password thing from the MySQL command line client thing?
if so, how?

thanks,

matt

Posted: Wed Jun 08, 2005 6:39 pm
by malcolmboston
login to mysql the usual way through command line

Code: Select all

mysql -u root -h localhost -p yourpassword;
now to change password

Code: Select all

UPDATE user SET password=password('newpass') WHERE user='yourusername';
now to apply

Code: Select all

flush privileges;
hope that helps

Posted: Wed Jun 08, 2005 8:15 pm
by John Cartwright
Moved to Databases :roll:

Posted: Wed Jun 08, 2005 9:20 pm
by malcolmboston
lol jcart, been wondering this for a few days, what the hell does you signature mean?

<-- is thinking its some plan to take over the world

Posted: Wed Jun 08, 2005 9:21 pm
by method_man
search binary translator on google

Posted: Wed Jun 08, 2005 9:39 pm
by John Cartwright
method_man wrote:search binary translator on google
now the whole world knows :(

Posted: Wed Jun 08, 2005 9:40 pm
by malcolmboston
pmsl
binary wrote: i eat burritos like heat melts butter

Posted: Wed Jun 08, 2005 9:40 pm
by method_man
lol thats funny thing to say