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
[Solved] NO GRANT ALL PRIVILEGES
[Solved] NO GRANT ALL PRIVILEGES
Last edited by kmarios on Thu Mar 07, 2013 4:20 pm, edited 1 time in total.
-
- Support Guru
- Posts: 8169
- Joined: Tue Oct 19, 2004 6:44 pm
Re: NO GRANT ALL PRIVILEGES
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.
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.
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.
Re: NO GRANT ALL PRIVILEGES
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.
================
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.
-
- Support Guru
- Posts: 8169
- Joined: Tue Oct 19, 2004 6:44 pm
Re: NO GRANT ALL PRIVILEGES
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.
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.
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.
Re: NO GRANT ALL PRIVILEGES
yes you are correct 
