Difference between revisions of "MySQL permission problem. Contact Kolmisoft to solve it."
From Kolmisoft Wiki
Jump to navigationJump to search
Line 15: | Line 15: | ||
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 for MySQL: | ||
FLUSH PRIVILEGES; | FLUSH PRIVILEGES; | ||
Restart Apache web server | Restart Apache web server: | ||
/etc/init.d/httpd restart | /etc/init.d/httpd restart |
Latest revision as of 12:15, 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