mysql 无法正常安装

飞眉

环境：
solaris 10
mysql-5.1.11-beta-solaris10-sparc-64bit.pkg.gz

启动提示信息：
bash-3.00$ Starting mysqld daemon with databases from /opt/mysql/mysql/data
STOPPING server from pid file /opt/mysql/mysql/data/dgswwg.pid
060615 13:55:08 mysqld ended

日志信息：
060615 13:36:57 mysqld started
060615 13:36:57 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060615 13:36:57 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 39542.
InnoDB: Doing recovery: scanned up to log sequence number 0 39542
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
060615 13:36:57 InnoDB: Started; log sequence number 0 39542
/opt/mysql/mysql/bin/mysqld: Table 'mysql.general_log' doesn't exist
060615 13:36:57 [ERROR] Fatal error: Can't open and lock privilege tables: Table
'mysql.host' doesn't exist
060615 13:36:58 mysqld ended

rardge

mysql_install_db 这个执行过么？
安装包里面有没有 INSTALL 文件，看看它的说明。

飞眉

我是先运行了 configure 文件

提示：
./configure
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables
Fill help 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 !
To do so, start the server, then issue the following commands:
/opt/mysql/mysql/bin/mysqladmin -u root password 'new-password'
/opt/mysql/mysql/bin/mysqladmin -u root -h dgswwg password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /opt/mysql/mysql/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 . ; /opt/mysql/mysql/bin/mysqld_safe &

Please report any problems with the ./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 http://shop.mysql.com
Starting the mysqld server.  You can test that it is up and running
with the command:
./bin/mysqladmin version
$ Starting mysqld daemon with databases from /opt/mysql/mysql/data

$ STOPPING server from pid file /opt/mysql/mysql/data/dgswwg.pid
060615 15:56:22  mysqld ended

飞眉

$ ./mysql_install_db
Installing all prepared tables
Fill help 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 !
To do so, start the server, then issue the following commands:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h dgswwg password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; /usr/local/mysql/bin/mysqld_safe &

Please report any problems with the ./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 http://shop.mysql.co

rardge

原帖由 飞眉 于 2006-6-15 17:03 发表
我是先运行了 configure 文件

提示：
./configure
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

注意 NOTE 后面那段话，它告诉你它是二进制包，直接可使用，不需要用 ./configure 方式去编译安装。
如何使用，请看它另外一个文件，可能叫 INSTALL，里面有完整的安装步骤，你照做即可。

飞眉

Installed mysql on Solaris machine. Created a symbolic link /usr/local/mysql pointing to the installation directory.

Tried to start mysqld_safe and received and a error message on startup "Fatal error: Can't open and lock privilege

tables: Table 'mysql.host' doesn't exist".


Solution:


Created an /etc/my.cnf with the following:


[mysqld]

basedir = /usr/local/mysql

datadir = /usr/local/mysql/data


This cured the startup problem

飞眉

刚才在MYSQL网站上找到解决办法测试一下通过了