User access denied for '%' in 5.6
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
Subject
Views
Written By
Posted
User access denied for '%' in 5.6
1839
August 19, 2013 11:51AM
761
August 26, 2013 12:14PM
706
August 30, 2013 07:50AM
878
August 30, 2013 09:26AM
699
August 31, 2013 05:09PM
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.