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'; +------------------------------------------------------------------------------…')
 
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';

Revision as of 11:59, 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';