Check database access levels "grant all"

[Guy]

I have 1.11.6 up and running without problems.

Under System Information:
Server Information:
Server API (server_api) cgi-fcgi
Server Database (server_db_type) mysql (mysqli)
Server Database Version (server_db_version) Success 5.0.96
Server Software (server_software) apache
Server Operating System (server_os) linux 2.6.32-279.19.1.el6.x86_64 on x86_64

I get this message under server information:

Check database access levels (server_db_grants) Caution could not find a suitable "grant all" permission. this may mean you could have problems installing or removing modules. or even adding and deleting items, including pages

Everything works fine. Is there a way to fix the "grant all" permission or should I not worry since all is working.

Thanks

GCG

[calguy1000]

Check database access levels (server_db_grants) Caution could not find a suitable "grant all" permission. this may mean you could have problems installing or removing modules. or even adding and deleting items, including pages

This test talks to mysql and attempts to find out whether credentials you have given CMSMS to access the database have grant all privileges. It is not always reliable, which is why it is just a warning.

CMSMS needs various permissions at different times
- SELECT, UPDATE, INSERT, DELETE of course.
- CREATE TABLE, DROP TABLE, ALTER TABLE
- mostly during the installation or upgrade process, but also when installing, upgrading or removing modules
- some modules may create and drop tables within their normal execution (NMS used to be that way)
- INDEX
- mostly during the installation or upgrade process, but also when installing or upgrading modules.

Now. There have been reports of people without full permissions having problems with the operation of their site, particularly when upgrading modules some time after initial installation).

Unfortunately most of the module installation routines, or even CMSMS install/upgrade routines don't catch and log all of the potential errors from mysql. (not like people would read them, or understand them anyways).

Therefore if you don't have full permissions, and if you don't catch any errors (and they may not be immediately visible) when installing or upgrading things, the symptoms of 'problems' can be severe and easy to spot, or quite vague (like poor performance, which is hard to judge).

So when you say that "Everything works fine" I am taking that with a grain of salt.

As far as 'how to fix it'. With an existing installation with multiple modules and lots of data it's quite complex.

[Rolf]

Dont worry, I have the same at my host and never had any problems.

Rolf

[Guy]

Thank you all. I had no problems updating modules after installation.

What is involved in fixing the problem?

Guy