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 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 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

Added INSERT and SELECT - same error

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

Past the initial install

I finally got past the initial installation.

Some settings that might have played a part in my problems:

HelpDesk URL:

Changed http://localhost/pathtoapp(http://localhost/pathtoapp) to http://127.0.0.1/pathtoapp(http://127.0.0.1/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 :)