468,766 Members | 1,484 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,766 developers. It's quick & easy.

How i connect other pc on lan to mysql server

hi

i have mysql server on my pc. i have vb.net application which uses mysql as database. i want to access mysql from other pc on lan.
plz help me
i tried through myodbc but it gives error.

[MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'http://192.168.1.15/localhost' (11004)

plz help me
Nov 1 '06 #1
3 17288
bartonc
6,596 Expert 4TB
hi

i have mysql server on my pc. i have vb.net application which uses mysql as database. i want to access mysql from other pc on lan.
plz help me
i tried through myodbc but it gives error.

[MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'http://192.168.1.15/localhost' (11004)

plz help me
On Windows, you can use 'server_name' or '192.168.1.15' or 'localhost'. 'localhost' connects from the machine that mysqld is running on. 'server_name' and IP address connect from clients given the name OR the IP address of the server.
Nov 1 '06 #2
Motoma
3,237 Expert 2GB
hi

i have mysql server on my pc. i have vb.net application which uses mysql as database. i want to access mysql from other pc on lan.
plz help me
i tried through myodbc but it gives error.

[MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'http://192.168.1.15/localhost' (11004)

plz help me
The problem is that you are trying to use the HTTP protocol to access your MySQL database. This will never work.

Typically the way to build a MySQL URI is like so:

mysql://username:password@iporhostname/databasename

But usually, even that is not required. What tool are you using to connect to the database?
Nov 22 '07 #3
gaubun
6
Hi all ,
even I am also wanted to know the same thing....
I want to connect my mysql database with other computers on lan....
I am using VB6 as frontend and myodbc as connector...

Plz help.

Gaurav
Jan 9 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Ryan Stewart | last post: by
2 posts views Thread by xiuchuanli | last post: by
5 posts views Thread by news.telia.net | last post: by
2 posts views Thread by Martin | last post: by
5 posts views Thread by scorpionbilli | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.