MySQL or mariadb forgot root password

Windows
===========
===========
net stop MySQL #先停止mysql
or stop in service management

Open the Command Prompt window in the Win7 flagship PC directly, then open the Command Line window (run as Administrator) and enter the following command:
c:\> mysqld--defaults-file= "C:\Program Files (x86) \mysql-5.6.24\mysql\my-default.ini"--console-- Skip-grant-tables

Also open a command line window and enter the command:
Mysql-u root-p #回车即可进入mysql命令行界面
mysql> show databases;
mysql> use MySQL;
mysql> Update user Set Password=password (' 123456 ') where user= ' root ';
mysql> flush Privileges;

Linux
==========
==========
Service mysqld Stop # stops MySQL
or Systemctl stop mysqld

Mysqld_safe--skip-grant-tables--skip-networking & #跳过权限检查 Restart

Mysql-uroot-p #回车即可进入mysql命令行界面
Mysql> Show Database;
mysql> use MySQL;
mysql> Update user Set Password=password (' 123456 ') where user= ' root ';
mysql> flush Privileges;

MySQL or mariadb forgot root password