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

Overview

This article for centos7.3 automatic compilation and installation of mysql5.3.6 scripts and subsequent initialization operations, not much, directly on the script.

The installation script install.py is as follows:

The definition variable install_dir ='/ data/mysql'data_dir ='/ data/mysql/data'package_dir ='/ data/mysql'log_dir ='/ data/mysql/logs'current_dir = os.getcwd () cmake = 'cmake-DCMAKE_INSTALL_PREFIX=%s-DMYSQL_UNIX_ADDR=%s/mysql.sock-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DMYSQL_DATADIR=%s-DMYSQL_TCP_PORT=3306'% (install_dir) Install_dir, data_dir) # install dependency package os.system ('yum install gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make cmake perl-y') # install function def install_mysql (): if os.system (' groupadd mysql') = = 0: print 'group mysql add packages Else: exit ('group mysql add failed') If os.system ('useradd-r-g mysql-s / bin/false mysql') = = 0: print' user mysql add examples' Else: exit ('user mysql add failed') If not os.path.exists (install_dir): os.system ('mkdir-p% s'% install_dir) if not os.path.exists (data_dir): os.system ('mkdir-p% s'% data_dir) if not os.path.exists (package_dir): os.system ('mkdir-p% s'% package_dir) if not os.path.exists (log_dir): os.system ('mkdir-p% s'%) Log_dir) if os.system ('tar zxvf mysql-5.6.36.tar.gz') = = 0: print' uncompress v subscription' Else: exit ('uncompress mysql-5.6.36.tar.gz failed') Os.chdir ('mysql-5.6.36') if os.system (cmake) = 0: print' compiled successfully 'else: exit (' compiled mysql failed') if os.system ('make & & make install') = 0: print' compiled and installed mysql successfully 'else: exit (' compiled and installed mysql failed') if os.system ('chown-R mysql:mysql% s' install_dir) = = 0: print 'installation directory permissions Successfully configured 'else: exit () os.system (' chown-R mysql:mysql% s'% data_dir) os.system ('cd% s & & touch mysql-error.log'% log_dir) os.system ('chown-R mysql:mysql% s'% log_dir) os.chdir (install_dir) if os.system ('. / scripts/mysql_install_db-- user=mysql-- datadir=%s'% data_dir) = 0: print 'mysql beginning Initialization succeeded 'else: exit (' mysql initialization failed') os.system ('cp support-files/mysql.server / etc/init.d/mysqld') os.system ('mv / etc/my.cnf / etc/my.cnf.bak') os.chdir (current_dir) os.system ('cp my.cnf / etc/my.cnf') os.system ('service mysqld start') os.system (' chkconfig mysqld on') install_mysql () if os.path. Exists ('/ etc/profile'): os.system ('cp / etc/profile / etc/profile.bak') if os.system ('echo "PATH=%s/bin:%s/lib:$PATH" > > / etc/profile'% (install_dir) Install_dir)) = 0: print 'modified / etc/profile successful' else: exit () if os.system ('echo "export PATH" > > / etc/profile') = 0: print' modified / etc/profile file succeeded 'else: exit ()

Profile my.cnf

[mysqld] basedir = / data/mysqldatadir = / data/mysql/datatmpdir = / data/mysqlsocket = / data/mysql/mysql.sockskip-external-lockingskip-name-resolvelower_case_table_names=1auto_increment_offset = 1autoincrement _ increment = 2 # server-id# binlog # log_bin = / data/mysql/logs/mysql-binbinlog_format = rowbinlog_cache_size = 2Mexpire-logs-days = steps # # error log# log_error = / data/mysql/logs/mysql-error.log# slow log# slow_query_log = 1slow_query_log_file = / data/mysql/logs/mysql-slow.loglong_query_time = per_thread_buffers # max_connections = 1024max_connect_errors = 1000key _ buffer_size = 64Mmax_allowed_packet = 128Mtable_open_cache = 6144table_definition_cache = 4096sort_buffer_size = 512Kread_buffer_size = 512Kjoin_buffer_size = 512Ktmp_table_size = 64Mmax_heap_table_size = 64Mthread_cache_size = 64thread_concurrency = 32bulk_insert_buffer_size = 64M#innodb#innodb_buffer_pool_size = 45Ginnodb_log_file_size = 500Minnodb_log_buffer_size = 64Minnodb_flush_log _ at_trx_commit = 2innodb_file_per_table = 1innodb_file_io_threads = 4innodb_flush_method = O_DIRECTinnodb_thread_concurrency = 0innodb_additional_mem_pool_size = 16m [mysqlhotcopy] interactive-timeout [mysqld_safe] open_files_limit = 65535

How to use it:

1. The operating system needs to configure the yum source

two。 Operating system version: centos7.3

3. Put the install.py my.cnf and mysql installation packages in a folder

Download address of mysql installation package: link: https://pan.baidu.com/s/1pKHbFlh password: tx9b

Initialization

Since the compiled and installed mysql5.6.36 by default does not have a password, enter mysql directly on the command line to log in and execute the following sql statement

-initialize data use mysql;update user set password=PASSWORD ("Abcd123") where user='root';grant all privileges on *. * to weihu@ "%" identified by "Abcd123"; delete from mysql.user where user=''; FLUSH PRIVILEGES;-- create demo database CREATE DATABASE `demo` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;show databases

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.