NYCPHP Meetup

[nycphp-talk] MySQL Database permisions..

jahmon :-) jahmon at jahmon.com
Mon Jun 10 13:52:32 EDT 2002


you don't have to use GRANT for this to work correctly but that's probably
the easiest and quickest way.

CREATE $database
GRANT all privileges on $database.* to $user at localhost identified by
'$password';

no need to flush privileges

jahmon ;-)

On Mon, Jun 10, 2002 at 01:39:39PM -0400, Ian Forsyth wrote:
> Hi,
> 
> I am setting up a server for several different accounts. Every account
> requires a database.
> 
> I am restricting database access to localhost, and some ips..
> 
> I am trying to limit a user to just use one database.. I have put an entry
> into the mysql.db table an it seems to do nothing.. i have flushed
> privileges, and done use dbname.. and to no avail the new user i created has
> access to all databases..
> 
> Do have have use GRANT in order to do this correctly? I thought i could just
> do a manual insert into the mysql.db table..
> 
> Ian
> 
> > -----Original Message-----
> > From: LY [mailto:heli_travel at yahoo.com]
> > Sent: Monday, June 10, 2002 12:13 PM
> > To: NYPHP Talk
> > Subject: Re: [nycphp-talk] Does anyone know how to do this?
> >
> >
> > it open ebay's page, get that time and posted it on they
> > website.
> > syntax like:
> > $str =
> > fopen("http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=2110024616",
> > "r")
> > then use regular expression to capture the data they want(time).
> > they should have an agreement between each other foring doing
> > this.
> > you can check this out form php books in i/o functions.
> >
> >
> >
> > --- sean wang <terran11355 at yahoo.com> wrote:
> > > hi, everyone
> > > I saw this website ( www.chinese-treasure.com ) by
> > > accidently. I found that each item ends time is same
> > > as ebay't time, everytime i refreshed pages the ends
> > > time are all same as ebay'time. I just want to know
> > > how to do this?
> > > Does this website use mysql db?
> > >
> > > I really want to know this!!
> > >
> > > thanks
> > >
> > > sean
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Yahoo! - Official partner of 2002 FIFA World Cup
> > > http://fifaworldcup.yahoo.com
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! - Official partner of 2002 FIFA World Cup
> > http://fifaworldcup.yahoo.com
> >
> >
> 
> 

-- 



More information about the talk mailing list