Installation of two versions of MySQL

Source: Internet
Author: User
Tags openssl

The way to install MySQL is: Source package, RPM package (older) and binary package.

Install MySQL 5.1.50:

1. Install dependent packages

#yum-y install gccgcc-c++ ncurses ncurses-devel OpenSSL openssl-devel libtool*


2. Create User:

# Groupadd MySQL

# Useradd Mysql–g Mysql–s/sbin/nologin


3. Install MySQL

# TAR–XVF Mysql-5.1.50.tar.gz

#cd mysql-5.1.50

#./configure '--prefix=/usr/local/services/mysql '--localstatedir=/data/dbdata/'--with-unix-socket-path=/usr/ Local/mysql/tmp/mysql.sock '--with-charset=utf8 '--with-extra-charsets=complex '--with-pthread '-- Enable-thread-safe-client '--with-ssl '--with-client-ldflags=-all-static '--with-mysqld-ldflags=-all-static '- -with-plugins=partition,federated,ndbcluster,innobase,csv,blackhole,myisam,innodb_plugin,heap,archive '-- Enable-shared '--enable-assembler '

# Make && make install

Explain

--prefix Specifying MYSQL installation directory (required)

--localstatedir specifying MySQL data storage directory (required)

--with-unix-socket-path Performing Socke storage location (required)

--with-charset specifying the default character set

--with-extra-charsets can extend complex character sets

--with-pthread forcing the use of the Pthread class library

--enable-thread-safe-client using the compile client; (Let the client support thread meaning)

--WITH-SSL support for SSL enabled

--with-client-ldflags=-all-static statically compiled MySQL client; (static link improves 13% performance)

--with-mysqld-ldflags=-all-static statically compiled MySQL server side; (static link improves 13% performance)

--with-plugins MySQL server-side supported storage engine

--enable-shared Shared Mutation Module

--enable-assembler using assembly mode for increased efficiency


4. Initialization

# mkdir/data/dbdata/

# Chown-r Mysql:mysql/usr/local/services/mysql

# Chown-r mysql:mysql/data/dbdata/

/usr/local/services/mysql/bin/mysql_install_db--user=mysql--basedir=/usr/local/services/mysql--datadir=/data/ dbdata/

# Cp/usr/local/services/mysql/share/mysql/mysql.server/etc/init.d/mysqld

# chmod 755/etc/init.d/mysqld

# Vim/etc/init.d/mysqld

Basedir=/usr/local/services/mysql

datadir=/data/dbdata/


5. Configuration Files

#cp support-files/my-medium.cnf/etc/my.cnf

# VIM/ETC/MY.CNF


6. Start service and SET environment variables

#:vim/etc/profile

Mysql=/usr/local/services/mysql/bin

Path= $PATH: $MYSQL

Export PATH

#source/etc/profile

Start the service

#/etc/init.d/mysqld Start



Mysql5.6 Source Package Installation:

Yum install vim-enhanced cmake gcc gcc-c++ ncurses-devel Bison make-y

Groupadd-g MySQL

Useradd-u 27-g mysql-s/sbin/nologin-m MySQL

Mkdir/database

cmake-dcmake_install_prefix:path=/usr/local/mysql5.6-dmysql_datadir:path=/database/-DSYSCONFDIR:PATH=/usr/ Local/mysql5.6/etc-dwith_debug:bool=on

CMake (-LH) generates CMakeCache.txt and then serves the make

Compilation error deleting CMakeCache.txt after recompilation

Options for man make CMake-l-d

Mysqld D is a group

[[email protected] mysql5.6] #mkdir etc; cp/etc/my.cnf etc/my.cnf

[Mysqld]

basedir=/usr/local/mysql5.6

Datadir=/database

Socket=/var/run/mysqld/mysql5.6.sock

Pid-file=/var/run/mysqld/mysql5.6.pid

User=mysql

PORT=3307 is generally 3306, set 3307 in order to coexist with the RPM package (this is a compilation installation)

The above store customizations are best not to be mixed with other package catalogs

[Mysqld_safe]

Log-error=/var/log/mysqld/mysqld.log

Create a folder that does not exist manually/var/run/mysqld/var/log/mysqld

[[email protected] mysql5.6] #chown-R mysql:mysql/usr/local/mysql5.6/database/var/run/mysqld/var/log/mysqld

