MySQL Forums
Forum List  »  Security

Access denied
Posted by: Asad Raza
Date: October 24, 2010 02:55AM

Dear All,

I have created a read only user using following command

grant select on storedb.view_transactions to 'testing'@'127.0.0.1' identified by 'testing';

When I try to generate CSV with through 'testing' user it gives me following error
"ERROR 1045 (28000): Access denied for user 'testing'@'127.0.0.1' (using password: YES)"

However I can do select * from view_transactions without any issue. I believe some privilege needs to be granted to 'testing' user in order to be able to generate CVS. Please help me in this regard.

Any help will greatly be appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
Access denied
4607
October 24, 2010 02:55AM
1592
October 24, 2010 11:14PM
1628
October 25, 2010 04:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.