[Solved] NO GRANT ALL PRIVILEGES

Help with getting the CMS CORE package up and running. This does not include 3rd party modules, PHP scripts, anything downloaded via module manager or from any external source.
Locked
kmarios
New Member
New Member
Posts: 3
Joined: Thu Feb 28, 2013 4:30 pm

[Solved] NO GRANT ALL PRIVILEGES

Post by kmarios »

hello, i migrated my CMS (Version 1.11.2.1) to a new host where i don't get GRANT ALL PRIVILEGES .

My current privileges are

SHOW GRANTS FOR CURRENT_USER;

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON `dbname`.* TO 'dbuser'@''

My problem is that i cannot insert/update content ?

any ideas without issuing a GRANT ALL statement, which i am not allowed to ?

Thank you
Last edited by kmarios on Thu Mar 07, 2013 4:20 pm, edited 1 time in total.
calguy1000
Support Guru
Support Guru
Posts: 8169
Joined: Tue Oct 19, 2004 6:44 pm

Re: NO GRANT ALL PRIVILEGES

Post by calguy1000 »

Not being able to insert/update content is probably a symptom of a problem with the migration. Not a problem with mysql privileges.

I would suggest enabling debug mode in the config.php and then checking for mysql errors when adding/editing content pages.
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
kmarios
New Member
New Member
Posts: 3
Joined: Thu Feb 28, 2013 4:30 pm

Re: NO GRANT ALL PRIVILEGES

Post by kmarios »

i have enabled debug but i am not able to see any errors. the page that i get says
================
Forbidden
You don't have permission to access /admin/editcontent.php on this server.
================

Using other modules eg Blog i am able to insert/update content.
calguy1000
Support Guru
Support Guru
Posts: 8169
Joined: Tue Oct 19, 2004 6:44 pm

Re: NO GRANT ALL PRIVILEGES

Post by calguy1000 »

a 403 error indicates a problem with mod_security.

Contact your host. We don't support mod_security. Ask them to disable it for your domains.
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
kmarios
New Member
New Member
Posts: 3
Joined: Thu Feb 28, 2013 4:30 pm

Re: NO GRANT ALL PRIVILEGES

Post by kmarios »

yes you are correct :)
Locked

Return to “[locked] Installation, Setup and Upgrade”