Squarebox

MySQL Permissions Fix

Question

I am unable to start CatDV Server on OSX Yosemite after a new install or reboot due to MySQL connection errors.

I am unable to perform a backup/restore due to the following message “Warning: Using a password on the command line interface can be insecure.”

Answer

The problems listed above are the result of an issue with the database permissions that CatDV sets up in MySQL when it is first installed. The solution is to run the following MySQL commands from the MySQL command prompt:

 GRANT SELECT,INSERT,UPDATE,DELETE ON catdv.* TO catdv@localhost IDENTIFIED BY ‘catdv’;

GRANT CREATE TEMPORARY TABLES ON catdv.* TO catdv@localhost IDENTIFIED BY ‘catdv’;

GRANT RELOAD,SHUTDOWN ON *.* TO catdv@localhost IDENTIFIED BY ‘catdv’;

GRANT ALL PRIVILEGES ON catdv.* TO catdvadmin@localhost IDENTIFIED BY ‘catdv’;

FLUSH PRIVILEGES;

 An SQL script containing the above commands can be downloaded from the following FTP link:-

ftp://support.squarebox.co.uk/pub/download/fix_mysql_permissions.sql

This can be applied by running the following command:

/usr/local/mysql/bin/mysql -u root –p < fix_mysql_permissions.sql

You will be prompted for the MySQL ‘root’ password, which by default is blank.

Last updated – August 2015