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

[James Lewis]

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
>