On Sep 30, 2008, at 4:30 PM, Mike Mabey wrote:
> Okay, so I'm guessing no one has had something similar happen and no
> one has
> any suggestions for me, then? I've tried changing the password for
> account
> B in an attempt to eliminate the possibility that anything was wrong
> with
> it, whether it be the special characters it contained or just the
> way I was
> entering it. I can still log on to the MySQL server directly
> without any
> problem with account B (and account A), but I can only get the
> Connection
> Editor to successfully test the credentials of account A, which only
> differs
> in privileges from account B by having CREATE and DROP.
>
> Please help me if you have any ideas.
Sorry, I must have missed your original email. There is a way to see
the current user's priveleges, documented at
http://dev.mysql.com/doc/refman/5.0/en/show-grants.html
. Basically, while logged in, you can issue any of the following:
SHOW GRANTS;
SHOW GRANTS FOR CURRENT_USER;
SHOW GRANTS FOR CURRENT_USER();
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
