Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
MySql DB user no longers has permissions to insert
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- MySql DB user no longers has permissions to insert
MySql DB user no longers has permissions to insert
22-02-2014 3:19 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Hi,
My php script which inserts data into a table ( and worked before migration) now errors with :
INSERT command denied to user 'ccgibridge868385'@'10.130.1.51' for table 'jokes'
(Other scripts with SELECT commands work fine and are using the same DB connection details)
Searching around, I know I have to run a command like :
GRANT INSERT ON 'db'.'tablename' TO 'username'@'localhost'
However, I can't seem to see the grant command with the MySQL control panel ?
Any help greatly appreciated.
My php script which inserts data into a table ( and worked before migration) now errors with :
INSERT command denied to user 'ccgibridge868385'@'10.130.1.51' for table 'jokes'
(Other scripts with SELECT commands work fine and are using the same DB connection details)
Searching around, I know I have to run a command like :
GRANT INSERT ON 'db'.'tablename' TO 'username'@'localhost'
However, I can't seem to see the grant command with the MySQL control panel ?
Any help greatly appreciated.
Message 1 of 4
(844 Views)
3 REPLIES 3
Re: MySql DB user no longers has permissions to insert
22-02-2014 3:36 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
The permissions I have for my databases are
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES
You can find yours by opening MySQL Manager, clicking a database, entering its password then press Login.
If yours lack INSERT I think it would have to be added by Plusnet/Hostopia. I suggest raising a ticket to get that done.
David
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES
You can find yours by opening MySQL Manager, clicking a database, entering its password then press Login.
If yours lack INSERT I think it would have to be added by Plusnet/Hostopia. I suggest raising a ticket to get that done.
David
David
Message 2 of 4
(308 Views)
Re: MySql DB user no longers has permissions to insert
22-02-2014 4:05 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Thanks for your reply... which helped me to confirm I did indeed have insert permissions.. but script was still getting the error.
But as I now knew I had INSERT permissions , I had another look at my php code...
The insert statement had the pre migration DB name prefixed..
INSERT INTO `bridgesystems_pn`.`jokes`
The DB names have changed after migration (its now bridgesystems_pn_ccgi_bridgesystems_plus_com) , as soon as I updated the DB name it worked fine.
Thanks for your help which helped me solve the problem within 15min ( much less than the days the support ticket route would have taken !)
Thanks again..
;
But as I now knew I had INSERT permissions , I had another look at my php code...
The insert statement had the pre migration DB name prefixed..
INSERT INTO `bridgesystems_pn`.`jokes`
The DB names have changed after migration (its now bridgesystems_pn_ccgi_bridgesystems_plus_com) , as soon as I updated the DB name it worked fine.
Thanks for your help which helped me solve the problem within 15min ( much less than the days the support ticket route would have taken !)
Thanks again..


Message 3 of 4
(308 Views)
Re: MySql DB user no longers has permissions to insert
22-02-2014 4:47 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Thanks for the feedback. The Hostopia file scanner has obviously missed this instance.
David
David
David
Message 4 of 4
(308 Views)
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- MySql DB user no longers has permissions to insert