[MYSQL] Probleme permissions
Le
Thierry
Bonjour,
J'ai un soucis avec mysql/freebsd 6.2 :
-bash-2.05b$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.51-log FreeBSD port: mysql-server-5.0.51
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--+
| Database |
+--+
| information_schema |
| avions |
| copper |
| egroupdb |
| mysql |
| test |
+--+
6 rows in set (0.10 sec)
mysql> use egroudb;
ERROR 1049 (42000): Unknown database 'egroudb'
mysql> use egroupdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
ERROR 1018 (HY000): Can't read dir of './egroupdb/' (errno: 24)
J'ai verifie les permissions, elles me sembles bonnes:
bash-2.05b# cd /var/db/
drwx 7 mysql mysql 9216 Jan 3 19:49 mysql
bash-2.05b# cd mysql
drwx 2 mysql mysql 11264 Jan 2 20:20 egroupdb
Les tables sont toutes: -rw-rw- 1 mysql mysql
Merci pour votre aide.
J'ai un soucis avec mysql/freebsd 6.2 :
-bash-2.05b$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.51-log FreeBSD port: mysql-server-5.0.51
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--+
| Database |
+--+
| information_schema |
| avions |
| copper |
| egroupdb |
| mysql |
| test |
+--+
6 rows in set (0.10 sec)
mysql> use egroudb;
ERROR 1049 (42000): Unknown database 'egroudb'
mysql> use egroupdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
ERROR 1018 (HY000): Can't read dir of './egroupdb/' (errno: 24)
J'ai verifie les permissions, elles me sembles bonnes:
bash-2.05b# cd /var/db/
drwx 7 mysql mysql 9216 Jan 3 19:49 mysql
bash-2.05b# cd mysql
drwx 2 mysql mysql 11264 Jan 2 20:20 egroupdb
Les tables sont toutes: -rw-rw- 1 mysql mysql
Merci pour votre aide.

Poser une question


Je viens aussi de trouver ces logs:
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_mimetypes.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_mimetypes.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_prefixes.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_prefixes.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_quota.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_quota.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_shares.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_shares.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_versioning.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_versioning.frm' (errno: 24)
Et pourtant: -rw-rw---- 1 mysql mysql 8788 Jan 2 20:20
phpgw_vfs2_mimetypes.frm ... meme chose pour les autres ....