Bob Hall wrote on Wednesday 20 April 2005 13:49 in the group list.freebsd.questions:
> This is a very MySQL specific question. You should post it to the MySQL > mailing list. > > It's been a while since I used MySQL. The host table is in the MySQL > database. There should be a directory called data, or something similar, > and inside that there is a directory called mysql, and inside that there > is a file called host, which contains the host table. Or at least, > that's what I remember. Either that file is missing, or the system > permissions on it have changed, or MySQL has changed access privileges > on it. Or something. Check to make sure that it is there, and has the > correct system permissions (ls -l). If it's not there, you may have to > back up all your tables and reinstall. Or you may be able to reinstall > just the host table. Further questions should go to a MySQL mailing > list. > > Bob Hall The only host file I can find is in "/var/db/mysql/mysq" -rw-rw---- 1 mysql mysql 0 Nov 19 09:12 columns_priv.MYD -rw-rw---- 1 mysql mysql 1024 Nov 19 09:12 columns_priv.MYI -rw-rw---- 1 mysql mysql 8778 Nov 19 09:12 columns_priv.frm -rw-rw---- 1 mysql mysql 765 Dec 5 07:55 db.MYD -rw-rw---- 1 mysql mysql 3072 Dec 6 09:32 db.MYI -rw-rw---- 1 mysql mysql 9088 Nov 19 09:12 db.frm -rw-rw---- 1 mysql mysql 0 Nov 19 09:12 func.MYD -rw-rw---- 1 mysql mysql 1024 Nov 19 09:12 func.MYI -rw-rw---- 1 mysql mysql 8641 Nov 19 09:12 func.frm -rw-rw---- 1 mysql mysql 0 Nov 19 09:12 host.MYD -rw-rw---- 1 mysql mysql 1024 Nov 19 09:12 host.MYI -rw-rw---- 1 mysql mysql 9064 Nov 19 09:12 host.frm -rw-rw---- 1 mysql mysql 0 Nov 19 09:12 tables_priv.MYD -rw-rw---- 1 mysql mysql 1024 Nov 19 09:12 tables_priv.MYI -rw-rw---- 1 mysql mysql 8877 Nov 19 09:12 tables_priv.frm -rw-rw---- 1 mysql mysql 404 Dec 5 07:55 user.MYD -rw-rw---- 1 mysql mysql 2048 Dec 6 09:32 user.MYI -rw-rw---- 1 mysql mysql 9806 Nov 19 09:12 user.frm -- Key-ID = A6581435 E-mail address is valid _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
