MYSQL出现问题了,高高高手快来帮帮忙呀

Question

我启动我的mysqld的时候出现:
[root@mail2 bin]# /usr/local/mysql/bin/safe_mysqld --user=mysql &
[2] 31591
[1]   Exit 127                /usr/local/mysql/safe_mysqld --user=mysql
[root@mail2 bin]# Starting mysqld daemon with databases from /usr/local/mysql/var
040826 17:10:02  mysqld ended

[2]+  Done                    /usr/local/mysql/bin/safe_mysqld --user=mysql
[root@mail2 bin]# cd /usr/local/mysql/var
[root@mail2 var]# ls
mail2-bin.001  mail2-bin.002  mail2-bin.003  mail2-bin.004  mail2-bin.index  mail2.gzknet.com.err
[root@mail2 var]# cat mail2.gzknet.com.err
040826 16:36:16  mysqld started
040826 16:36:16  /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist
040826 16:36:16  mysqld ended

040826 16:52:14  mysqld started
040826 16:52:14  /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist
040826 16:52:14  mysqld ended

040826 16:56:22  mysqld started
040826 16:56:22  /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist
040826 16:56:22  mysqld ended

040826 17:10:02  mysqld started
040826 17:10:02  /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist
040826 17:10:02  mysqld ended

[root@mail2 var]#

快帮帮忙...

Answer 1

up

Answer 2

你没有建表，
mysql_install_db

Answer 3

还是不能启动:
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables

040827 10:05:35  /usr/local/mysql/libexec/mysqld: Shutdown Complete

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/local/mysql/bin/mysqladmin -u root  password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h mail2.gzknet.com  password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr/local/mysql ; /usr/local/mysql/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/local/mysql/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@mail2 bin]# /usr/local/mysql/bin/safe_mysqld &
[1] 2780
[root@mail2 bin]# Starting mysqld daemon with databases from /usr/local/mysql/var
040827 10:12:20  mysqld ended

[1]+  Done                    /usr/local/mysql/bin/safe_mysqld
[root@mail2 bin]# cd /usr/local/mysql/var
[root@mail2 var]# ls
mail2-bin.001  mail2-bin.003  mail2-bin.005  mail2-bin.007  mail2-bin.009  mail2-bin.011  mail2-bin.index       mysql
mail2-bin.002  mail2-bin.004  mail2-bin.006  mail2-bin.008  mail2-bin.010  mail2-bin.012  mail2.gzknet.com.err  test
[root@mail2 var]# cat mail2.gzknet.com.err
040826 16:36:16  mysqld started
040826 16:36:16  /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist
040826 16:36:16  mysqld ended

040826 16:52:14  mysqld started
040826 16:52:14  /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist
040826 16:52:14  mysqld ended

040826 16:56:22  mysqld started
040826 16:56:22  /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist
040826 16:56:22  mysqld ended

040826 17:10:02  mysqld started
040826 17:10:02  /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist
040826 17:10:02  mysqld ended

040826 17:41:02  mysqld started
040826 17:41:02  /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist
040826 17:41:02  mysqld ended

040827 10:05:21  mysqld started
040827 10:05:22  /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist
040827 10:05:22  mysqld ended

040827 10:06:53  mysqld started
040827 10:06:53  /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
040827 10:06:53  mysqld ended

040827 10:08:04  mysqld started
040827 10:08:04  /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
040827 10:08:04  mysqld ended

040827 10:09:49  mysqld started
040827 10:09:49  /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
040827 10:09:49  mysqld ended

040827 10:12:20  mysqld started
040827 10:12:20  /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
040827 10:12:20  mysqld ended

[root@mail2 var]#

Answer 4

为什么呢>;?请高手帮帮忙哦

Answer 5

help!!

Answer 6

数据库没有初始化好

Answer 7

应该如何初始化数据库呢?

是不是因为有其他的mysql在运行呢
因为我的系统是AS Linux3.0,没有自带的mysql-server,所以我就安装了source的mysql上去
但是系统自带的mysql没有删除掉

会不会有影响呢?

Answer 8

mysql不能启动的原因有许多.

楼主先看看./path/mysql/var/mysql/*.err这个文件的提示.