List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:August 14 2001 1:16pm
Subject:Re: Permissions Problems
View as plain text  
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: 'dgadmin@stripped' (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
gerald_clark@stripped

Thread
Permissions ProblemsButch Evans14 Aug
  • RE: Permissions ProblemsCarsten H. Pedersen14 Aug
  • Re: Permissions Problemsindrek siitan14 Aug
  • Re: Permissions ProblemsGerald Clark14 Aug
    • Re: Permissions ProblemsButch Evans15 Aug