Mailinglist Archive: opensuse (4053 mails)

< Previous Next >
Re: [SLE] MySQL Network Server Setup
  • From: kbb0927@xxxxxx
  • Date: Wed, 29 Aug 2001 11:09:55 -0400
  • Message-id: <51DC0471.7A15473E.001F3C81@xxxxxx>
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
>
>


< Previous Next >
This Thread
Follow Ups