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
First of all stop MySQL.
Connect to MySQL
Next instruct MySQL to ignore the GRANT Tables. Then start MySQL.
mysql --user=root mysql
Next reset your password.
update user set Password=PASSWORD('new-password') where user='root';
Finally restart MySQL.
- 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