docs:mysql:change_password

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

docs:mysql:change_password [2007/03/19 17:09] – created billhdocs:mysql:change_password [2008/08/03 00:25] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +====== Change MySQL Password ======
 +<code>
 +mysql -u root -p
 +<enter your password>
  
 +SET PASSWORD [FOR user] = PASSWORD('some password')
 +
 +</code>
 +  * no FOR clause: sets the password for the current user
 +  * only clients that have the UPDATE privilege for the database can do this
 +  * The user value should be given in user_name@host_name  format, where user_name and host_name are exactly as they are listed in the User and Host columns of the mysql.user table entry.  For example, if you had an entry with User and Host column values of 'bob' and '%.loc.gov', you would write the statement like this:<code>
 +SET PASSWORD FOR 'bob'@'%.loc.gov' = PASSWORD('newpass');
 +</code>
 +  * also look at using phpmyadmin: http://www.phpmyadmin.net