Jump to content

Granting User Permissions


bravo14

Recommended Posts

I am trying to grant permission to a user on a mysql database

 

GRANT ALL permissions TO 'yardleyheroes.*' ON 'yardleyheroes@server213-171-218-147.livedns.org.uk'

 

Can anybody give me any guidance

Link to post
Share on other sites

The error message I am getting here is

#1064 - 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 'permissions to 'yardleyheroes.*' on 'yardleyheroes@server213-171-218-147.livedns' at line 1

Link to post
Share on other sites
  • 2 weeks later...

Hello

 

I am trying to grant permissions on another database and used the template as laid out above

 

GRANT ALL permissions ON 'cyb@server213-171-219-90.livedns.org.uk' TO 'cybadmin.*';

 

and get the following error message

 

#1064 - 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 'permissions  ON 'cyb@server213-171-219-90.livedns.org.uk'TO 'cybadmin.*'' at line 1

 

MySQL client version: 5.0.22

 

does anybody have guidance

Link to post
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.