How to share MySql database running on server to all as Remotely/ODBC..

Shri Saurabh

unread,

Apr 17, 2012, 6:51:52 AM4/17/12

to

Hi,

I want to share MySQL database running on server to all end
users? Tell me ASAP....

Jerry Stuckle

unread,

Apr 17, 2012, 7:25:19 AM4/17/12

to

MySQL allows multiple users to connect to the database concurrently.
Nothing special needs to be done (as long as you have configured MySQL
to be available to the network).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstu...@attglobal.net
==================

Shri Saurabh

unread,

Apr 17, 2012, 7:38:02 AM4/17/12

to

> jstuck...@attglobal.net
> ==================

I want to share MySql database by ODBC in local environment? how to do
it?

Captain Paralytic

unread,

Apr 17, 2012, 8:24:33 AM4/17/12

to

Same answer as before plus ensure that the ODBC driver is installed on
all the users' machines.

Shri Saurabh

unread,

Apr 17, 2012, 8:42:45 AM4/17/12

to

yes ODBC driver is installed on all machines.....

Jerry Stuckle

unread,

Apr 17, 2012, 11:37:21 AM4/17/12

to

On 4/17/2012 8:42 AM, Shri Saurabh wrote:
> On Apr 17, 5:24 pm, Captain Paralytic<paul_laut...@yahoo.com> wrote:
>> On Apr 17, 12:38 pm, Shri Saurabh<saurabh.goy...@gmail.com> wrote:
>>
>>
>>
>>
>>
>>
>>
>>> On Apr 17, 4:25 pm, Jerry Stuckle<jstuck...@attglobal.net> wrote:
>>
>>>> On 4/17/2012 6:51 AM, Shri Saurabh wrote:
>>
>>>>> Hi,
>>
>>>>> I want to share MySQL database running on server to all end
>>>>> users? Tell me ASAP....
>>
>>>> MySQL allows multiple users to connect to the database concurrently.
>>>> Nothing special needs to be done (as long as you have configured MySQL
>>>> to be available to the network).
>>
>>

>>> I want to share MySql database by ODBC in local environment? how to do
>>> it?
>>
>> Same answer as before plus ensure that the ODBC driver is installed on
>> all the users' machines.
>
> yes ODBC driver is installed on all machines.....

Then just ensure networking is enabled for MySQL and connect to it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

jstu...@attglobal.net
==================

Shri Saurabh

unread,

Apr 18, 2012, 3:01:06 AM4/18/12

to

> jstuck...@attglobal.net
> ==================

How to enable networking for MySql? tell me procedure....I am using
Xampp Server for MySql....

Kees Nuyt

unread,

Apr 18, 2012, 4:42:34 AM4/18/12

to

On Wed, 18 Apr 2012 00:01:06 -0700 (PDT), Shri Saurabh
<saurabh...@gmail.com> wrote:

>
> How to enable networking for MySql? tell me procedure....
> I am using Xampp Server for MySql....

http://www.google.nl/search?q=How%20to%20enable%20networking%20for%20MySql%20xampp

and two mouse clicks brought me to

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

Best regards,
--
( Kees Nuyt
)
c[_]

mikes

unread,

Apr 18, 2012, 5:53:29 AM4/18/12

to k.n...@nospam.demon.nl

skip_networking = no
bind = 0.0.0.0

in my.cnf (mysql configuration file)

Jerry Stuckle

unread,

Apr 18, 2012, 8:11:09 AM4/18/12

to

On 4/18/2012 3:01 AM, Shri Saurabh wrote:
> On Apr 17, 8:37 pm, Jerry Stuckle<jstuck...@attglobal.net> wrote:
>> On 4/17/2012 8:42 AM, Shri Saurabh wrote:
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>> On Apr 17, 5:24 pm, Captain Paralytic<paul_laut...@yahoo.com> wrote:
>>>> On Apr 17, 12:38 pm, Shri Saurabh<saurabh.goy...@gmail.com> wrote:
>>
>>>>> On Apr 17, 4:25 pm, Jerry Stuckle<jstuck...@attglobal.net> wrote:
>>
>>>>>> On 4/17/2012 6:51 AM, Shri Saurabh wrote:
>>
>>>>>>> Hi,
>>
>>>>>>> I want to share MySQL database running on server to all end
>>>>>>> users? Tell me ASAP....
>>
>>>>>> MySQL allows multiple users to connect to the database concurrently.
>>>>>> Nothing special needs to be done (as long as you have configured MySQL
>>>>>> to be available to the network).
>>
>>>>> I want to share MySql database by ODBC in local environment? how to do
>>>>> it?
>>
>>>> Same answer as before plus ensure that the ODBC driver is installed on
>>>> all the users' machines.
>>
>>> yes ODBC driver is installed on all machines.....
>>
>> Then just ensure networking is enabled for MySQL and connect to it.
>>
>

> How to enable networking for MySql? tell me procedure....I am using
> Xampp Server for MySql....

Have you even looked at the manual?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

jstu...@attglobal.net
==================

Brian Cryer

unread,

Apr 18, 2012, 4:07:25 AM4/18/12

to

"Shri Saurabh" <saurabh...@gmail.com> wrote in message
news:a2d844e5-ed5c-4edb...@js1g2000pbc.googlegroups.com...

> On Apr 17, 8:37 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> > On 4/17/2012 8:42 AM, Shri Saurabh wrote:

<snip>

> > Then just ensure networking is enabled for MySQL and connect to it.
>

> How to enable networking for MySql? tell me procedure....I am using
> Xampp Server for MySql....

Like others have indicated, you just connect to it. Nothing special required
... well, almost. So:

1. What error do you get when you try to connect?

2. Do you have user accounts defined in MySQL? If not then this will be
implied by your answer to question 1 above.

3. What application are you trying to connect from?

4. The only thing you might need to do on the server is to ensure that the
port is open in the firewall. The default is port 3306, but it might be
different for you, especially if you have multiple MySQL instances.

5. It is the MySQL ODBC driver that you have installed on your clients not
some other ODBC driver? Do you need help with the connection string
(although this comes back to what applications are you trying to connect
from)?
--
Brian Cryer
http://www.cryer.co.uk/brian