I setup a LAMP server for a developer a while back and he changed the passwords for root and the root mysql user to something besides my defaults. So when he asked me to give him the password for the database, I could not really help him out. Or could I?<\/p>\n
Stop the mysql services: Start mysql without the passwords: Connect to the safe mysql: Set a new root password: Stop the safe mysql database: Start mysql and test: *note – there is no space between -p and your password.<\/p>\n AND, in case you’re just wanting to change the password of a known user: I setup a LAMP server for a developer a while back and he changed the passwords for root and the root mysql user to something besides my defaults. So when he asked me to give him the password for the database, I could not really help him out. Or could I? Stop the mysql services: … Continue reading Reset MySQL Password<\/span>
\n\/etc\/init.d\/mysql stop<\/code><\/p>\n
\nmysqld_safe --skip-grant-tables &<\/code><\/p>\n
\nmysql -u root<\/code><\/p>\n
\nuse mysql;<\/code>
\nupdate user set password=PASSWORD(\"your_New_Password_here\") where User='root';<\/code>
\nflush privileges;<\/code>
\nquit<\/code><\/p>\n
\n\/etc\/init.d\/mysql stop<\/code><\/p>\n
\n\/etc\/init.d\/mysql start<\/code>
\nmysql -u root -pYOURNEWPASSWORDHERE<\/code><\/p>\n
\nmysqladmin -u root -pOLDPASSWORD password NEWPASSWORD<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"