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

From Kolmisoft Wiki
Jump to navigationJump to search
 
Line 15: Line 15:
  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 for MySQL:


  FLUSH PRIVILEGES;
  FLUSH PRIVILEGES;


Restart Apache web server
Restart Apache web server:


  /etc/init.d/httpd restart
  /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