Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== 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 docs/mysql/change_password.txt Last modified: 2008/08/03 00:25by 127.0.0.1