Host '192.168.1.254' is not错误解决办法

最新推荐文章于 2023-10-11 12:26:22 发布
最新推荐文章于 2023-10-11 12:26:22 发布
阅读量3.1k 收藏
点赞数
CC 4.0 BY-SA版权
文章标签： mysql 数据库 phpmyadmin server 百度 测试
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/daiyuan5210/article/details/3461703
本文记录了一次解决MySQL服务器不允许外部IP连接的问题经历。通过更改连接代码中的IP地址为127.0.0.1，成功实现了从PHP代码中连接MySQL数据库。此问题常见于开发环境中，对于遇到类似情况的开发者具有一定的参考价值。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

哎！今天这个问题搞死我了。百度和优快云都发下。需要以后大家遇到这个问题可以很快解决!!!

Warning: mysql_connect() [function.mysql-connect]: Host '192.168.1.254' is not allowed to connect to this MySQL server in E:/www/xnwenn/wb/phpxd/min/dbclass.php on line 25

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in E:/www/xnwenn/wb/phpxd/min/dbclass.php online 31

说起来也很奇怪！我用PHPMYADMIN可以登陆，但是用代码确连接不上。

后来就一直在找技术文章，看看有人写这过这样的php文章么。找了半天没。

后来自己就慢慢测试！连接代码写了几种还是一样，。。

后来把IP改了下就好了

解决办法：

<?php
$conn=mysql_connect("58.49.199.186","hudfsfazi521","DAIdsfdsfsYUAN")or die ("连接失败 ".mysql_error());  //创建数据库连接
mysql_select_db("data123",$conn) or die ("无法选择 ".mysql_error()); //选择要操作的数据库
?>

上面是我的代码只要把IP改成127.0.0.1就可以了。

<?php
$conn=mysql_connect("127.0.0.1","hudfsfazi521","DAIdsfdsfsYUAN")or die ("连接失败 ".mysql_error());  //创建数据库连接
mysql_select_db("data123",$conn) or die ("无法选择 ".mysql_error()); //选择要操作的数据库
?>

原因是因为：MySQL数据库不允许其它电脑（非虚拟主机本身）用IP地址访问它

 

