郑志雄

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