MySQL5.x开启远程登录 GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION; 1.MySQL8.x开启远程登录 # 创建一个用户 create user '用户名'@'%' identified by '密码'; # 赋予权限 grant all privileges on *.* to '用户名'@'%' with grant option; flush privileges;