Help! MySql error
When I attempt to manage a particular database with phpmyadmin I receive the following error:
Database pilam running on localhost Warning: MySQL: Unable to save result set in /usr/share/phpmyadmin/libraries/mysql_wrappers.lib.php on line 91 Error SQL-query : SHOW TABLE STATUS FROM `pilam` MySQL said: Can't read dir of './pilam/' (Errcode: 13) Back ---------------------------------------------------------- When I do it via command line i get: wombat:/home/cfarley# mysql -u cfarley -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 to server version: 3.23.52-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use pilam Can't read dir of './pilam/' (Errcode: 13) Database changed mysql> ______________________________________ Any thoughts? |
Error 13 is permission denied, check that the user mysql is running under has permission to write to the pilam directory, which could be in /usr/local/var/mysql or something like that.
|
Excellent! That did it.
No sure how the permissions got changed though. Slightly disturbing. Thanks. |
All times are GMT -5. The time now is 09:27 PM. |