Database user permissions?

[larry_rma82]

In the Wiki for Installation, it states that "The database username must have permission to CREATE, DROP and ALTER tables." I've granted those privileges to my db user using "GRANT CREATE, DROP, ALTER ON db_name.* ..."

I am getting an error during installation - I edited mysql.php to echo the mysql error:

[INSERT INTO ola_config SET updated=NOW()] - INSERT command denied to user 'dbuser'@'localhost' for table 'ola_config'

Am I supposed to grant INSERT and any other privileges to my db user?

[Corey]

In the Wiki for Installation, it states that "The database username must have permission to CREATE, DROP and ALTER tables." I've granted those privileges to my db user using "GRANT CREATE, DROP, ALTER ON db_name.* ..."

I am getting an error during installation - I edited mysql.php to echo the mysql error:

[INSERT INTO ola_config SET updated=NOW()] - INSERT command denied to user 'dbuser'@'localhost' for table 'ola_config'

Am I supposed to grant INSERT and any other privileges to my db user?

Usually I just select them all by pressing "ALL". You will need the INSERT command though.

[larry_rma82]

I've now granted the user CREATE, DROP, ALTER, INSERT, SELECT on all tables (dbname.*) from all hosts (%), and I have the exact same error.

[Ebonhand]

What about "UPDATE"?

Perhaps you can set it to "ALL", test functionality, and then systematically remove attributes until it borks? You'll be left with a definitive list of what attributes are required, and can update the wiki appropriately

Kind regards,
Ebonhand

[jprost]

I've found that in general adding all, then removing the Grant permission is more than sufficient for any web application. Grant permission is strongly suggested as a security risk and therefore should not be utilized unless absolutely necessary.

jason...

[larry_rma82]

I finally got past the initial installation.
Some settings that might have played a part in my problems:
HelpDesk URL:
Changed http://localhost:8888/pathtoapp/ to http://127.0.0.1:8888/pathtoapp/
MySQL Hostname:
localhost

Problem fix - Beside GRANT ALL to dbname.* TO 'dbuser'@'%' ,
I also did GRANT ALL to dbname.* TO 'dbuser'@'localhost' and
GRANT ALL to dbname.* TO 'dbuser'@'127.0.0.1' . Only after setting privileges with hosts 'localhost' and '127.0.0.1' was I able to do the first part of the installation without an error.

BUT - since v1.6 RC3 is now available - I'll do it all over again with RC3!

Big fun :)

PS - in my installation of MySQL, GRANT ALL does not include the GRANT privilege, so I don't have to revoke it.

[4ice]

Great that you have solved it, hopefully RC3 will be installed without any problems :)