> I would think that if the user does not have grant options set on the
> particular DB in the mysql.db table, then he would not be able to access
it
> using DBI, even if he is a local user.
I have already tried to do it by myself. and I found that although any user
has no MYSQL user's account, but he can still update data to Mysql Database
via perl DBI because they know user and password of MYSQL when your perl
code in written in text format?NEED more Help
Million of thanks
Regards
Taing Nguon
> At 10:52 PM 4/2/01, you wrote:
> >Dear sir or madam
> >
> > MySQL user's account is not related to user's account on Linux
> > System, so they can be different.
> >
> >My problem is that I use perl DBI to interact MySQL server as belows:
> >
> >------
> >use DBI;
> >$dbh = DBI->connect("DBI:mysql:DatabaseName","$user","$password");
> >
> >-------
> >
> >So $user and $password can be known by any users in Linux system
> >because they are written in text format and DataBase can be changed or
> >updated by other users in Linux system easily by using Perl DBI. Is there
> >any way to prevent Database from being changed? Millon of thanks!!!!
> >
> >
> >Regards
> >
> >Taing Nguon
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
