473,394 Members | 1,663 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

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 17489
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

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

Similar topics

0
by: Ryan Stewart | last post by:
I'm running MySQL server on a WinXP box at home. I have a cable modem/router. I've set up port forwarding on port 3306 to the machine running MySQL. I can connect locally just fine, but when I try...
1
by: ikrabbe | last post by:
Hi, I want to set up a mysql server in an embedded process. I managed to start the server in my program as described through mysql_server_init() Now I need a client connection to this...
3
by: Pugi! | last post by:
On a freshly installed Fedora C3 (incl. webserver apache php mysql) i get the following problem when connecting to mysql through a browser (phpMyAdmin): : #2002 Can't connect to local MySQL...
1
by: jiing | last post by:
Now let me describe what I have done and my purpose: Originally, I want to user ports to install phpBB But I found that phpBB doesn't support mysql 5.x (but the ports installed mySQL 5.0.0...
2
by: xiuchuanli | last post by:
I install Fedora 4 with web server, after that I installed mysql 5.0.15. Now I can connect to mysql from command line and mysql-administrator and mysql-query-browser. But when I try to test to...
5
by: smatta | last post by:
I have just installed MySql version 5.0-18 on Red Hat Fedora Core 4. It is running but I cant connect to it using MySql Query Browser running on my pc. >From my pc, I can telnet to the sql...
5
by: news.telia.net | last post by:
Hi! I have a question. I have installed php and mysql on an apache-server on windows and I can't connect to the server. I tried to create a database (since I am trying to learn howto). My...
2
by: Martin | last post by:
Hi all. I have a fully functional page hosted on my PC that uses PHP and connects to MySQL on my PC to generate it's code. I now have some web hosting available which includes both PHP and...
3
by: arasub | last post by:
ep 20, 2007 11:25:57 AM org.apache.catalina.core.AprLifecycleListener lifecycleEvent INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found...
5
by: scorpionbilli | last post by:
Hi, The local mysql server is running on my Macbook. I can access it through the console client: $ mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.