如何关掉mysql密码限制

用root账号登陆&＃xff1a;

mysql -h localhost -u root -p


卸载插件

uninstall plugin validate_password;


其他常用命令。

-- 查看系统用户
select Host,User,Password from mysql.user;-- 创建一个远程用户
create user test identified by &＃39;123456&＃39;; -- 分配权限
grant all privileges on *.* to &＃39;test&＃39;&＃64;&＃39;%&＃39;identified by &＃39;123456&＃39; with grant option; -- 刷新mysql用户权限
flush privileges ; -- 修改指定用户密码
update mysql.user set password&＃61;password(&＃39;新密码&＃39;) where User&＃61;"test" and Host&＃61;"localhost"; -- 删除用户
delete from user where User&＃61;&＃39;test&＃39; and Host&＃61;&＃39;localhost&＃39;;