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

Vue implements card flip carousel display

Vue card flip carousel display, while switching d...

WeChat applet scroll-view realizes left and right linkage

This article shares the specific code for WeChat ...

Simple implementation of mini-vue rendering

Table of contents Preface Target first step: Step...

What does mysql database do

MySQL is a relational database management system ...

A quick solution to the error #1929 Incorrect datetime value: '''' for column ''createtime'' when using MySQL 5.x or above

After I installed MySQL, when I tried to save and...

Stealing data using CSS in Firefox

0x00 Introduction A few months ago, I found a vul...

How to change the root user's password in MySQL

Method 1: Use the SET PASSWORD command mysql> ...

React Routing Link Configuration Details

1. Link's to attribute (1) Place the routing ...

Linux CentOS6.9 installation graphic tutorial under VMware

As a technical novice, I am recording the process...

CSS scroll bar style modification code

CSS scroll bar style modification code .scroll::-...

How to optimize logic judgment code in JavaScript

Preface The logical judgment statements we use in...

Using VMware IOInsight to perform refined virtual machine storage performance monitoring

illustrate: VMware IOInsight is a tool that helps...

Detailed explanation of the data responsiveness principle of Vue

This article is mainly for those who do not under...

How to view and set the mysql time zone

1. Check the database time zone show variables li...

Summary of commonly used tags in HTML (must read)

Content Detail Tags: <h1>~<h6>Title T...