†

†

• MySQL

†

• MySQL 4.1 Downloads

  • wget http://www.softagency.co.jp/MySQL/Downloads/MySQL-4.1/mysql-4.1.7.tar.gz

• MySQL 5.0 Downloads

  • wget http://www.softagency.co.jp/MySQL/Downloads/MySQL-5.0/mysql-5.0.2-alpha.tar.gz

†

tar zxvf mysql-5.0.2-alpha.tar.gz

†

groupadd mysql
useradd -g mysql mysql

†

cd mysql-5.0.2-alpha
CFLAGS="-O3 -mpentiumpro" CXX=gcc CXXFLAGS="-O3 -mpentiumpro \
 -felide-constructors -fno-exceptions -fno-rtti" ./configure \
 --prefix=/usr/local/mysql --enable-assembler \
 --with-mysqld-ldflags=-all-static \
 --with-extra-charsets=complex
make
su
make install

†

• scripts/mysql_install_db

• chown -R root  /usr/local/mysql
  chown -R mysql /usr/local/mysql/var
  chgrp -R mysql /usr/local/mysql

†

• Redhat Linux

  cp support-files/mysql.server /etc/init.d
  chkconfig --add mysql.server

• Solaris

†

• /usr/local/mysql/bin/mysqld_safe --user=mysql &

• /usr/local/mysql/bin/mysqladmin version

• /usr/local/mysql/bin/mysqladmin variables

• /usr/local/mysql/bin/mysqladmin -u root shut

• /usr/local/mysql/bin/mysqld_safe --log &

• /usr/local/mysql/bin/mysqlshow

• /usr/local/mysql/bin/mysqladmin -u root shut

†

†

/usr/local/mysql/bin/mysql -u root -p

†

• DB名:nuzoudb

  create database nuzoudb;

• show databases;

†

• grant select,insert,delete,update,create,drop,file,alter,index on *.* to nuzou identified by 'nuzoupw';

XOOPS †

create database nuzou;
grant select,insert,delete,update,create,drop,file,alter,index on *.* to nuzou identified by nuzou;