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
