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

[David Favor]

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