MySQL Forums
Forum List  »  Newbie

Create read only user for database
Posted by: Marc Moennikes
Date: November 19, 2015 05:15AM

Hello,

i am trying to add a read only user to my mysql database.

I have added the user as username@localhost and username@%

I can not connect to the mysql Server from localhost and remote.

I am getting the error in mysql log:

Warning] Aborted connection 64 to db: 'database1' user: 'readonly' host: 'RemoteComputer' (init_connect command failed)
and
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''SET NAMES utf8'' at line 1

I have tested different permissions.

The Connection only works if the user has the global privileges "super"...

Regards

Marc

Options: ReplyQuote


Subject
Written By
Posted
Create read only user for database
November 19, 2015 05:15AM


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.