Re: [Phpgroupware-users] Setup/configuration problem

[Chris Weiss]

ah now we see, new to mysql?  short lesson:

- MySql does not use system users, it has its own users and permissions system.
- Users in mysql can also be restricted by hostname, so in phpgw if you set the
mysql server to something other than "localhost" make sure your mysql user has 
your
web servers FQDN as its host.
- Webmin's MySql module is the best GUI for creating and managing user
permissions.  phpMyAdmin is the best GUI interface for viewing/editing the data.
Without these two tools I'd have never even got started :).



Jacob S. (address@hidden) wrote*:
>
>Ok, the phpgroupware directory and everything in it is now owned by
>www-data:www-data.
>
>No, I was unable to create the database. It kept giving me an access
>denied error similar to the one phpgroupware/setup was giving me. I'm
>logged in as root while trying to create the empty database... I'm not
>sure why it errors. I've tried using root and other valid system users
>in place of "someuser", but it's all to no avail. It just says:
>
># mysqladmin -u root -p create phpgroupware
>Enter password:
>mysqladmin: connect to server at 'localhost' failed
>error: 'Access denied for user: 'address@hidden' (Using password: YES)'
>
>This is probably something simple, but I'm afraid I don't see it yet.
>
>Thanks,
>Jacob
>
>
>On Fri, 13 Dec 2002 17:37:43 +1100
>Dave Hall <address@hidden> wrote:
>
>> Ok 2 things here
>>
>> Firstly the whole phpgroupware tree should be owned by
>> www-data:www-data.  Secondly did you create the db, and grant the
>> permissions?
>> content-type: multipart/signed; protocol="application/pgp-signature";
>>      micalg="pgp-sha1"; boundary="=.2'SP.sVbW'VHXK"
>
>
>-----
>GnuPG Key: 1024D/16377135
>
>In a world without fences, who needs Gates?
>http://www.linux.org/
>