mysql客户端连接时,报错:is not allowed to connect to this MySQL server
来源:互联网 发布:js代码换行符 编辑:程序博客网 时间:2024/05/18 00:08
解决方法如下:
首先使用update把mysql.user中的root的host从localhost修改成%:
mysql> UPDATE mysql.user SET Host='%' WHERE Host='localhost' ;
mysql>GRANT ALL PRIVILEGES ON *.* TO root@"%";
mysql> FLUSH PRIVILEGES ;
2.mysql密码丢失后,在mysql命令行下执行如下命令,即可将root用户密码清空:
mysqld_safe --skip-grant-tables&
mysql修改密码
mysql修改,可在mysql命令行执行如下:
mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> QUIT
- mysql客户端连接时,报错:is not allowed to connect to this MySQL server
- mysql远程连接报错: Host * is not allowed to connect to this MySQL server,解决方法
- MySQL远程连接报错:Host is not allowed to connect to this MySQL server
- MYSQL-远程连接报:Host 'xxxxx' is not allowed to connect to this MySQL server
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- mysql 安装后配置失败
- How can you tell if you have an antique Tiffany lamp?
- 理解和认识udev
- Ubuntu 8.10里指点杆中键模拟鼠标滚轮的配置方法
- ubuntu8.10安装成功
- mysql客户端连接时,报错:is not allowed to connect to this MySQL server
- 虚拟应用入门
- IEs4linux+微软雅黑效果图(07.05.07更新,解决中文输入+乱码
- 解析算术表达式字符串
- K线图的看法实图详解
- 用checkinstall制作rpm包
- Windows系统中将“文件夹选项”对话框变成非模态的方法
- 关于博客最近访问速度慢的说明公告!
- .net中的4种事务总结