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 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? 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 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... 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 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 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. Link to comment https://forums.phpfreaks.com/topic/109275-granting-user-permissions/#findComment-574334 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.