Re: [Phpgroupware-users] Question about creating mysql database

[Patrick J. Walsh]

    FWIW, I don't think grant commands ever say that any rows have been
manipulated.  I know that that has thrown me off before, but if you start
looking at the mysql table I think you will see that things change despite
that message.

----- Original Message -----
From: "David Favor" <address@hidden>
To: <address@hidden>
Sent: Tuesday, November 27, 2001 8:26 AM
Subject: Re: [Phpgroupware-users] Question about creating mysql database


> Whoever the doc maintainer is, I suggest putting this info in the
> "Create your database" section of the INSTALL file. It seems odd
> this step is left out.
>
> I guess when I have time, I will go through the mysql manual and
> figure this out. It would be much faster, just to have all the
> commands required to install the product in the INSTALL file.
>
> _______
>
>
> James Lewis wrote:
> >
> > http://www.mysql.com/doc/A/d/Adding_users.html
> >
> > http://www.mysql.com/doc/U/s/User_Account_Management.html
> >
> > James
> >
> > ----- Original Message -----
> > From: "David Favor" <address@hidden>
> > To: <address@hidden>
> > Sent: Tuesday, November 27, 2001 7:47 AM
> > Subject: Re: [Phpgroupware-users] Question about creating mysql database
> >
> > > I used the following from the INSTALL file:
> > >
> > >    Create your database.
> > >         For MySQL:
> > >                 Login to MySQL
> > >                 > create database phpgroupware;
> > >                 > grant all on phpgroupware.* to
address@hidden
> > identified by 'foo';
> > >
> > > What is the syntax to create the user 'phpgroupware'?
> > >
> > >
> > > Michael Marschall wrote:
> > > >
> > > > >I believe it should (as there is a table which stores access
rights,
> > and
> > > > >presumably grant just alters that table).
> > > >
> > > > This is correct.
> > > >
> > > > Mike
> > > >
> > > > James Lewis (address@hidden) wrote:
> > > > >
> > > > >David,
> > > > >I believe it should (as there is a table which stores access
rights,
> > and
> > > > >presumably grant just alters that table).
> > > > >
> > > > >Have you created a user called phpgroupware?
> > > > >
> > > > >James
> > > > >
> > > > >----- Original Message -----
> > > > >From: "David Favor" <address@hidden>
> > > > >To: "phpgroupware users" <address@hidden>
> > > > >Sent: Tuesday, November 27, 2001 6:03 AM
> > > > >Subject: [Phpgroupware-users] Question about creating mysql
database
> > > > >
> > > > >
> > > > >> I'm new to mysql. Should the grant command effect some database
> > entries?
> > > > >>
> > > > >>   mysql> create database phpgroupware;
> > > > >>   Query OK, 1 row affected (0.01 sec)
> > > > >>
> > > > >>   mysql> grant all on phpgroupware.* to address@hidden
> > identified
> > > > >by 'foo';
> > > > >>   Query OK, 0 rows affected (0.09 sec)
> > > > >>
> > > > >> Notice the "0 rows affected".
> > > > >>
> > > > >> _______________________________________________
> > > > >> Phpgroupware-users mailing list
> > > > >> address@hidden
> > > > >> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
> > > > >>
> > > > >
> > > > >
> > > > >_______________________________________________
> > > > >Phpgroupware-users mailing list
> > > > >address@hidden
> > > > >http://mail.gnu.org/mailman/listinfo/phpgroupware-users
> > > > >
> > > >
> > > > --
> > > > Michael Marschall
> > > > Network Architect, Web Designer
> > > > Essential Volume
> > > > http://www.essentialvolume.com
> > > >
> > > > _______________________________________________
> > > > Phpgroupware-users mailing list
> > > > address@hidden
> > > > http://mail.gnu.org/mailman/listinfo/phpgroupware-users
> > >
> > > _______________________________________________
> > > Phpgroupware-users mailing list
> > > address@hidden
> > > http://mail.gnu.org/mailman/listinfo/phpgroupware-users
> > >
> >
> > _______________________________________________
> > Phpgroupware-users mailing list
> > address@hidden
> > http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>