Folks: I think you are on the right track with that Gerald..
I deleted all the files in my data directory (they were just the ones that mysql_install_db creates) and then ran mysql_install_db --user=mysql This time, nothing was created, no files, or anything, cant even find an error message that would say why. So since I know that the server is running under safe_mysqld --user=mysql it couldnt find the files cause under that account name apparently they dont exist. The mysql user is part of what group, so I can chown the dir, and start again? Gerald Clark wrote >Does mysql own the mysql database directory, and all its files? > >You should have run it as >mysql_install_db --user=mysql > >Rance Hall wrote: > >> >>Hello all >> >>I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at >>that computer now, so that could be wrong slighly) install pkg >> >>I have installed it, and I can get it to run with the >>--skip-grant-tables option. >> >>When I try to run safe_mysqld without the skip option I get the >>following error: Table 'mysql.host' doesn't exist >> >>Now, I ran the mysql_install_db script and it made a bunch of >>databases including two called host.xxx >> >>Question, what is the proper syntax for a creation of the mysql.host >>table so that I can create it and get past this error. >> >>If anyone else has any experience with this, could this be a bug in >>the install_db script? >> >>Thanks for all your help >> >>Rance _________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com --------------------------------------------------------------------- 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
