CiviCRM Community Forums (archive)

I've found that the CiviCRM MySQL user now needs CREATE VIEW as well as SUPER privileges to enable a multi-language CiviCRM.
SHOW VIEW is also needed to enable backing up the db

mysql -uroot -p

mysql> USE db_name;

mysql> GRANT SUPER ON *.* TO 'db_user'@'localhost' IDENTIFIED BY 'password';

mysql> GRANT CREATE VIEW ON *.* TO 'db_user'@'localhost' IDENTIFIED BY 'password';

mysql> GRANT SHOW VIEW ON *.* TO 'db_user'@'localhost' IDENTIFIED BY 'password';

mysql> FLUSH PRIVILEGES;

mysql> EXIT;

I've added SHOW VIEW in the above as it is required to enable backing up the database by the MySQL user.
Found this out the easy way on a test site 

so

mysql> USE db_name;

mysql> GRANT SUPER, CREATE VIEW, SHOW VIEW ON *.* TO 'db_user'@'localhost' IDENTIFIED BY 'password';

mysql> FLUSH PRIVILEGES;

mysql> EXIT;

added to wiki http://wiki.civicrm.org/confluence/display/CRMDOC32/Localization