LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Help! MySql error (https://www.linuxquestions.org/questions/linux-software-2/help-mysql-error-40267/)

cmfarley19 01-04-2003 05:53 AM

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?

niknah 01-04-2003 06:24 AM

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.

cmfarley19 01-04-2003 06:56 AM

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.