ERROR 1130 (HY000): Host 'test177' is not allowed to connect to this MySQL server
2024-09-04 05:27:15
异常
在测试环境新搭建的MySQL服务端,启动后登陆MySQL如下异常:
[root@test177 ~]# mysql -u root -po2jSLWw0ni -h test177
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1130 (HY000): Host 'test177' is not allowed to connect to this MySQL server
由于不能改变hostname
,所以只能通过跳过数据库权限验证,来修改权限。
首先停止MySQL服务端
systemctl stop mysqld
在/etc/my.cnf
中的[mysqld]
选项中添加跳过验证策略skip-grant-tables
,my.cnf文件内容如下:
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-grant-tables
然后重新启动MySQL服务:
systemctl start mysqld
登陆数据库,通过以下两种方法修改权限:
通过表修改
use mysql;
update user set host = '%' where user = 'root' and host='localhost';
select host, user from user;
通过授权
GRANT ALL PRIVILEGES ON *.* TO 'account_name'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
最新文章
- 五分钟搭建起一个包含CRUD功能的JqGrid表格
- gtest 1.7编译错误:std:tr1:tuple模板参数过多的解决方案
- MYSQL开发性能研究——INSERT,REPLACE,INSERT-UPDATE性能比较
- Hadoop系列之(一):Hadoop单机部署
- 我的权限系统设计实现MVC4 + WebAPI + EasyUI + Knockout(三)图形化机构树
- .NET操作JSON
- HDOJ 1098 Ignatius's puzzle
- TensorFlow-谷歌深度学习库 命令行参数
- jquery中的 deferred之 when (三)
- pytorch例子学习-DATA LOADING AND PROCESSING TUTORIAL
- 【洛谷】【单调栈】P1901 发射站
- js元素闪动效果
- 今年新鲜出炉的30个流行Android库,你一定需要
- isa class superclass metaclass
- 关于matlab向文件写入数据的方法——留着备用
- poj3176
- 7 . 动态sql-choose
- Write with Vim (1)
- java读取文件封装的一个类(有部分代码借鉴别人的)
- android adb源码分析(5)【转】