通过LAN WAMP拒绝Mysql访问

I have 2 computers with IP Addresses xxx.x.x.32 and xxx.x.x.35. Both have WAMP server running and are online. For my application both the above mentioned computers are servers and xxx.x.x.35 needs to access xxx.x.x.32's Mysql database as root user. Initially when I went to the cmd.exe of xxx.x.x.35 and typed in C:>mysql -u root -h xxx.x.x.32 -p and typed in the password I got the following error:- ERROR 1130(HY000): Host xxx.x.x.35 is not allowed to connect to this mysql server...

I then executed the following command on xxx.x.x.32:- GRANT ALL ON *.* TO 'root'@'xxx.x.x.35';FLUSH PRIVILEGES;.

After that on xxx.x.x.35 I executed the first command and got the following error:-

ERROR 1045(28000): Access denied for root@xxx.x.x.35.

The firewall is turned off. In other words I want to access the xxx.x.x.32 database as it's own root user from another machine namely xxx.x.x.35 Please do get back to me if there needs to be any clarification in the question.

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

报告相同问题？

关注问题

Zurmo CRM：通过Lan从远程机器访问Wamp服务器 php
2015-09-06 12:11

回答 2 已采纳 I got it working by following step: There is a file in app\protected\config with name perInstance
wamp服务器如何通过点点斜杠防止访问根文件夹上方 php
2018-07-14 20:19

回答 1 已采纳 use realpath function to get the actual path(which does not contain any ..), then check if it begi
使用其他设备访问localhost（wamp） apache php
2017-11-07 12:41

回答 1 已采纳 Try disabling Windows firewall. If that works, open port 80 in the firewall settings and reenable.
wamp下修改mysql访问密码的解决方法
2020-12-18 13:58

学习php，使用了wamp安装包来搭建php+apache+mysql的环境，wamp官方下载地址：http://www.wampserver.com/en/ .但是wamp默认的用户名是’root’，密码是空。现在我需要把密码改成自己想要的字符串。我的wamp的安装...
Wamp和Xampp“您的PHP安装似乎缺少WordPress所需的MySQL扩展。”[重复] mysql php
2018-11-15 22:39

回答 1 已采纳 OK I just found a solution that works for me: in wamp, click on the icon -> php -> version -
如何通过php在mysql（wamp）数据库中插入数据？ database mysql php
2015-10-09 08:18

回答 2 已采纳 There is an extra comma (,) in your SQL at the end. The correct one would be - $sql = "INSERT IN
导入mysql数据库到wamp服务器 database mysql php
2011-05-07 11:57

回答 3 已采纳 left click wamp -> phpmyadmin select database then click import (top right) locate the databas
dos或wamp下修改mysql密码的具体方法
2020-09-10 17:25

主要介绍了dos或wamp下修改mysql密码的具体方法，有需要的朋友可以参考一下
PHP / MYSQL：表未在wamp服务器中创建 mysql php
2014-02-11 22:45

回答 4 已采纳 <?php $sql='CREATE TABLE users ( PID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(PID), NAME CHAR(2
Php网页无法显示带有Wamp Server的产品列表 mysql php
2018-07-05 00:12

回答 2 已采纳 Your $con is probably empty. You need to call Connection.php at the top of your category.php page.
用户root @ localhost [duplicate]拒绝访问 mysql php
2015-08-29 15:30

回答 3 已采纳 Let the following 2 lines fail if user exists and blahblah doesnt matter for now: create user 'ro
wamp出现拒绝访问
2019-02-27 14:56

中流击水浪遏飞舟的博客如果访问phpmyadmin的时候不能访问，出现：You don't have permission to access /phpmyadmin/ on this server. 同样，在wamp\alias下找到phpmyadmin.conf，把 <Directory "c:/wamp/apps/phpmyadmin...
我的mysql数据库在wamp有什么问题？ mysql php
2014-02-17 06:34

回答 1 已采纳 You need to enable the mb_string extension on WAMP . This is a seperate extension and you need to
wamp修改mysql密码.docx
2019-10-11 10:38

WampServer安装后密码是空的，需要设置一下mysql的密码
如何修改WAMP中mysql默认空密码的方法
2020-09-11 04:05

WAMP安装好后，mysql密码是为空的，那么要如何修改呢？其实很简单，通过几条指令就行了，下面我就一步步来操作。
WINDOWS+WAMP+PHP环境下稳定通过SSH访问Mysql
2018-07-13 16:24

举例：在本机windows服务器如何通过SSH稳定访问192.168.1.1上的Mysql数据库 1.打开putty 2.选择参数tunnels 设置Source port :3388 Destination : 192.168.1.1:3306 点击add 3.选择putty登录界面，选择ssh 输入...
wamp中mysql安装时能启动重启后无法启动的解决办法
2020-12-15 22:31

第一次安装wamp之后，所有服务可以正常使用，但是重启之后wamp的图标就变成黄色的了，重装了也这样 ...以上所述是小编给大家介绍的wamp中mysql安装时能启动重启后无法启动的解决办法，希望对大家有所帮助，如果
没有解决我的问题, 去提问

悬赏问题

¥15 vue3加ant-design-vue无法渲染出页面
¥15 matlab（相关搜索：紧聚焦）
¥15 基于51单片机的厨房煤气泄露检测报警系统设计
¥15 路易威登官网里边的参数逆向
¥15 Arduino无法同时连接多个hx711模块，如何解决？
¥50 需求一个up主付费课程
¥20 模型在y分布之外的数据上预测能力不好如何解决
¥15 processing提取音乐节奏
¥15 gg加速器加速游戏时，提示不是x86架构
¥15 python按要求编写程序

码龄粉丝数原力等级 --

通过LAN WAMP拒绝Mysql访问

0条回答默认最新

悬赏问题

通过LAN WAMP拒绝Mysql访问

0条回答 默认 最新

悬赏问题

0条回答默认最新