cygwin mysql forget root password

 

此时此刻0526,这个靠谱

from https://stackoverflow.com/questions/49926467/you-are-using-mariadb-as-an-anonymous-user?noredirect=1

> update mysql.user set password=password('newpass') where user='root';
> flush privileges;
> update mysql.user set plugin='mysql_native_password' where user='root';
> flush privileges;

 

 

-----------------------------------------------------

1，mysqld --skip-grant-tables

2，use mysql

3，update user set password=password("123") where user="root";

4，flush privileges;

-----------------

1， grant all  on *.* to 'root'@'localhost' identified by '123456';

--------

新安装mariadb设置密码

# mysqladmin -uroot -p password '123456'

create table huzhtbl (id int , name varchar(100), primary key (id));

#迁移表

insert into voh.huzhtbl (select * from huzh.huzhtbl);