MySQL Permissions Fix
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.”
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 [email protected] IDENTIFIED BY ‘catdv’;
GRANT CREATE TEMPORARY TABLES ON catdv.* TO [email protected] IDENTIFIED BY ‘catdv’;
GRANT RELOAD,SHUTDOWN ON *.* TO [email protected] IDENTIFIED BY ‘catdv’;
GRANT ALL PRIVILEGES ON catdv.* TO [email protected] IDENTIFIED BY ‘catdv’;
An SQL script containing the above commands can be downloaded from the following FTP link:-
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