智软设计
关注
eclipse window下连接Hadoop2.0报错：local host is: "win/127.0.0.1"; destination host is: "10.2.3.1":50070;
Java海洋
04-19 9606
eclipse连接远程Hadoop错误信息： Failed on local exception: com.google.protobuf.InvalidProtocolBufferException: Protocol message end-group tag did not match expected tag.; Host Details : local host is:
RKE安装Kubernetes集群问题处理
03-29 2574
RKE安装Kubernetes集群问题处理 问题1： [[network] Host [192.168.31.14] is not able to connect to the following ports: [192.168.31.14:2379]. Please check network policies and firewall rules] 问题排查： 检查防火墙是否关闭 关闭 SELINUX 查看宿主机是否与容器相通，使用ping容器IP方法确定网络是否通 经过排查防火.
Host ‘ ‘ is not allowed to connect to this MySQL server
Heyuanfly的博客
09-29 317
使用mysql -hxx.xx.xx.xx -uroot -p远程访问服务器上的mysql时报错发现root用户只能在本地localhost登录，即只存在。
host ‘‘ is not allowed to connect to this mysql server连接mysql时报错。
qq_44913716的博客
06-21 1万+
1.当你打算用 mysql -h(主机的ip地址) -u(用户名) -p 打开你的数据库时报错host ‘’ is not allowed to connect to this mysql server。 原因：我们自己安装的mysql是不允许远程登录的。 2.解决方法： 第一步：mysql -u(用户名) -p 第二步：输入use mysql; 第三步：输入update user set host = ‘%’ where user = ‘root’; 第四步：输入FLUSH PRIVILEGES;（flu
连接MySQL8.0.30时报错：host “” is not allowed to connect to this mysql server
Wangsang_629的博客
10-11 1608
报错原因：1、防火墙问题；2、MySQL用户的权限设置不正确（最主要的）。
Host 'ip地址' is not allowed to connect to this MySQL server报错解决方法
仅此而已的日记本
01-11 9334
192.168.1.xxxis not allowed to connect to this mysql server 意思是这个host主机不能访问本机的mysql服务， 需要连接非本机的mysql的时候，默认host是localhost，我们需要将这个mysql连接权限设置成% 更改方法: 在mysql的数据库选择mysql这个数据库，里面有一个user表，进入表中有一个host字段...
解决报错:错误1130- Host xxx is not allowed to connect to this MariaDb server
热门推荐
qq_35396905的博客
10-08 5万+
在云服务器上面搭建了MariaDb（MariaDB是MySQL源代码的一个分支），但是远程链接不上。  首先，你要确保服务器安全组3306端口已经开放。  在确保端口开放的情况下，如果出现错误代码1130- Host xxx is not allowed to connect to this MariaDb server，说明是权限问题。如图：  有两种解决方法： 1.授权法 GRA...
ciscoasa(config-if)# ip address 192.168.10.1 255.255.255.0 Interface address is not on same subnet as DHCP pool
03-14
例如，假设接口 IP 是 `192.168.1.1/24`，则应将 DHCP 池设置为该子网内的有效地址范围（如 `192.168.1.100-192.168.1.200`）。 2. **启用辅助网络支持** 在某些场景下，可以通过创建额外的网络对象来实现跨子网...
The target '192.168.147.1:8080' was not scanned because it is a "restricted" IP address. Remove the IP address from the scan's target list.
07-12
用户遇到了一个错误提示："The target '192.168.147.1:8080' was not scanned because it is a restricted IP address." 用户想知道如何解决这个问题，或者如何将这个IP从扫描目标列表中移除。 首先，我们需要理解...
这个配置单有问题吗：# dhcpd.conf # # Sample configuration file for ISC dhcpd # # Attention: If /etc/ltsp/dhcpd.conf exists, that will be used as # configuration file instead of this file. # # option definitions common to all supported networks... # option domain-name "example.org"; # option domain-name-servers ns1.example.org, ns2.example.org; default-lease-time 60; max-lease-time 120; # The ddns-updates-style parameter controls whether or not the server will # attempt to do a DNS update when a lease is confirmed. We default to the # behavior of the version 2 packages ('none', since DHCP v2 didn't # have support for DDNS.) ddns-update-style none; # If this DHCP server is the official DHCP server for the local # network, the authoritative directive should be uncommented. authoritative; # Use this to send dhcp log messages to a different log file (you also # have to hack syslog.conf to complete the redirection). #log-facility local7; # No service will be given on this subnet, but declaring it helps the # DHCP server to understand the network topology. #subnet 10.152.187.0 netmask 255.255.255.0 { #} # This is a very basic subnet declaration. subnet 192.168.50.0 netmask 255.255.255.0 { range 192.168.50.40 192.168.50.50; option routers 192.168.50.10; host soho{ hardware ethernet 08:00:07:26:c0:a5; fixed-address 192.168.50.40; } } # This declaration allows BOOTP clients to get dynamic addresses, # which we don't really recommend. #subnet 10.254.239.32 netmask 255.255.255.224 { # range dynamic-bootp 10.254.239.40 10.254.239.60; # option broadcast-address 10.254.239.31; # option routers rtr-239-32-1.example.org; #} # A slightly different configuration for an internal subnet. #subnet 10.5.5.0 netmask 255.255.255.224 { # range 10.5.5.26 10.5.5.30; # option domain-name-servers ns1.internal.example.org; # option domain-name "internal.example.org"; # option subnet-mask 255.255.255.224; # option routers 10.5.5.1; # option broadcast-address 10.5.5.31; # default-lease-time 600; # max-lease-time 7200; #} # Hosts which require special configuration options can be listed in # host statements. If no address is specified, the address will be # allocated dynamically (if possible), but the host-specific information # will still come from the host declaration. #host passacaglia { # hardware ethernet 0:0:c0:5d:bd:95; # filename "vmunix.passacaglia"; # server-name "toccata.example.com"; #} # Fixed IP addresses can also be specified for hosts. These addresses # should not also be listed as being available for dynamic assignment. # Hosts for which fixed IP addresses have been specified can boot using # BOOTP or DHCP. Hosts for which no fixed address is specified can only # be booted with DHCP, unless there is an address range on the subnet # to which a BOOTP client is connected which has the dynamic-bootp flag # set. # You can declare a class of clients and then do address allocation # based on that. The example below shows a case where all clients # in a certain class get addresses on the 10.17.224/24 subnet, and all # other clients get addresses on the 10.0.29/24 subnet. #class "foo" { # match if substring (option vendor-class-identifier, 0, 4) = "SUNW"; #} #shared-network 224-29 { # subnet 10.17.224.0 netmask 255.255.255.0 { # option routers rtr-224.example.org; # } # subnet 10.0.29.0 netmask 255.255.255.0 { # option routers rtr-29.example.org; # } # pool { # allow members of "foo"; # range 10.17.224.10 10.17.224.250; # } # pool { # deny members of "foo"; # range 10.0.29.10 10.0.29.230; # } #}
最新发布
07-25
- **问题**：子网`192.168.50.0/24`的掩码为`255.255.255.0`，但网关配置为`192.168.50.10`。需确保： - 网关IP（`192.168.50.10`）在子网范围内。 - 所有客户端的子网掩码一致，否则可能导致通信异常。 --- ###...
vlan 接口类型 access trunk hybrid 综合实验
yigebaimifan的博客
01-15 545
实验要求 PC1和PC3所在接口为access。pvlan vlan 2 PC2/4/5/6处于同一网段。其中PC2可以访问PC4/5/6，但PC4可以访问PC5，不能访问PC6 PC5不能访问PC6 PC1/3与PC2/4/5/6不在一个网段 所有PC通过dhcp获取ip地址，且PC1/3可以正常访问PC2/4/5/6 交换机配置 SW1 vlan batch 2 to 5 interface Ethernet0/0/1 port link-type access port default vlan.
rancher rke安装k8s报错[network] Host [] is not able to connect to the following ports: [:10250] [:2379]
qq_35702095的博客
04-14 5047
之前的机器运行的低版本的k8s，将集群删掉，重新装1.17.4后，报错连不上本机10250，检查防火墙是关闭状态，重启docker也不行。 google后清理宿主机目录，docker容器，docker volume，再次安装还是报错。有人怀疑是防火墙问题，检查自己机器此时防火墙已关闭。 参考：https://github.com/rancher/rancher/i...
解决host is not allowed MySQL不允许从远程访问的方法
m0_56972159的博客
11-01 528
mysql不能远程连接
MySQL1045错误解决方法（ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using passwor:yes)）
技术老鸟
11-11 4450
修改MySQL的登录设置： vim /etc/my.cnf 在[mysqld]的段中加上一句：skip-grant-tables 例如： [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-grant-tables 保存并且退出vi。 3．重新启动mysqld service mysqld restart Stopping MySQL: [ OK ] Starting MySQL: [ OK ] 或者出现： Redire
PC通过tftp下载文件到GEC6818开发板出现ping fail；host is not alive問題
weixin_51036987的博客
11-23 1608
PC通过tftp下载文件到GEC6818开发板出现ping fail；host is not alive問題
解决ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL server 方法
july_2的专栏
12-12 4万+
1。 改表法。可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入mysql后，更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改称"%"  mysql -u root -pvmwaremysql>use mysql;mysql>update user set host = '%' where
虚拟机NAT模式下 Host ‘192.168.x.1‘ is not allowed to connect to this MySQL server 问题解决！
请大家直接把问题写在评论区或留言，不要只说一句"你好 或 在吗"，我会尽快回复的。
06-09 1万+
环境：本机地址：192.168.1.101虚拟机地址(NAT模式)：192.168.39.138刚在虚拟机上面安装好MySQL，但是用工具远程连接时候，报错，在cmd模式下，使用命令mysql -h 192.168.39.138 -u root -p yourpsswd 中报Host '192.168.39.1' is not allowed to connect ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值