Solved

MYSQL Connection over LAN

Posted on 2006-10-25
7
3,570 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

867 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

15 Experts available now in Live!

Get 1:1 Help Now