I’m sure that we have all done it. Yep, that’s right you’ve forgotten the MySQL root password. Fear not my fellow conrade, with a few simple simple commands you will be back in control.
Table of Contents
Stop MySQL
First of all stop MySQL.
/etc/init.d/mysqld stop
Connect to MySQL
Next instruct MySQL to ignore the GRANT Tables. Then start MySQL.
mysqld_safe --skip-grant-tables
mysql --user=root mysql
Reset Password
Next reset your password.
update user set Password=PASSWORD('new-password') where user='root';
flush privileges;
exit;Start MySQL
Finally restart MySQL.
/etc/init.d/mysqld start
Rick Donato is a Network Automation Architect/Evangelist and the founder of Packet Coders.
Latest posts by Rick Donato (see all)
- How to Configure a BIND Server on Ubuntu - March 15, 2018
- What is a BGP Confederation? - March 6, 2018
- Cisco – What is BGP ORF (Outbound Route Filtering)? - March 5, 2018
Want to become a database expert?
Here is our hand-picked selection of the best courses you can find online:
Ultimate MySQL Bootcamp
Complete SQL Bootcamp
MongoDB Complete Developer course
and our recommended certification practice exams:
AlphaPrep Practice Tests - Free Trial