Solved

MYSQL Connection over LAN

Posted on 2006-10-25
7
3,597 Views
Last Modified: 2009-05-01
I have two windows XP Professional machines connected over LAN and installed MYSQL 4.1 Server ( choosen Dedicated Server while configuration ) . I am getting connection error connecting it thorough other machine via MyODBC 3.51 Driver

I am giving information as follows

Data Source Name : TestDSN
Description : my test DSN
Server : 192.168.1.3  

This is my other machine ip address assigned over LAN ( Name of computer P4 also used in place of ip address )

User : root
Password : <password>

I had created a user vinod with password vinod giving all the permission with the help of SQLYog GUI software

But still facing an error Can't connect on MySQL server on '192.168.1.3' (10060)
0
Comment
Question by:psaini172000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 10

Expert Comment

by:mbvvsatish
ID: 17857662
you need to login to mysql from command prompt in the machine where mysql is installed.
and at the mysql command prompt give this command

mysql>grant all privileges on *.* to vinod@192.168.1.3 identified by '' with grant option;

>identified by ''
should contain your password if one exists

now restart the mysql windows service and try to connect from other machine.
0
 

Expert Comment

by:anil1974
ID: 17922232
MySQL Connector/ODBC and .Net Driver
0
 

Expert Comment

by:anil1974
ID: 17922296
MySQL Connector/ODBC and  .Net
0
 
LVL 12

Accepted Solution

by:
str_kani earned 20 total points
ID: 18828060
>>> Can't connect on MySQL server on '192.168.1.3' (10060)

this suggests that the client not able to connect to the other machine 192.168.1.3 make sure the firewall donesn't block any connection on port 3306 the default port.

With this error message you cannot say that is any access issues with rights or passwords. check this firewall issue, and also make sure you are able to connect to the mysql on the machine where it installed.
0
 
LVL 1

Expert Comment

by:dreamluverz
ID: 24279163
I also got the same issue,
I checked the firewall but it's off, how can I check for the port?
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question