i'm testing mysql on openbsd 4.0 and have the the following problem:
# mysqladmin -u root drop phpmyadmin
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.
Do you really want to drop the 'phpmyadmin' database [y/N] y
mysqladmin: DROP DATABASE phpmyadmin failed;
error: 'Can't find file: './mysql/proc.frm' (errno: 9)'
# sudo -u _mysql mysqladmin drop phpmyadmin
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.
Do you really want to drop the 'phpmyadmin' database [y/N] y
mysqladmin: DROP DATABASE phpmyadmin failed;
error: 'Can't find file: './mysql/proc.frm' (errno: 9)'
# ll mysql/proc*
-rw-rw---- 1 _mysql _mysql 0 Aug 8 22:53 mysql/proc.MYD
-rw-rw---- 1 _mysql _mysql 1024 Aug 8 22:53 mysql/proc.MYI
-rw-rw---- 1 _mysql _mysql 9691 Aug 8 22:53 mysql/proc.frm
-rw-rw---- 1 _mysql _mysql 0 Aug 8 22:53 mysql/procs_priv.MYD
-rw-rw---- 1 _mysql _mysql 1024 Aug 8 22:53 mysql/procs_priv.MYI
-rw-rw---- 1 _mysql _mysql 8875 Aug 8 22:53 mysql/procs_priv.frm
# mysql_secure_installation
[...]
Remove test database and access to it? [Y/n]
- Dropping test database...
ERROR 1017 (HY000) at line 1: Can't find file: './mysql/proc.frm' (errno: 9)
... Failed! Not critical, keep moving...
- Removing privileges on test database...
[...]
has anyone the same problem ? solution ?
thanks
Regards
Julien
# pkg_info |grep mysql
mysql-client-5.0.22 multithreaded SQL database (client)
mysql-server-5.0.22 multithreaded SQL database (server)
p5-DBD-mysql-3.0003 MySQL drivers for the Perl DBI
php5-mysql-5.1.4 mysql database access extensions for php5
# dmesg
OpenBSD 4.0-beta (GENERIC) #1055: Thu Aug 3 11:39:24 MDT 2006
[EMAIL PROTECTED]:/usr/src/sys/arch/i386/compile/GENERIC
cpu0: Intel Pentium II ("GenuineIntel" 686-class, 512KB L2 cache) 351 MHz
[...]
