MySQL Forums
Forum List  »  InnoDB

User access denied for '%' in 5.6
Posted by: rick mcdaniel
Date: August 19, 2013 11:51AM

MySQL 5.6

I executed this grant for a new user:
grant select on testdb.* to 'user1'@'%';
But this does not allow them to get connected?

I had to grant this before they could connect but I don't want my users to have this much access?
grant select on *.* to 'user1'@'%';

How do I allow access but limit the user to just a single user DB?


thx,
rick_806

Options: ReplyQuote


Subject
Views
Written By
Posted
User access denied for '%' in 5.6
1839
August 19, 2013 11:51AM


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.