mySQL4.0.18のインストール

■Compile & Install
　3.23.58がいるのでprefixをつけてconfigure

#./configure --prefix=/usr/local/mysql4.0.18 --with-charset=ujis -with-extra-charsets=all \
--with-mysqld-user=hoge
#make
#make install

■Databaseのsetup

#/usr/local/mysql/bin/mysql_install_db --user=hoge
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/mysql4.1.15/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql4.1.15/bin/mysqladmin -u root -h 184.1.168.192.in-addr.arpa password 'new-password'
See the manual for more instructions.

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

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/local/mysql4.1.15/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

■Databaseの起動

# /usr/local/mysql/bin/mysqld_safe --user=hoge &

■起動スクリプト
tarballの中についています。install後であればshare/mysqlにあります。

#sed 's/\/usr\/local\/mysql4.1.15/\/usr\/local\/mysql/' /usr/local/mysql/share/mysql/mysql.server > mysql

■sql_bench, mysql_test
付随のこれらを動かしてみようとするがPerlのエラーがでたので一時中断。
DBIがinstallされてないみたい。
ちなみにmysql_test/mysql_test、sql_bench/run_all_test

>CPAN経由でinstallはOK。でもともにうまくいかず？？