郑志雄

MySQL远程连接访问直接授权 　　从任何主机上使用root用户，密码：youpassword（你的root密码）连接到mysql服务器： GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘youpassword’ WITH GRANT OPTION; 设置权限之后记得一定要刷新 flush privileges;

用户管理 mysql>use mysql; 查看 mysql> select host,user,password from user ; 创建 mysql> create user zx_root IDENTIFIED by ‘xxxxx’; //identified by 会将纯文本密码加密作为散列值存储 修改 mysql>rename user feng