Problems being granted all MySQL permissions required for CiviCRM 4.5 upgrade

[brianedmundblood]

I currently use Civicrm 4.4.5; Drupal 7.23; PHP 5.3.28 (but this could be switched to 5.4.24) and mySQL 5.5.37 with InnoDB support

I emailed my provider, ICDSoft, as follows:

"I want to upgrade my CiviCRM to version 4.5 which has just been launched.

The requirements are:
CiviCRM 2.2.x+ : You must be running CiviCRM 2.2.x or higher to use this upgrade. Running a version prior to 2.2? First upgrade to 2.2 using these instructions
Drupal 7.x : CiviCRM 4.5 has been built to run under Drupal 7. It may run on Drupal 6, however it is not compatible with Drupal 5 sites.
PHP 5.3.3+ : CiviCRM will NOT run on PHP4 servers. (more info...).
MySQL 5.0.x or higher with InnoDB support : CiviCRM is compatible the current generally available MySQL release. Note that MySQL 5.1 is recommended for new installations and for sites during upgrades as CiviCRM is beginning to use Triggers more (eg to support multi-lingual installations), which require SUPER privileges in MySQL 5.0.
Permissions needed for CiviCRM 4.5 upgrade on MySQL 5.1: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, TRIGGER, CREATE ROUTINE, ALTER ROUTINE. (CREATE VIEW, TRIGGER, CREATE ROUTINE, ALTER ROUTINE are new requirements for update to CiviCRM 4.5, the others were needed before on 4.2.x.)
PCRE with Unicode properties support (more info).

I have checked my MySQL permissions and note that I do not have either CREATE ROUTINE or ALTER ROUTINE currently available.

Can you advise how I can switch these permissions on.

Many thanks."

They replied:

"Hello,

Most of the requirements are met, but SUPER privileges, CREATE ROUTINE, ALTER ROUTINE cannot be made available for security reasons. Our recommendation is to contact the CiviCRM developers and ask how crucial would their lack be. Let us know how they respond.
Thank you.

Best regards,
Support"

Would anyone on the forum have an answer about this?

Do you think I will have to move to another host in order to carry out this upgrade?

Any thoughts gratefully received.

[Dan C]

I don't know about the Create Routine or Alter Routine, but the Triggers are a crucial part of Civi.  I have had a lot of trouble with installs that were forced onto databases without SUPER user rights.  Unfortunately many shared server environments the hosts don't want to grant those privileges because of security concerns (I can't exactly disagree).  So I would not suggest trying to do the upgrade with out SUPER user privileges and that may require moving to a host that is more willing to grant those rights.  You could also talk to your host about upgrading your package if you want, sometimes if you move to a VPS (or similar) they will let you have those access rights.

[brianedmundblood]

Sadly the same host informed me that they don't grant those rights even on their upgraded VPS service so it looks like a new host 

Thanks for your comments through.

Brian