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

[David Favor]

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