Stats

269 Contributors: 2 Thursday, June 8, 2017
Licensed under: CC-BY-SA
Not affiliated with Stack Overflow
Rip Tutorial: riptutorial@gmail.com
Roadmap: roadmap

Recover and reset the default root password for MySQL 5.7+

Introduction

After MySQL 5.7, when we install MySQL sometimes we don't need to create a root account or give a root password. By default when we start the server, the default password is stored in the mysqld.log file. We need to login in to the system using that password and we need to change it.

Remarks

Recovering and resetting the default root password using this method is applicable only for MySQL 5.7+

Related Examples