WINDOWS主机mysql更改ROOT口令

改ROOT口令

stop mysql //停MYSQ服务

CD 到mysql bin目录下mysqldnt skipgranttables //启动MYSQL

DOS下mysql mysql //登录到mysql库

update user set password =PASSWORD(fuck) where user=root

FLUSH PRIVILEGES;

建库

create database xx;

FLUSH PRIVILEGES;

建用户

insert into mysqluser(HostUserPasswordssl_cipherx_issuerx_subject) values(localhostusernamePASSWORD(password));

grant all privileges on xx* to username@localhost identified by password

FLUSH PRIVILEGES;