window 修改mysql用户名密码

1.打开cmd进入MySQL的bin目录 运行mysql -u root -p

2. 连接权限数据库输入：use mysql;

3.输入：update user set password=password(“123”) where user=“root”;

4.刷新权限：flush privileges;

进入mysql后修改密码失败情况：

先输入：flush privileges;
再输入：ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysql';

进开放远程连接：

root:表示你要开放的远程连接的用户名
password：表示要开放的远程连接用户的用户密码

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'password' WITH GRANT OPTION;

创建本地用户：

mysql> create user 'admin'@'localhost' identified by '123456';
创建外网可访问用户改localhost为%：

mysql> create user 'admin'@'%' identified by '123456';