bravo14 Posted June 8, 2008 Share Posted June 8, 2008 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 Quote Link to comment Share on other sites More sharing options...
keeB Posted June 8, 2008 Share Posted June 8, 2008 What's the error? Quote Link to comment Share on other sites More sharing options...
bravo14 Posted June 8, 2008 Author Share Posted June 8, 2008 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted June 10, 2008 Share Posted June 10, 2008 ON... goes before TO... Quote Link to comment Share on other sites More sharing options...
bravo14 Posted June 24, 2008 Author Share Posted June 24, 2008 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 Quote Link to comment Share on other sites More sharing options...
bravo14 Posted June 24, 2008 Author Share Posted June 24, 2008 In addition to the previous post db is cyb Username is cybadmin Quote Link to comment Share on other sites More sharing options...
fenway Posted June 25, 2008 Share Posted June 25, 2008 This is the syntax: GRANT ALL ON mydb.* TO 'someuser'@'somehost'; Not the quoting before and after the @ sign. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.