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