mysql question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
method_man
Forum Contributor
Posts: 257
Joined: Sat Mar 19, 2005 1:38 am

mysql question

Post by method_man »

is it possible to change your mysql password thing from the MySQL command line client thing?
if so, how?

thanks,

matt
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post 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
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

Moved to Databases :roll:
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post 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
method_man
Forum Contributor
Posts: 257
Joined: Sat Mar 19, 2005 1:38 am

Post by method_man »

search binary translator on google
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

method_man wrote:search binary translator on google
now the whole world knows :(
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

pmsl
binary wrote: i eat burritos like heat melts butter
method_man
Forum Contributor
Posts: 257
Joined: Sat Mar 19, 2005 1:38 am

Post by method_man »

lol thats funny thing to say
Post Reply