Difference between revisions of "MySQL permission problem. Contact Kolmisoft to solve it."
From Kolmisoft Wiki
Jump to navigationJump to search
Line 14: | Line 14: | ||
GRANT FILE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'mor'@'localhost' IDENTIFIED BY 'mor'; | GRANT FILE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'mor'@'localhost' IDENTIFIED BY 'mor'; | ||
Flush privileges for MySQL | |||
FLUSH PRIVILEGES; | |||
Restart Apache web server | |||
/etc/init.d/httpd restart |
Revision as of 12:14, 17 October 2012
Please check if MySQL user "mor" has FILE permission:
mysql> SHOW GRANTS FOR 'mor'@'localhost'; +-------------------------------------------------------------------------------------------------------------------------+ | Grants for mor@localhost | +-------------------------------------------------------------------------------------------------------------------------+ | GRANT FILE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'mor'@'localhost' IDENTIFIED BY PASSWORD '7a63255026bdb834' | | GRANT ALL PRIVILEGES ON `mor`.* TO 'mor'@'localhost' WITH GRANT OPTION | | GRANT ALL PRIVILEGES ON `mor_test`.* TO 'mor'@'localhost' WITH GRANT OPTION | +-------------------------------------------------------------------------------------------------------------------------+ 3 rows in set (0.00 sec)
If it is missing use this command as MySQL root:
GRANT FILE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'mor'@'localhost' IDENTIFIED BY 'mor';
Flush privileges for MySQL
FLUSH PRIVILEGES;
Restart Apache web server
/etc/init.d/httpd restart