フリーソフト/MySQL 4.1 のインストール

IMP で使う MySQL 4.1 のインストール

インストール環境†

• Solaris 8 10/01

MySQL 4.1.18†

バイナリインストール†

mysql-max-4.1.18-sun-solaris2.8-sparc.tar.gz を展開する．

# cd /usr/local
# gzcat mysql-max-4.1.18-sun-solaris2.8-sparc.tar.gz | gtar xvf -
# ln -s  mysql-max-4.1.18-sun-solaris2.8-sparc mysql
# /usr/sbin/groupadd -g 2001 mysql
# /usr/sbin/useradd -d /opt/mysql -u 2003 -g mysql -s /bin/false mysql
# cd mysql

データベース作成(create grant table 仮テーブル? 作成)†

# scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
031127 11:02:09  ./bin/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:
./bin/mysqladmin -u root  password 'new-password'
./bin/mysqladmin -u root -h blade150  password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; ./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 ./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

バイナリの所有権変更†

# cd ..
# chown -R root /usr/local/mysql/.
# chown -R mysql /usr/local/mysql/data
# chgrp -R mysql /usr/local/mysql/.   

その他†

# cp bin/my_print_defaults /usr/bin
# vi /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
#port=3306
#socket=/var/run/mysql.sock
skip-innodb

起動スクリプト†

# cp support-files/mysql.server /etc/init.d
# ln -s /etc/init.d/mysql.server /etc/rc3.d/S99mysql
# ln -s /etc/init.d/mysql.server /etc/rc0.d/K01mysql

MySQL 管理者のパスワードつけ(MySQL 起動後, 固定系)†

./bin/mysqladmin -u root  password 'new-password'

DBI/DBD-mysql†

% cd DBI-1.50
% /usr/local/bin/perl Makefile.PL
% make
% make test
# make install

% PATH=${PATH}:/usr/local/mysql/bin
% cd DBD-mysql-3.0001
#   % /usr/local/bin/perl Makefile.PL --ssl   <- make test で失敗する
% /usr/local/bin/perl Makefile.PL
% make
# make install

検索

メニュー

• 覚え書き
• Linux
• Sun
• Windows
• Mac
• SGI
• フリーソフト

最新の20件