Solution to forget password when installing MySQL on Linux/Mac

Preface

This article mainly introduces the relevant solutions for forgetting the password when installing MySQL on Linux/Mac. It is shared for your reference. Let’s take a look at the detailed introduction.

Use equipment

Computer: Linux or like-Linux OS

mysql version: 5.7+

Problem Description

After the installation is complete, you cannot connect to the database through the command mysql -u root

Solution

Generally, the MySQL server installed through DMG is installed in /usr/local/mysql-version-name-.../

By going into that directory and then cd ./bin

# If mysql is running, shut down the mysql service $ sudo lsof -i:3306
$ sudo kill -9 mysql-pid
# Enable mysql safe mode $ sudo ./mysqld_safe --skip-grant-tables

# Enter mysql shell
$ sudo ./mysql -u root

# Modify the root user password in the mysql.user table $ update mysql.user set authentication_string=PASSWORD('you password') where User='root';

# The modification is complete here.

Afterword

After the modification, if you use navicat to connect to the database, you will be prompted to change the password. Just re-enter the password. Because the password modified through safe mode is still marked as expired, so modify it again.

Summarize

The above is the full content of this article. There are still many shortcomings in this article. I hope that the content of this article will have certain reference learning value for everyone’s study or work. If you have any questions, you can leave a message to communicate. Thank you for your support for 123WORDPRESS.COM.