I am currently looking for a software/web development job preferably as a Rails-based developer.
Please email me at firstname.lastname@example.org. Thanks in advance for any leads!
Reset Forgotten MySQL Root Password
Posted by Weston Ganger
I have forgotten my root password to MySQL before. This was a life saver.
It requires root access to the system obviously though.
# Start MySQL and skip the grant tables that store passwords mysqld_safe --skip-grant-tables # Connect to MySQL without a password mysql --user=root mysql # In the mysql prompt run the following commands: UPDATE USER SET Password=PASSWORD('new_password') WHERE user='root'; flush privileges; exit;
Then just kill your running mysqld and restart it normally.
Related External Links: