Please keep in mind that when you run
USER() reports how you attempted to authenticate in mysqld
CURRENT_USER() reports how you were allowed to authenticate by mysqld
This means you should run this query
SHOW GRANTS FOR CURRENT_USER();
to actually see your credentials. If you run,
SHOW GRANTS FOR USER();
you may not see credentials if they do not exist in
Just try to make the appropriate user on the MySQL Instance.
UPDATE 2013-03-05 16:51 EST
In you comment, you said
Grants shows that 'GRANT USAGE ON . TO \'techboy\'@\'%\' IDENTIFIED BY PASSWORD \'and a character string\'' and 'GRANT ALL PRIVILEGES ON lfc_123awards.* TO \'techboy\'@\'%\' WITH GRANT OPTION'
Since you only have rights to the
lfc_123awards database, please make sure you are specifying that database when you connect. If you do not set the default database at authentication, it will not let you connect at all.
Here is what I mean: Let say you trying connecting from the command line
mysql -utechbox -p -hIPofDBServer
This should fail, whereas
mysql -utechbox -p -hIPofDBServer -Dlfc_123awards