Difference between revisions of "MySQL"
From CBLFS
Jump to navigationJump to search (→32Bit) |
|||
| Line 44: | Line 44: | ||
== Multilib == | == Multilib == | ||
| + | |||
| + | Create user and group: | ||
| + | |||
| + | groupadd -g 40 mysql && | ||
| + | useradd -c "MySQL Server" -d /dev/null -g mysql -s /bin/false -u 40 mysql | ||
=== 32Bit === | === 32Bit === | ||
| Line 49: | Line 54: | ||
Compile the package: | Compile the package: | ||
| − | |||
| − | |||
CC="gcc ${BUILD32}" CXX="g++ ${BUILD32}" \ | CC="gcc ${BUILD32}" CXX="g++ ${BUILD32}" \ | ||
LDFLAGS="-L/usr/lib" C_EXTRA_FLAGS=-fno-strict-aliasing \ | LDFLAGS="-L/usr/lib" C_EXTRA_FLAGS=-fno-strict-aliasing \ | ||
| Line 77: | Line 80: | ||
=== N32 === | === N32 === | ||
| − | + | Compile the package | |
| + | |||
| + | CC="gcc ${BUILDN32}" CXX="g++ ${BUILDN32}" \ | ||
| + | C_EXTRA_FLAGS=-fno-strict-aliasing \ | ||
| + | ./configure --prefix=/usr --libdir=/usr/lib32 \ | ||
| + | --sysconfdir=/etc \ | ||
| + | --libexecdir=/usr/sbin \ | ||
| + | --localstatedir=/srv/mysql \ | ||
| + | --enable-thread-safe-client \ | ||
| + | --enable-assembler \ | ||
| + | --enable-local-infile \ | ||
| + | --with-unix-socket-path=/var/run/mysql/mysql.sock \ | ||
| + | --without-debug \ | ||
| + | --without-bench \ | ||
| + | --without-readline \ | ||
| + | --with-berkeley-db \ | ||
| + | --with-extra-charsets=all | ||
| + | make testdir=/tmp/mysql | ||
| + | |||
| + | Install the package | ||
| + | |||
| + | make testdir=/tmp/mysql install && | ||
| + | rm -rf /tmp/mysql && | ||
| + | cd /usr/lib32 && | ||
| + | ln -v -sf mysql/libmysqlclient{,_r}.so* . | ||
=== 64Bit === | === 64Bit === | ||
| Line 83: | Line 110: | ||
Compile the package | Compile the package | ||
| − | |||
| − | |||
CC="gcc ${BUILD64}" CXX="g++ ${BUILD64}" \ | CC="gcc ${BUILD64}" CXX="g++ ${BUILD64}" \ | ||
C_EXTRA_FLAGS=-fno-strict-aliasing \ | C_EXTRA_FLAGS=-fno-strict-aliasing \ | ||
Revision as of 08:18, 5 September 2006
| Download Source: | http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.24a.tar.gz |
|---|
Contents
Dependencies
Optional
Non-Multilib
Compile the package:
groupadd -g 40 mysql && useradd -c "MySQL Server" -d /dev/null -g mysql -s /bin/false -u 40 mysql && C_EXTRA_FLAGS=-fno-strict-aliasing \ ./configure --prefix=/usr \ --sysconfdir=/etc \ --libexecdir=/usr/sbin \ --localstatedir=/srv/mysql \ --enable-thread-safe-client \ --enable-assembler \ --enable-local-infile \ --with-unix-socket-path=/var/run/mysql/mysql.sock \ --without-debug \ --without-bench \ --without-readline \ --with-berkeley-db \ --with-extra-charsets=all && make testdir=/tmp/mysql
Install the package
make testdir=/tmp/mysql install &&
rm -rf /tmp/mysql &&
cd /usr/lib &&
ln -v -sf mysql/libmysqlclient{,_r}.so* .
Multilib
Create user and group:
groupadd -g 40 mysql && useradd -c "MySQL Server" -d /dev/null -g mysql -s /bin/false -u 40 mysql
32Bit
Compile the package:
CC="gcc ${BUILD32}" CXX="g++ ${BUILD32}" \
LDFLAGS="-L/usr/lib" C_EXTRA_FLAGS=-fno-strict-aliasing \
./configure --prefix=/usr \
--sysconfdir=/etc \
--libexecdir=/usr/sbin \
--localstatedir=/srv/mysql \
--enable-thread-safe-client \
--enable-assembler \
--enable-local-infile \
--with-unix-socket-path=/var/run/mysql/mysql.sock \
--without-debug \
--without-bench \
--without-readline \
--with-berkeley-db \
--with-extra-charsets=all
make testdir=/tmp/mysql
Install the package
make testdir=/tmp/mysql install &&
rm -rf /tmp/mysql &&
cd /usr/lib &&
ln -v -sf mysql/libmysqlclient{,_r}.so* .
N32
Compile the package
CC="gcc ${BUILDN32}" CXX="g++ ${BUILDN32}" \
C_EXTRA_FLAGS=-fno-strict-aliasing \
./configure --prefix=/usr --libdir=/usr/lib32 \
--sysconfdir=/etc \
--libexecdir=/usr/sbin \
--localstatedir=/srv/mysql \
--enable-thread-safe-client \
--enable-assembler \
--enable-local-infile \
--with-unix-socket-path=/var/run/mysql/mysql.sock \
--without-debug \
--without-bench \
--without-readline \
--with-berkeley-db \
--with-extra-charsets=all
make testdir=/tmp/mysql
Install the package
make testdir=/tmp/mysql install &&
rm -rf /tmp/mysql &&
cd /usr/lib32 &&
ln -v -sf mysql/libmysqlclient{,_r}.so* .
64Bit
Compile the package
CC="gcc ${BUILD64}" CXX="g++ ${BUILD64}" \
C_EXTRA_FLAGS=-fno-strict-aliasing \
./configure --prefix=/usr --libdir=/usr/lib64 \
--sysconfdir=/etc \
--libexecdir=/usr/sbin \
--localstatedir=/srv/mysql \
--enable-thread-safe-client \
--enable-assembler \
--enable-local-infile \
--with-unix-socket-path=/var/run/mysql/mysql.sock \
--without-debug \
--without-bench \
--without-readline \
--with-berkeley-db \
--with-extra-charsets=all
make testdir=/tmp/mysql
Install the package
make testdir=/tmp/mysql install &&
rm -rf /tmp/mysql &&
cd /usr/lib64 &&
ln -v -sf mysql/libmysqlclient{,_r}.so* .
Configuring
install -v -m644 /usr/share/mysql/my-medium.cnf /etc/my.cnf
mysql_install_db --user=mysql &&
chgrp -v mysql /srv/mysql{,/test,/mysql}
install -v -m755 -o mysql -g mysql -d /var/run/mysql && mysqld_safe --user=mysql 2>&1 >/dev/null &
mysqladmin -u root password <new-password>
mysqladmin -p shutdown
BootScript
Install the init script included in the blfs-bootscripts package.
make install-mysql
