Solved

MYSQL Connection over LAN

Posted on 2006-10-25
7
3,565 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
7 Comments
 
LVL 10

Expert Comment

by:mbvvsatish
Comment Utility
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
Comment Utility
MySQL Connector/ODBC and .Net Driver
0
 

Expert Comment

by:anil1974
Comment Utility
MySQL Connector/ODBC and  .Net
0
 
LVL 12

Accepted Solution

by:
str_kani earned 20 total points
Comment Utility
>>> 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
Comment Utility
I also got the same issue,
I checked the firewall but it's off, how can I check for the port?
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

763 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now