MySQL
Download Source: | http://mysql.mirrors.hoobly.com/Downloads/MySQL-5.1/mysql-5.1.43.tar.gz |
---|
Contents
Introduction to MySQL
MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon and many different client programs and libraries.
Project Homepage: http://www.mysql.com/
Dependencies
Optional
MySQL User/Group
groupadd -g 40 mysql && useradd -c "MySQL Server" -d /dev/null -g mysql -s /bin/false -u 40 mysql
Configure options
You can pass --with-mysqld-ldflags=-all-static configure option if You don't use LDAP for groups in /etc/nsswitch.conf. According to MySQL, it brings >10% performance gain if enabled.
--with-mysqld-ldflags=-all-static
Turn Secure Connections on
--with-ssl
Use "fast" mutexes
--with-fast-mutexes
Non-Multilib
Compile the package (32Bit target):
CXXFLAGS="${CXXFLAGS} -fno-exceptions -fno-rtti -fno-strict-aliasing \ -fno-implicit-templates -felide-constructors -DBIG_JOINS=1" \ ./configure --prefix=/usr \ --sysconfdir=/etc \ --libexecdir=/usr/sbin \ --localstatedir=/srv/mysql \ --enable-assembler \ --enable-local-infile \ --without-debug \ --with-libwrap --with-readline \ --with-geometry \ --with-low-memory \ --without-pstack \ --without-docs \ --enable-thread-safe-client \ --with-client-ldflags=-lstdc++ \ --with-extra-charsets=all \ --with-mysqld-user=mysql \ --with-server \ --with-unix-socket-path=/var/run/mysql/mysql.sock \ --with-plugins=csv,myisam,myisammrg,heap,innobase \ --with-embedded-server \ --with-embedded-privilege-control && make testdir=/tmp/mysql
Compile the package (64Bit target):
CFLAGS="${CFLAGS} -fPIC" \ CXXFLAGS="${CXXFLAGS} -fno-exceptions -fno-rtti -fno-strict-aliasing \ -fno-implicit-templates -felide-constructors -DBIG_JOINS=1 -fPIC" \ ./configure --prefix=/usr \ --sysconfdir=/etc \ --libexecdir=/usr/sbin \ --localstatedir=/srv/mysql \ --enable-assembler \ --enable-local-infile \ --without-debug \ --with-libwrap --with-readline \ --with-geometry \ --with-low-memory \ --without-pstack \ --without-docs \ --with-pic --with-lib-ccflags=-fPIC \ --enable-thread-safe-client \ --with-client-ldflags=-lstdc++ \ --with-extra-charsets=all \ --with-mysqld-user=mysql \ --with-server \ --with-unix-socket-path=/var/run/mysql/mysql.sock \ --with-plugins=csv,myisam,myisammrg,heap,innobase \ --with-embedded-server \ --with-embedded-privilege-control && 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
32Bit
Compile the package:
CC="gcc ${BUILD32}" CXX="g++ ${BUILD32}" \ LDFLAGS="-L/usr/lib" \ CXXFLAGS="${CXXFLAGS} -fno-exceptions -fno-rtti -fno-strict-aliasing \ -fno-implicit-templates -felide-constructors -DBIG_JOINS=1" \ ./configure --prefix=/usr \ --sysconfdir=/etc \ --libexecdir=/usr/sbin \ --localstatedir=/srv/mysql \ --enable-assembler \ --enable-local-infile \ --without-debug \ --with-libwrap --with-readline \ --with-geometry \ --with-low-memory \ --without-pstack \ --without-docs \ --enable-thread-safe-client \ --with-client-ldflags=-lstdc++ \ --with-extra-charsets=all \ --with-mysqld-user=mysql \ --with-server \ --with-unix-socket-path=/var/run/mysql/mysql.sock \ --with-plugins=csv,myisam,myisammrg,heap,innobase \ --with-embedded-server \ --with-embedded-privilege-control && make testdir=/tmp/mysql
Install the package
make testdir=/tmp/mysql install && mv -v /usr/bin/mysql_config{,-32} && rm -rf /tmp/mysql && cd /usr/lib && ln -v -sf mysql/libmysqlclient{,_r}.so* .
N32
Compile the package
CC="gcc ${BUILDN32}" CXX="g++ ${BUILDN32}" \ CXXFLAGS="${CXXFLAGS} -fno-exceptions -fno-rtti -fno-strict-aliasing \ -fno-implicit-templates -felide-constructors -DBIG_JOINS=1" \ ./configure --prefix=/usr --libdir=/usr/lib32 \ --sysconfdir=/etc \ --libexecdir=/usr/sbin \ --localstatedir=/srv/mysql \ --enable-assembler \ --enable-local-infile \ --without-debug \ --with-libwrap --with-readline \ --with-geometry \ --with-low-memory \ --without-pstack \ --without-docs \ --enable-thread-safe-client \ --with-client-ldflags=-lstdc++ \ --with-extra-charsets=all \ --with-mysqld-user=mysql \ --with-server \ --with-unix-socket-path=/var/run/mysql/mysql.sock \ --with-plugins=csv,myisam,myisammrg,heap,innobase \ --with-embedded-server \ --with-embedded-privilege-control && make testdir=/tmp/mysql
Install the package
make testdir=/tmp/mysql install && mv -v /usr/bin/mysql_config{,-n32} && rm -rf /tmp/mysql && cd /usr/lib32 && ln -v -sf mysql/libmysqlclient{,_r}.so* .
64Bit
Compile the package
CC="gcc ${BUILD64}" CXX="g++ ${BUILD64}" \ CFLAGS="${CFLAGS} -fPIC" \ CXXFLAGS="${CXXFLAGS} -fno-exceptions -fno-rtti -fno-strict-aliasing \ -fno-implicit-templates -felide-constructors -DBIG_JOINS=1 -fPIC" \ ./configure --prefix=/usr --libdir=/usr/lib64 \ --sysconfdir=/etc \ --libexecdir=/usr/sbin \ --localstatedir=/srv/mysql \ --enable-assembler \ --enable-local-infile \ --without-debug \ --with-libwrap --with-readline \ --with-geometry \ --with-low-memory \ --without-pstack \ --without-docs \ --with-pic --with-lib-ccflags=-fPIC \ --enable-thread-safe-client \ --with-client-ldflags=-lstdc++ \ --with-extra-charsets=all \ --with-mysqld-user=mysql \ --with-server \ --with-unix-socket-path=/var/run/mysql/mysql.sock \ --with-plugins=csv,myisam,myisammrg,heap,innobase \ --with-embedded-server \ --with-embedded-privilege-control && make testdir=/tmp/mysql
Install the package
make testdir=/tmp/mysql install && mv -v /usr/bin/mysql_config{,-64} && ln -sfv multiarch_wrapper /usr/bin/mysql_config && rm -rf /tmp/mysql && cd /usr/lib64 && ln -v -sf mysql/libmysqlclient{,_r}.so* .
Configuring
Make sure your hostname is not a "localhost"
hostname
Install default config
install -v -m644 /usr/share/mysql/my-medium.cnf /etc/my.cnf
Make convenience links for mysqlcheck multi-call binary
ln -sv mysqlcheck /usr/bin/mysqlanalyze && ln -sv mysqlcheck /usr/bin/mysqlrepair && ln -sv mysqlcheck /usr/bin/mysqloptimize
Secure the logfiles and runfiles
install -v -m755 -o mysql -g mysql -d /var/run/mysql && install -v -m750 -o mysql -g mysql -d /var/log/mysql && touch /var/log/mysql/mysql.{log,err} && chown mysql:mysql /var/log/mysql/mysql* && chmod 0660 /var/log/mysql/mysql*
Install MySQL databases
/usr/bin/mysql_install_db --user=mysql && chgrp -v mysql /srv/mysql{,/test,/mysql}
Start server in 'safe' mode
mysqld_safe --user=mysql 2>&1 >/dev/null &
Set password for the mysql 'root' user
mysqladmin -u root password '<new-password>'
Fill help tables
/usr/bin/mysql --user=root --password mysql < /usr/share/mysql/fill_help_tables.sql
Fill timezones
/usr/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo > /tmp/mysql_tzinfo.sql && /usr/bin/mysql --user=root --password mysql < /tmp/mysql_tzinfo.sql
Shutdown server
mysqladmin -p shutdown
BootScript
Install the init script included in the bootscripts package:
make install-mysql
Contents
Installed Directories: | /usr/include/mysql, /usr/share/mysql, /usr/lib/mysql |
---|---|
Installed Programs: | mysqld_safe, mysql_install_db, msql2mysql, mysql_config, mysql_fix_privilege_tables, mysql_fix_extensions, mysql_setpermission, mysql_secure_installation, mysql_zap, mysqlaccess, mysqlbug, mysql_convert_table_format, mysql_find_rows, mysqlhotcopy, mysqldumpslow, mysql_explain_log, mysql_tableinfo, mysql_upgrade_shell, mysqld_multi, replace, comp_err, perror, resolveip, my_print_defaults, resolve_stack_dump, mysql_waitpid, innochecksum, myisamchk, myisamlog, myisampack, myisam_ftdump, mysql_tzinfo_to_sql, mysqld, mysql, mysqladmin, mysqlcheck, mysqlshow, mysqldump, mysqlimport, mysqltest, mysqlbinlog, mysql_upgrade, mysqltestmanagerc, mysqltestmanager-pwgen, mysql_client_test, mysqltest_embedded, mysqltestmanager, mysqlmanager |
Installed Libraries: | libmystrings.a, libmysys.a, libdbug.a, libmyisam.a, libmyisammrg.a, libheap.a, libvio.a, libmysqlclient_r.{a,la,so}, libmysqlclient.{a,la,so}, libmysqld.a |