Difference between revisions of "MySQL permission problem. Contact Kolmisoft to solve it."

From Kolmisoft Wiki
Jump to navigationJump to search
 
(One intermediate revision by the same user not shown)
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

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