Solution to forgetting the administrator password of mysql database

Solution to forgetting the administrator password of mysql database

1. Enter the command mysqld --skip-grant-tables (prerequisite: close the mysql.exe process net stop mysql)

2. Enter the command mysql

Complete the database without password entry~

3. Change username and password

mysql -u root -p 1234

The red area is where you can change your username and password.

You may also be interested in:
  • MySQL - 4 ways to change the root password (taking Windows as an example)
  • Solution to forgetting the root password of mysql under windows
  • How to view or modify the root password of MySQL if it is forgotten (with pictures and text)
  • What should I do if I forget my MySQL password? How to reset MySQL root password
  • How to forget the root password in MySQL 5.7 and change the root password in MySQL 5.7
  • MySql add user, authorization, change password and other statements
  • How to recover MySQL password if you forget it
  • How to modify the default empty password (root password) of MySQL in xampp
  • Four small methods to modify the default password of MySQL
  • Summary of MYSQL root password modification commands

<<:  CentOS7 uses rpm to install MySQL 5.7 tutorial diagram

>>:  Vue uses dynamic components to achieve TAB switching effect

Recommend

Introduction to the difference between OBJECT and EMBED tags used to display flash content

1. Introduction: If we want to display flash conte...

Drop-down menu and sliding menu design examples

I found a lot of websites that use drop-down or sl...

Example code for using @media in CSS3 to achieve web page adaptation

Nowadays, the screen resolution of computer monit...

Practical basic Linux sed command example code

The Linux stream editor is a useful way to run sc...

In-depth explanation of environment variables and configuration files in CentOS

Preface The CentOS environment variable configura...

MySQL 5.6.22 installation and configuration method graphic tutorial

This tutorial shares the specific code of MySQL5....

How to reset the root password in CentOS7

There are various environmental and configuration...

Share 13 basic syntax of Typescript

Table of contents 1. What is Ts 2. Basic Grammar ...

Summary of 4 methods of div+css layout to achieve 2-end alignment of css

The div+css layout to achieve 2-end alignment is ...

Mysql vertical table conversion to horizontal table method and optimization tutorial

1. Vertical table and horizontal table Vertical t...

Element table header row height problem solution

Table of contents Preface 1. Cause of the problem...

Detailed analysis of each stage of nginx's http request processing

When writing the HTTP module of nginx, it is nece...

Detailed explanation of docker version es, milvus, minio startup commands

1. es startup command: docker run -itd -e TAKE_FI...

Example code for implementing background blur effect with CSS

Is it the effect below? If so, please continue re...

CSS naming conventions (rules) worth collecting Commonly used CSS naming rules

CSS naming conventions (rules) Commonly used CSS ...