Thanks Ed. I looked through the MySQL documentation forever trying to find that. Sure helps to know exactly what you're looking for.
So to answer your second question more definitively, Paul, Account A has: ALL PRIVILEGES Account B has: SELECT, INSERT, UPDATE To recap so you don't have to find my previous emails, when I test a connection with the Connection Editor using the login credentials for account B, the test fails. But f I only change the username and password to be that of account A, it tests just fine. I've confirmed that this is not unique to the Connection Editor, but that this also prevents me from opening the app from the command line. Any thoughts why account B can't connect through Dabo? Thanks, Mike M. On Tue, Sep 30, 2008 at 4:49 PM, Ed Leafe <[EMAIL PROTECTED]> wrote: > 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 > > > > > [excessive quoting removed by server] _______________________________________________ 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]
