Mysql – GRANT ROLE TO USER in MySQL

MySQLmysql-5.6permissionsrole

I created one role QI_RO, granted all privileges on all schemas on the server and I was trying to grant role privilege to another user but throwing error.

GRANT QI_RO to test_user@'%';

Error Message:

ERROR 1064 (42000): 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 'QI_RO to test_user@'%'' at line 1

DB version:

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.6.10    |
+-----------+
1 row in set (0.00 sec)

How to grant role privileges to users in Mysql like other databases, Postgres and oracle?

Thanks

Best Answer

It is only supported in mysql 8 https://dev.mysql.com/doc/refman/8.0/en/roles.html

Related Solutions

Mysql query not working

Your problem is the quotes you are using for the default of NAME.

Here is your original create table from the question

CREATE TABLE `fish` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(30) NOT NULL default ‘’, <<--- LOOK HERE
`PRICE` decimal(5,2) NOT NULL default ‘0.00’,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

You gave default ‘’ and the mysql client does not understand it.

You need to express it with standard single quotes like this : default ''

I just noticed that a_horse_with_no_name's comment already says this.

Don't change anything else. Leave all other quotes as is.

Give it a Try !!!

MySQL “SLEEP” command throws syntax error

You have to use

select sleep(5);

because it is similar to other mysql functions.

Best Answer

Related Solutions

Mysql query not working

MySQL “SLEEP” command throws syntax error

Related Question