Wes- This looks very close to the problem your having... http://forums.mysql.com/read.php?11,7164,7164 Dan On Wed, 02 Feb 2005 12:58:28 +1000, Wes Barris <wes.barris@xxxxxxxx> wrote: > Craig White wrote: > > > On Wed, 2005-02-02 at 12:29 +1000, Wes Barris wrote: > > > >>David Hoffman wrote: > >> > >> > >>>On Tue, 01 Feb 2005 21:12:27 -0500, David Cary Hart <Fedora@xxxxxxxxxxx> wrote: > >>> > >>> > >>>>On Wed, 2005-02-02 at 12:04 +1000, Wes Barris wrote: > >>>> > >>>>Did you install from the RPM? > >>>> > >>>>host.frm is created the first time you start the daemon and is located > >>>>in /var/lib/mysql/mysql. > >>> > >>> > >>>David, maybe you missed it, but when I read the original post, he did > >>>show his /var/lib/mysql/mysql directory, and I see the file there. > >> > >>Yes, the file is there. > >> > >> > >>>I'm guessing it might be how he tried to start it. > >>> > >>>Wes... how did you try to start mysql? And what version are you using? > >>>Did you try "service mysql-server start"? (Version 3.xx that came with FC3) > >>>Or if you are using MySQL version 4.xx, "try service mysql start" > >> > >>root@bioweb# rpm -qa | fgrep -i mysql > >>perl-DBD-MySQL-2.9003-5 > >>mysql-3.23.58-14 > >>mysql-server-3.23.58-14 > >> > >>I tried this: > >> > >>/etc/init.d/mysqld start > >> > >>When I try your command I get this: > >> > >>root@bioweb# service mysql-server start > >>mysql-server: unrecognized service > > > > ---- > > try... > > > > mysql_install_db > > service mysqld start > > Thanks but I get the same error. Here is a transcript: > > root@bioweb# mysql_install_db > Installing all prepared tables > > To start mysqld at boot time you have to copy support-files/mysql.server > to the right place for your system > > PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! > This is done with: > /usr/bin/mysqladmin -u root password 'new-password' > /usr/bin/mysqladmin -u root -h bioweb.sl.csiro.au password 'new-password' > See the manual for more instructions. > > NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run > the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be > able to use the new GRANT command! > > You can start the MySQL daemon with: > cd /usr ; /usr/bin/safe_mysqld & > > You can test the MySQL daemon with the benchmarks in the 'sql-bench' > directory: > cd sql-bench ; run-all-tests > > Please report any problems with the /usr/bin/mysqlbug script! > > The latest information about MySQL is available on the web at > http://www.mysql.com > Support MySQL by buying support/licenses at https://order.mysql.com > > root@bioweb# service mysqld start > Timeout error occurred trying to start MySQL Daemon. > Starting MySQL: [FAILED] > root@bioweb# > > This was appended to the /var/log/mysqld.log file: > > 050202 12:56:40 mysqld started > 050202 12:56:40 /usr/libexec/mysqld: Can't find file: > './mysql/host.frm' (errno: 13) > 050202 12:56:40 mysqld ended > > > > mysqladmin - u root password 'new-password' > > > > chkconfig mysqld on #for future reboots > > I also found it handy to add... > > skip-innodb to /etc/my.cnf > > Yes, I had already put that in my /etc/my.cnf > > > > > good luck > > > > Craig > > > > -- > Wes Barris > E-Mail: Wes.Barris@xxxxxxxx > > -- > fedora-list mailing list > fedora-list@xxxxxxxxxx > To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list >
