Re: Can't start mysql on FC3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux