Shulou(Shulou.com)06/01 Report--

The following content mainly brings you an analysis of the installation and deployment of mysql5.6. The knowledge mentioned here, which is slightly different from books, is summed up by professional and technical personnel in the process of contact with users, and has a certain value of experience sharing. I hope to bring help to the majority of readers.

Add mysql user

Groupadd mysql

Useradd mysql-g mysql-M-s / sbin/nologin

Extract the file

Tar-zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz-C / data/

Mv / opt/mysql-5.6.33-linux-glibc2.5-x86_64 / data/mysql

Create data, log, lib files

Mkdir-p / data/mysql/data

Mkdir-p / data/mysql/var/ {log,lib}

Chown-R mysql:mysql / data/mysql

Install dependency packages

Yum-y install autoconf automake imake libxml2-devel expat-devel cmake gcc gcc-c++ libaio libaio-devel bzr bison libtool perl-Module-Install.noarch

Install Mysql

/ data/mysql/scripts/mysql_install_db\

-- user=mysql\

-- basedir=/data/mysql\

-- datadir=/data/mysql/data

Configure environment variables

Vim / etc/profile

# * DMP MYSQL ENV*

Export MYSQL_HOME=/data/mysql

Export PATH= "$PATH:$MYSQL_HOME/bin"

Configure Mysql:/etc/my.cnf

[mysql]

Socket = / data/mysql/var/lib/mysql.sock

Default-character-set=utf8

# log_error = / data/mysql/var/log/error.log

[client]

Socket=/data/mysql/var/lib/mysql.sock

Default-character-set=utf8

[mysqld]

Skip-name-resolve

Port=3306

Socket = / data/mysql/var/lib/mysql.sock

Basedir = / data/mysql

Datadir = / data/mysql/data

Max_connections = 3000

Character-set-server = utf8

Default-storage-engine = INNODB

Lower_case_table_names = 1

Max_allowed_packet = 16m

Sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

For the above analysis on the installation and deployment of mysql5.6, if you need to know more, you can continue to pay attention to the innovation of our industry. If you need professional answers, you can contact the pre-sales and after-sales on the official website. I hope this article can bring you some knowledge updates.

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.