Mac latest version of MySQL 8.0.22 password recovery Problem description: Yesterday, I suddenly wanted to experience the password change process of the latest version of MySQL on Mac. I changed the plugin by replacing caching_sha2_password with mysql_native_password, and then used UPDATE SET to modify authentication_string. I didn't remember to add the password('new password') function, which led to ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Cause Analysis: There are several pitfalls in the whole thing: 1. The password() function has been deprecated in MySQL 8.0 Solution: Step 1: Shut down the MySQL server Apple icon in the upper left corner - System Preferences - MySQL - Stop MySQL Server Step 2: Use system administrator privileges to skip MySQL security authentication and force login 1. Command + Space So far, I have successfully logged into MySQL in safe mode. 9. FLUSH PRIVILEGES; (This statement extracts the user information of the current user table and the privilege table permissions into memory to ensure that the permissions can be successfully obtained to modify the user table) USE mysql; UPDATE user SET authentication_string = '' WHERE User = 'root'; ALTER user 'root'@'localhost' IDENTIFIED BY '123456'; The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
>>: Several ways to submit HTML forms_PowerNode Java Academy
1. Introduction to Nginx Nginx is a web server th...
View system help help contents mysql> help con...
Table of contents 1. Animated Christmas Tree Made...
<br />From the launch of NetEase's new h...
CocosCreator version: 2.3.4 Cocos does not have a...
Here is a case study on how to close ads using Ja...
I recently encountered a problem when doing IM, a...
1. Warm and gentle Related address: http://www.web...
Preface In daily development, we often need to pe...
[LeetCode] 185. Department Top Three Salaries The...
The relationship between Javascript and DOM is ve...
Superset is a lightweight self-service BI framewo...
1. Make a repo file Refer to the official install...
Previously, react.forwardRef could not be applied...
Preface In actual business, paging is a common bu...