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