Mailinglist Archive: opensuse (4053 mails)

< Previous Next >
Re: [SLE] MySQL Network Server Setup
  • From: <dog@xxxxxxxxx>
  • Date: Wed, 29 Aug 2001 10:36:44 -0500 (CDT)
  • Message-id: <Pine.LNX.4.31.0108291035440.12588-100000@xxxxxxxxxxxxx>
really, it does? glad i could be of some help then.


On Wed, 29 Aug 2001 kbb0927@xxxxxx wrote:

>Thanks. That makes sense and is easy enough.
>
>Regards,
>
>Keith B.
>
><dog@xxxxxxxxx> wrote:
>
>>all you need to do is setup mysql on the server and set grant permissions
>>on your tables to allow access (read, write, whatever) for users and
>>machines on your local lan. thats about it for the server. for the
>>clients though, you will need to set the app you have to connect to the
>>database on the mysql server when the app is called. for this, i have no
>>idea how to do it but assume you do since its your app.
>>
>>as for granting permissions on the tables, here is how you do that
>>on the server, startup a mysql session as a user with grant privileges on
>>all tables
>>then do
>>
>>grant all privileges on *.* to user@xxxxxxxxxxxxx identified by 'password'
>>with grant option;
>>
>>what this does is give all privileges to all tables user on machine
>>your.host.com.
>>if you dont want the user to have all privileges, you can do
>>
>>grant select,insert,delete,update on *.* to user@xxxxxxxxxxxxx identified
>>by 'password';
>>
>>or some combination of things like that. note, for this to work
>>correctly, you need to have dns or your /etc/hosts file listing ip
>>addresses to machine names.
>>
>>
>>On Wed, 29 Aug 2001 kbb0927@xxxxxx wrote:
>>
>>>Hello All,
>>>
>>>I use eS3.1 as a linux-only server on a home lan with mixed Linux/windoze
>>>boxen. I have migrated from Delphi 5 to Kylix and am developing database
>>>applications as well as migrating an existing app. However I need to
>>>convert my dbf files to mysql. I run this as a sort-of client server app
>>>under Delphi, but not a true client-server app. I will need to be able
>>>to centrally access/update/manage the database files from the server.
>>>
>>>How do I set up MySQl so that each Linux box connects at boot up to the
>>>server? I have a /public directory for the mixed lan. I need to have
>>>"global" access (w/proper users/security) so that each box can run the
>>>app seamlessly connected to mysql on the server. Once I get this done, I
>>>can figure it out for the windoze boxen. I use SuSE 7.2 personal on the
>>>workstations.
>>>
>>>Can anyone give a Step By Step or point me to a site with this or a HowTO?
>>>
>>>I have read several books/mag articles, but they are just generic local
>>>setup and confusing to this newbie.
>>>
>>>Thanks in advance and regards,
>>>
>>>Keith B.
>>>
>>>
>>>--
>>>To unsubscribe send e-mail to suse-linux-e-unsubscribe@xxxxxxxx
>>>For additional commands send e-mail to suse-linux-e-help@xxxxxxxx
>>>Also check the FAQ at http://www.suse.com/support/faq and the
>>>archives at http://lists.suse.com
>>>
>>
>>Chad Whitten
>>Network/Systems Administrator
>>Nexband Communications
>>chadwick@xxxxxxxxxxx
>>
>>
>>--
>>To unsubscribe send e-mail to suse-linux-e-unsubscribe@xxxxxxxx
>>For additional commands send e-mail to suse-linux-e-help@xxxxxxxx
>>Also check the FAQ at http://www.suse.com/support/faq and the
>>archives at http://lists.suse.com
>>
>>
>
>
>--
>To unsubscribe send e-mail to suse-linux-e-unsubscribe@xxxxxxxx
>For additional commands send e-mail to suse-linux-e-help@xxxxxxxx
>Also check the FAQ at http://www.suse.com/support/faq and the
>archives at http://lists.suse.com
>

Chad Whitten
Network/Systems Administrator
Nexband Communications
chadwick@xxxxxxxxxxx


< Previous Next >
This Thread
References