MySQL 4.0.22
以下のサイトよりファイルをダウンロード
http://www.mysql.com/
- インストール
# cd /usr/local/arch # wget http://dev.mysql.com/get/...4.0.22.tar.gz/from/.../mysql/ # cd ../src # tar xvzf ../arch/mysql-4.0.22.tar.gz # cd mysql-4.0.22 # ./configure --with-charset=ujis \ > --with-extra-charsets=all \ > --with-mysqld-user=mysql \ > --prefix=/usr/local/mysql # make # make install
- 設定
# groupadd mysql # useradd -g mysql -d /export/home/mysql -m -s /usr/local/bin/bash mysql # cd /usr/local/mysql # mkdir var # chown -R root:mysql . # chown -R mysql var # vi /etc/my.cnf
[mysqld] default-character-set = ujis [mysql] default-character-set = ujis [mysqldump] default-character-set = ujis
# bin/mysql_install_db --user=mysql
# bin/mysqld_safe --user=mysql &
# bin/mysqlshow
# bin/mysql -u root
mysql> use mysql
mysql> set password for root@localhost=password('YOURPASSWORD');
mysql> delete from user where password='';
mysql> drop database test;
mysql> create database NEWDB;
mysql> grant all on NEWDB.* to admin@localhost identified by 'password';
mysql> exit
# bin/mysqladmin -u root shutdown
# share/mysql/mysql.server start
# mysqldump -A -u root -p > mysql.dmp
# mysqldump -u root -p NEWDB > newdb.dmp
# mysql -u root -p < newdb.dmp
# share/mysql/mysql.server stop- linux/mysql (1267d) [ mysql 4.1.8 ]
Counter: 468,
today: 1,
yesterday: 2
最終更新: 2008-11-26 (水) 00:56:17 (JST) (1273d) by aqua
