• 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;





トップ   編集 凍結 差分 バックアップ 添付 複製 名前変更 リロード   新規 一覧 単語検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: Tue, 12 Oct 2021 01:01:31 JST (421d)