I had the exact same problem. when you install mysql there is a database that stores all the user permissions and that table is created for you.
the mysql server can start without that permissions file but you have to send a -Sg option to the server if you are on unix, linux or the like This option allows the server to start without checking for the grant tables. This is bad form if you want a production database. I was never able to fix my installation when I had this problem. I had to uninstall and reinstall and then specify the custom data path to the .configure file from a source install. Good Luck Rance Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -----Original Message----- From: Bob Lockie [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 3:50 PM To: mysql mailing list Subject: running the server problem ./safe_mysqld --user=mysqld --datadir=/db/ ./safe_mysqld --user=mysqld --datadir=/db/ 020401 16:55:04 mysqld started 020401 16:55:04 /d2/usr2/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020401 16:55:04 mysqld ended My unix user is called mysqld and I want databases to go in /db/. Does anybody know what it is trying to do? I put in a non-standard location (/d2/usr2/local/) and I used a non-standard user (mysqld). I have no scripts nor var directories as the documentation says I should. "scripts/mysql_install_db". I have version 3.23.49 of the source. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
