Shulou(Shulou.com)05/31 Report--

This article mainly explains "introduction to three installation methods of mysql". the explanation content in this article is simple and clear, easy to learn and understand. please follow the idea of Xiaobian and go deep into it slowly to study and learn "introduction to three installation methods of mysql" together.

MYSQL Version Introduction

MySQL is available in alpha,beta,rc and ga versions.

alpha implies that this is a release intended to show new features, that there is more instability, and that new features are added to the code

All APIs, external visual constructs, and SQL command lines are no longer changed in beta, release, or product releases after beta, adding new features to code that affect code stability.

rc stands for Release Candidate. Release candidates are considered stable, pass all mysql internal tests, and fix all known fatal bugs. But the rc version hasn't been around long enough to confirm that all bugs have been found, but only minor bug fixes will be made to the rc version.

GA without suffix implies that this is a mostly usable version or a production version. GA releases are stable, passed testing of earlier versions and showed usability, resolved all critical bugs, and suitable for use in production environments. Only a few more serious bug fixes were added to this release.

There are three common ways to install MySQL:

rpm packet form

universal binary form

source code compilation

1, rpm packet form

(1)Operating system publisher

(2)MySQL official (version update, fix more common bugs) www.mysql.com/downloads

An introduction to rpm package types in MySQL:

MySQL-client client component

MySQL-debuginfo Debugging MySQL components

MySQL-devel wants to compile and install MySQL dependent packages such as PHP for MySQL

Embedded version of MySQL

MySQL-server shared library

MySQL-shared shared library

MySQL-shared-dompat For compatibility with older versions of shared libraries

MySQL-test MySQL test component (online processing function)

------1 MySQL RPM package installation------

a. Check MySQL and related RPM packages for installation, and remove if installed (rpm -e name)

[root@localhost ~]# rpm -qa | grep -i mysql

mysql-libs-5.1.66-2.el6_3.x86_64

[root@localhost ~]# yum -y remove mysql-libs*

b. Download RPM packages for Linux, such as RPM packages for CentOS 6.4_64.

[root@localhost rpm]# ll

total 74364

-rw-r--r--. 1 root root 18442536 Dec 11 20:19 MySQL-client-5.6.15-1.el6.x86_64.rpm

-rw-r--r--. 1 root root 3340660 Dec 11 20:06 MySQL-devel-5.6.15-1.el6.x86_64.rpm

-rw-r--r--. 1 root root 54360600 Dec 11 20:03 MySQL-server-5.6.15-1.el6.x86_64.rpm

c. Install MySQL: rpm -ivh mysql*

[root@localhost rpm]# rpm -ivh MySQL-server-5.6.15-1.el6.x86_64.rpm

[root@localhost rpm]# rpm -ivh MySQL-devel-5.6.15-1.el6.x86_64.rpm

[root@localhost rpm]# rpm -ivh MySQL-client-5.6.15-1.el6.x86_64.rpm

#Modify configuration file location

[root@localhost rpm]# cp /usr/share/mysql/my-default.cnf /etc/my.cnf

d. Initialize MySQL and set password

[root@localhost rpm]# /usr/bin/mysql_install_db

[root@localhost rpm]# service mysql start

[root@localhost rpm]# cat /root/.mysql_secret

# The random password set for the root user at Wed Dec 11 23:32:50 2013 (local time): qKTaFZnl

set password for root@'localhost'=password("123456")

[root@localhost ~]# mysql -uroot -pqKTaFZnl

mysql> SET PASSWORD = PASSWORD ('123456 '); #Set password to 123456

mysql> exit

[root@localhost ~]# mysql -uroot -p123456

e. Allow remote login

mysql> use mysql;

mysql> select host,user,password from user;

+-----------------------+------+-------------------------------------------+

| host | user | password |

+-----------------------+------+-------------------------------------------+

| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

| localhost.localdomain | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |

| 127.0.0.1 | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |

| ::1 | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |

+-----------------------+------+-------------------------------------------+

mysql> update user set password=password('123456') where user='root';

mysql> update user set host='%' where user='root' and host='localhost';

mysql> flush privileges;

mysql> exit

f. Set boot up auto-start

[root@localhost ~]# chkconfig mysql on

[root@localhost ~]# chkconfig --list | grep mysql

mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off

g. Default installation location for MySQL

/var/lib/mysql/ #Database directory

/usr/share/mysql #Configuration file directory

/usr/bin #Related command directories

/etc/init.d/mysql #Start script

Modify character sets and data store paths

Configure/etc/my.cnf file, modify data storage path, mysql.sock path and default encoding utf-8.

view character set

show variables like '%collation%';

show variables like '%char%';

rpm -ql MYSQL-client View installation directory

rpm -e MYSQL-client MYSQL-server uninstall

Reference: http://blog.csdn.net/liumm0000/article/details/18841197/

------2 MySQL source code compilation installation------

yum install cmake install build tool

--cmake download install

http://cmake.org/download/

# wget http://cmake.org/files/v3.3/cmake-3.3.2.tar.gz

# tar xzvf cmake-3.3.2.tar.gz

# cd cmake-3.3.2

# ./ configure

# gmake && make install

--Create user

# groupadd mysql

# useradd -g mysql mysql

--Set user OS resource limits

# vi /etc/security/limits.conf

mysql soft nproc 2047

mysql hard nproc 16384

mysql soft nofile 1024

mysql hard nofile 65536

--Download and extract MySQL source files

https://dev.mysql.com/downloads/mysql/

# tar xzvf mysql-5.6.26.tar.gz

# cd mysql-5.6.26

--Execute cmake to generate compiled configuration files

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci\

-DINABLED_LOCAL_INFILE=ON \

-DWITH_INNOBASE_STORAGE_ENGINE=1\

-DWITH_FEDERATED_STORAGE_ENGINE=1\

-DWITH_BLACKHOLE_STORAGE_ENGINE=1\

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1\

-DWITH_PARTITION_STORAGE_ENGINE=1\

-DWITH_PERFSCHEMA_STORAGE_ENGINE=1\

-DCOMPILATION_COMMENT='JSS for mysql test' \

-DWITH_READLINE=ON \

-DSYSCONFDIR=/data/mysqldata/3306\

-DMYSQL_UNIX_ADDR=/data/mysqldata/3306/mysql.lock

--compile and install

# make && make install

--Modify Directory Permission

# chown -R mysql:mysql/usr/local/mysql

--Modify environment variable files

# vi /home/mysql/.bash_profile

export LANG=zh_CN.GB18030

export PATH=/usr/local/mysql/bin:$PATH

Reference: http://blog.csdn.net/lichangzai/article/details/48974721

------3 MySQL binary package installation------

tar cvfz/data/mysql-5.6.tar.gz/usr/local/mysql packages the compiled file, and the following steps are exactly the same as the second.

Thank you for reading, the above is "mysql three installation methods introduced" content, after the study of this article, I believe we have a deeper understanding of mysql three installation methods introduced this problem, the specific use of the situation also needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.