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 '[email protected]' Can anybody give me any guidance Quote Link to comment https://forums.phpfreaks.com/topic/109275-granting-user-permissions/ 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 https://forums.phpfreaks.com/topic/109275-granting-user-permissions/#findComment-560545 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 '[email protected]' at line 1 Quote Link to comment https://forums.phpfreaks.com/topic/109275-granting-user-permissions/#findComment-560702 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 https://forums.phpfreaks.com/topic/109275-granting-user-permissions/#findComment-562381 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 '[email protected]' 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 '[email protected]'TO 'cybadmin.*'' at line 1 MySQL client version: 5.0.22 does anybody have guidance Quote Link to comment https://forums.phpfreaks.com/topic/109275-granting-user-permissions/#findComment-573533 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 https://forums.phpfreaks.com/topic/109275-granting-user-permissions/#findComment-573553 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 https://forums.phpfreaks.com/topic/109275-granting-user-permissions/#findComment-574334 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.