MySQL permission problem. Contact Kolmisoft to solve it.

From Kolmisoft Wiki
Revision as of 10:00, 22 November 2011 by Admin (talk | contribs) (Created page with 'Please check if MySQL user "mor" has FILE permission: mysql> SHOW GRANTS FOR 'mor'@'localhost'; +------------------------------------------------------------------------------…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

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:

GRANT FILE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'mor'@'localhost' IDENTIFIED BY 'mor';