My SQL ODBC connectivity in Networks

------=_Part_50252_20714337.1151914482909
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

I will describe my problem.

I have MySQL running in one machine... and say I have one database in it.

Now I want to create a ODBC connectivity in another machine for the MySQL
database in other machine...

This is the setup...

Now what are the parameters which I should give....


Server:

User:

Password:

my doubts are...server name should be the IP address of the machine in which
MySQL is running?

Can you help in this regard...

Thanks in advance...

Regards,
Sathish Kumar S

------=_Part_50252_20714337.1151914482909--

RE: My SQL ODBC connectivity in Networks

Hi Sathish,

The parameters for an ODBC connection need to point to the server machine,
yes. If you're on a windows network then you can use a machine name rather
than an IP address, which covers you in the event that the server's IP
address changes. I assume the same is true on any TCP/IP network, but my
Linux experience is minimal I'm afraid.

The user and password need to be ones that you've set up in advance. Note:
users not only have a username but also an identifier saying where they can
access the database from. For instance, you may well find that root access
is set up as 'root'@'localhost', meaning that you can only log in as root if
you're logging in on the server machine itself. Similarly,
'dobc_user'@'192.168.2.1' would mean you could only log in as odbc_user from
that IP address. You should look at creating a user 'my_user_name'@'%' - the
percent sign means "any" and lets you connect from any machine.

If you're prompted for PORT, by the way, you should probably enter 3306. I
think that's the default if you leave it blank, but it's the port that MySQL
usually runs over.

If I've missed anything obvious, list members feel free to correct me / add
stuff. Let us know if you've got any more questions.

Al McNicoll
Integritec Ltd
http://www.integritec.co.uk



-----Original Message-----
From: SATHISH KUMAR [mailto:sathishsimple@gmail.com]
Sent: 03 July 2006 09:15
To:
Subject: My SQL ODBC connectivity in Networks

Hi,

I will describe my problem.

I have MySQL running in one machine... and say I have one database in it.

Now I want to create a ODBC connectivity in another machine for the MySQL
database in other machine...

This is the setup...

Now what are the parameters which I should give....


Server:

User:

Password:

my doubts are...server name should be the IP address of the machine in which
MySQL is running?

Can you help in this regard...

Thanks in advance...

Regards,
Sathish Kumar S


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: My SQL ODBC connectivity in Networks

Hi,

> If I've missed anything obvious, list members feel free to correct
> me / add
> stuff. Let us know if you've got any more questions.

There is a quick overview page for this in the (newly updated) manual:

http://dev.mysql.com/doc/refman/5.1/en/myodbc-examples-walkt hrough.html

It's a basic, but straightforward, walkthrough designed to address
exactly the situation you are attempting.

There's also a more detailed guide on creating a suitable DSN on a
client machine:

http://dev.mysql.com/doc/refman/5.1/en/myodbc-configuration- dsn-
windows.html

If you think there are any missing steps here, or any other location
in the ODBC documentation, please let me know, or better still file a
bug report at http://bugs.mysql.com and I can update the docs
accordingly.

MC


--
Martin MC Brown, Technical Writer
MySQL AB, http://www.mysql.com
Skype: mcmcslp



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: My SQL ODBC connectivity in Networks

The server can be the IP address of the machine or the name providing
you have a DNS setup that allows the name to be converted to an IP
address. If you can reference the remote machine by name for other
purposes, e.g. accessing file shares, then you can use the name. The IP
address should work in all cases, assuming you are using TCP/IP comms.,
as most people are.

The user name and password can be any that the MySQL server knows about.
This means you are using the provided default users like "root" or you
have created other user/password combinations on the server by using
GRANT statements. Also remember that the GRANT statement can specify the
host(s) the user can login from, and these must be appropriate too or
the login will not be accepted.

John B.

-----Original Message-----
From: SATHISH KUMAR [mailto:sathishsimple@gmail.com]=20
Sent: Monday, 3 July 2006 5:45 PM
To: myodbc@lists.mysql.com
Subject: My SQL ODBC connectivity in Networks

Hi,

I will describe my problem.

I have MySQL running in one machine... and say I have one database in
it.

Now I want to create a ODBC connectivity in another machine for the
MySQL
database in other machine...

This is the setup...

Now what are the parameters which I should give....


Server:

User:

Password:

my doubts are...server name should be the IP address of the machine in
which
MySQL is running?

Can you help in this regard...

Thanks in advance...

Regards,
Sathish Kumar S

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg