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:
  
groupadd -g 40 mysql &&
 
useradd -c "MySQL Server" -d /dev/null -g mysql -s /bin/false -u 40 mysql &&
 
 
  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 ===
  
TO BE DONE
+
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
  
groupadd -g 40 mysql &&
 
useradd -c "MySQL Server" -d /dev/null -g mysql -s /bin/false -u 40 mysql &&
 
 
  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 07:18, 5 September 2006

Download Source: http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.24a.tar.gz

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
Retrieved from "?title=MySQL&oldid=1606"