[Email protected] mysql5.6]# pwd

/usr/local/mysql5.6

[[email protected] mysql5.6]# vim scripts/mysql_install_db (start)

[Email protected] scripts]# #./mysql_install_db--basedir=/usr/local/mysql5.6/--datadir=/database--user=mysql

-bash:./mysql_install_db: Insufficient permissions (chmod +x mysql_install_db)

(The following file is generated above)

[Email protected] scripts]# ls/database/

Ibdata1 ib_logfile0 ib_logfile1 mysql performance_schema test

[Email protected] support-files]# cp-v mysql.server/etc/rc.d/init.d/mysql5.6

"Mysql.server", "/etc/rc.d/init.d/mysql5.6"

[Email protected] support-files]# vim/etc/init.d/mysql5.6

CONF=/USR/LOCAL/MYSQL5.6/ETC/MY.CNF modification

[Email protected] support-files]# chkconfig--add mysql5.6

[Email protected] support-files]# service mysql5.6 restart

PS aux |grep MySQL # (with root and MySQL user launch separate files)

[[email protected] wan]# ls/var/run/mysqld/# (service start only)

Mysql5.6.pid Mysql5.6.sock

[Email protected] ~]#/usr/local/mysql5.6/bin/mysql

ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/tmp/mysql.sock ' (2) #/TMP under NO

[[email protected] ~]# mysql-s/var/run/mysqld/mysql5.6.sock # designation, different from RPM package

# #5.1 Client Login

#/usr/local/mysql5.6/bin/mysql-s/var/lib/mysqld/mysql.sock # 5.6 Client Access 5.1 RPM package yum install MySQL mysql-devel mysql-s erver Php-mysql # service Mysqld restart


Paste the MySQL script installed:

#!/bin/bash#./mysql.sh mysql-5.6.17.tar.gzname1= "$" name2=${name1/.tar.gz/}if ! grep -qi   "^mysql"  /etc/group; thengroupadd -g 27 mysqlfiif ! id mysql  >/dev/null 2>&1; thenuseradd -u 27 -g mysql -s /sbin/ nologin -m mysqlfiyum install -y cmake make gcc gcc-c++  ncurses-devel bison >/dev/null 2>&1[ -d /usr/local/mysql5.6 ]  && rm -rf /usr/local/mysql5.6[ -d /database ] && rm  -rf /database/* | |  mkdir /databaseif [ -d  "$name 2"  ]; then[ -e  "$name 2/ CMakeCache.txt " ] && rm -f " $name 2/cmakecache.txt "elsetar xf " $ Name1 "ficd  $name 2#cmake -lh  generated cmakecache.txt, make Just press this cache file to compile #man cmakecmake  -dcmake_install_prefix:path=/usr/local/mysql5.6 -dmysql_datadir:path=/database -dsysconfdir:path=/usr/local/ mysql5.6/etc -dwith_debug:bool=onmakemake installmkdir /usr/local/mysql5.6/etccat << ! >/usr/local/mysql5.6/etc/my.cnf[mysqld]basedir=/usr/local/mysql5.6datadir=/databasesocket=/var/run/ mysqld/mysql5.6.sockpid-file=/var/run/mysqld/mysql5.6.pidport=3307user=mysql[mysqld_safe]log-error=/var/log/ mysqld/mysql5.6-error.log! [ -d /var/run/mysqld ] && rm -rf /var/run/mysqld/* | |  mkdir /var/run/mysqld[ -d /var/log/mysqld ] && rm -rf / var/log/mysqld/* | |  mkdir /var/log/mysqldchown -r mysql.mysql /usr/local/mysql5.6 /database / var/run/mysqld /var/log/mysqld/usr/local/mysql5.6/scripts/mysql_install_db --basedir=/usr/local/ mysql5.6 --datadir=/database --user=mysqlcp /usr/local/mysql5.6/support-files/mysql.server /etc/rc.d/init.d/mysql5.6sed -i  '/conf=/c conf=/usr/local/mysql5.6/etc/my.cnf '  /etc/rc.d/init.d/mysql5.6chkconfig --add mysql5.6service mysql5.6 start


This article is from the "8430296" blog, please be sure to keep this source http://8440296.blog.51cto.com/8430296/1582118

Installation of two versions of MySQL

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.