Member Avatar for sashiksu

I connected lap and desktop via crossover and assign ipv4 address .
after that I ping and got reply success
after I open mysql connection and type,
host-ip of pc,username,password and access to specified ip address's pc DB success.
Like wise I follow those steps for lan network which centralised by switch. It ping success each whatever I want pc from all computers
before ping I run ipconfig command to got ip addresses. then I see ipv6 and ipv4 address.
then my problem,
same way I used lap and desktop, I open mysql connection window and put server machine ipv4 address and trying to connect. it connected but won't show db. but db was on that pc.
after all I run **arp -a **command and gathered all ip address of this lan network. then I put all ip address at host part of connection one by one. but there is no db from all pc's. when I checked manually on sever there was db.
for this reason I enter some ip addresses which are not assign on that lan. (ip entered at host part of connection ) then there also it connect without any problems.

  • 3 Contributors
  • 2 Replies
  • 393 Views
  • 8 Months Discussion Span
  • Latest Post Latest Post by Elum_1

Dani AI

Generated

As described, ICMP (ping) and simple IP visibility can be fine while MySQL access behaves oddly: the client "connects" but the expected database does not appear, and even some IPs that are not assigned appear to accept a connection. ’s IP‑conflict idea is one possible cause, but the common culprits are: MySQL bound to localhost only (or skip_networking enabled), the MySQL account is restricted to specific client hosts, a firewall/NAT/port‑forwarder intercepting the connection, or the client actually reaching a different MySQL instance than intended.

Checklist and quick diagnostics to run (server + client):

  • From a client, force a TCP connection and identify the server you reached:

    mysql -u username -p -h 192.168.1.10 -P 3306
SELECT @@hostname, @@version;
SHOW DATABASES;

  • Verify TCP connectivity (PowerShell / Linux examples):

    Test-NetConnection -ComputerName 192.168.1.10 -Port 3306
nc -vz 192.168.1.10 3306

  • On the MySQL server, check network settings and user hosts:

    SHOW VARIABLES LIKE 'bind_address';
SHOW VARIABLES LIKE 'skip_networking';
SELECT Host, User FROM mysql.user WHERE User='username';

Key fixes and configuration points:

  • If bind_address = 127.0.0.1 or skip_networking = ON, edit my.cnf/my.ini to allow LAN bind (example: bind-address = 0.0.0.0) and restart MySQL.

  • Grant the client host the proper privileges (example):

    GRANT ALL PRIVILEGES ON dbname.* TO 'username'@'192.168.1.%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

  • Open inbound TCP port 3306 on the server firewall (Windows Firewall / iptables) and confirm no router NAT/port‑forward is redirecting traffic. Clear stale ARP entries if needed (Windows: netsh interface ip delete arpcache; Linux: ip neigh flush all).

Notes and cautions: SHOW DATABASES only lists schemas the connected MySQL account can see, so a successful connection may still show no DBs if privileges are missing. If a GUI appears to "connect" to arbitrary IPs, prefer the CLI tests above and SELECT @@hostname to identify which server answered. Exposing MySQL on a network requires strong passwords and tight host grants; where possible use SSH tunnels or bind to specific IPs rather than 0.0.0.0.

Recommended Answers

All 2 Replies

Member Avatar for techsheaven

I'm not sure what the question in all of that was, but It sounds like you had an IP conflict, and figured it out. If you are still having a problem, maybe you could give more specific details about your adaptersetting, and what our hope to accomplish.

Member Avatar for Elum_1

Your Question isnt Very Clear Enough,

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.