You are connecting TO host www.4cdg.com, but the permission table entry
list the hosts you connect FROM.
You need to grant privileges to the user and machine you connect FROM.
Butch Evans wrote:
> Can anyone explain why this is happening?
>
>
> root@www:/# mysql -u dgadmin -h www.4cdg.com -p cdgcatalog
> Enter password:
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
> password: YES)
>
>
> Here is the permissions table:
> mysql> select host,db,user from db where db like "cdgcatalog";
> +--------------+------------+----------+
> | host | db | user |
> +--------------+------------+----------+
> | www.4cdg.com | cdgcatalog | dgadmin |
> | www.4cdg.com | cdgcatalog | dgpublic |
> +--------------+------------+----------+
> 2 rows in set (0.00 sec)
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
