Difference between revisions of "MySQL permission problem. Contact Kolmisoft to solve it."
From Kolmisoft Wiki
Jump to navigationJump to search
(Created page with 'Please check if MySQL user "mor" has FILE permission: mysql> SHOW GRANTS FOR 'mor'@'localhost'; +------------------------------------------------------------------------------…') |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 11: | Line 11: | ||
3 rows in set (0.00 sec) | 3 rows in set (0.00 sec) | ||
If it is missing use this command: | If it is missing use this command as MySQL root: | ||
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 | |||
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
