RHEL7.3編譯安裝mariadb10.2.6

1、解除安裝系統自帶的MySql或mariadb及boost

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

[root@rhel7 ~]# rpm -qa | grep mariadb

mariadb-libs-5.5.52-1.el7.x86_64

[root@rhel7 ~]# rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64

[root@rhel7 ~]# rpm -qa|grep boost

[root@rhel7 ~]# 

2、檢視是否存在mysql使用者及組

[root@rhel7 ~]# cat /etc/group | grep mysql

[root@rhel7 ~]# cat /etc/passwd | grep mysql

3、建立mysql使用者群組

[root@rhel7 ~]# groupadd mysql

[root@rhel7 ~]# useradd -g mysql -s /usr/sbin/nologin  mysql

4、建立mariadb安裝目錄

[root@rhel7 ~]#  mkdir -p /usr/local/mysql/data

5、安裝編譯軟體

[root@rhel7 ~]# yum install make gcc-c++ cmake  libaio libaio-devel perl-Data-Dumper net-tools  ncurses-devel bison bison-devel gcc-c++ ncurses-devel cmake  perl gcc autoconf automake zlib libxml libgcrypt libtool openssl-devel -y

6、安裝lrzsz，使用lrzsz上傳mariadb-10.2.6.tar.gz

[root@rhel7 ~]#  yum install lrzsz

[root@rhel7 ~]#  rz

上傳MySql壓縮包

7、解壓mariadb-10.2.6.tar.gz資料包

[root@rhel7 ~]#tar zxvf mariadb-10.2.6.tar.gz

8、cmake

[root@rhel7 ~]#cd mariadb-10.2.6

[root@rhel7 ~]#cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DWITHOUT_TOKUDB=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STPRAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWIYH_READLINE=1 -DWIYH_SSL=system -DVITH_ZLIB=system -DWITH_LOBWRAP=0 -DMYSQL_UNIX_ADDR=/usr/local/mysql/data/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

9、make

make -j 6 \\指定幾個線程處理

10、make install    \\安裝到指定目錄

11、更改mysql目錄權限

[root@rhel7 ~]# chown -R mysql.mysql /usr/local/mysql/

12、把mysql的執行路徑加入PATH中 

[root@rhel7 ~]#  vi /etc/profile

export PATH=$PATH:/usr/local/mysql/bin            \\把此行加入到最後一行

[root@rhel7 ~]#  source /etc/profile

13、cp适合的配置檔案

[root@rhel7 ~]# ls /usr/local/mysql/support-files/

magic                   my-large.cnf            mysqld_multi.server     

my-huge.cnf             my-medium.cnf           mysql-log-rotate        

my-innodb-heavy-4G.cnf  my-small.cnf            mysql.server    

[root@rhel7 ~]#cp /usr/local/mysql/support-files/my-small.cnf   /etc/my.cnf 

14、修改/etc/my.cnf

[root@rhel7 ~]# cat /etc/my.cnf 

# Example MySQL config file for small systems.

#

# This is for a system with little memory (<= 64M) where MySQL is only used

# from time to time and it's important that the mysqld daemon

# doesn't use much resources.

# MySQL programs look for option files in a set of

# locations which depend on the deployment platform.

# You can copy this option file to one of those

# locations. For information about these locations, see:

# http://dev.mysql.com/doc/mysql/en/option-files.html

# In this file, you can use all long options that a program supports.

# If you want to know which options a program supports, run the program

# with the "--help" option.

# The following options will be passed to all MySQL clients

[client]

#password       = your_password

port            = 3306

socket          = /usr/local/mysql/data/mysql.sock

# Here follows entries for some specific programs

# The MySQL server

[mysqld]

basedir        = /usr/local/mysql               //增加

datadir        = /usr/local/mysql/data          //增加

skip-external-locking

key_buffer_size = 16K

max_allowed_packet = 1M

table_open_cache = 4

sort_buffer_size = 64K

read_buffer_size = 256K

read_rnd_buffer_size = 256K

net_buffer_length = 2K

thread_stack = 240K

# Don't listen on a TCP/IP port at all. This can be a security enhancement,

# if all processes that need to connect to mysqld run on the same host.

# All interaction with mysqld must be made via Unix sockets or named pipes.

# Note that using this option without enabling named pipes on Windows

# (using the "enable-named-pipe" option) will render mysqld useless!

# 

#skip-networking

server-id       = 254

# Uncomment the following if you want to log updates

#log-bin=mysql-bin

# binary logging format - mixed recommended

#binlog_format=mixed

# Causes updates to non-transactional engines using statement format to be

# written directly to binary log. Before using this option make sure that

# there are no dependencies between transactional and non-transactional

# tables such as in the statement INSERT INTO t_myisam SELECT * FROM

# t_innodb; otherwise, slaves may diverge from the master.

#binlog_direct_non_transactional_updates=TRUE

# Uncomment the following if you are using InnoDB tables

#innodb_data_home_dir = /usr/local/mysql/data

#innodb_data_file_path = ibdata1:10M:autoextend

#innodb_log_group_home_dir = /usr/local/mysql/data

# You can set .._buffer_pool_size up to 50 - 80 %

# of RAM but beware of setting memory usage too high

#innodb_buffer_pool_size = 16M

#innodb_additional_mem_pool_size = 2M

# Set .._log_file_size to 25 % of buffer pool size

#innodb_log_file_size = 5M

#innodb_log_buffer_size = 8M

#innodb_flush_log_at_trx_commit = 1

#innodb_lock_wait_timeout = 50

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

# Remove the next comment character if you are not familiar with SQL

#safe-updates

[myisamchk]

key_buffer_size = 8M

sort_buffer_size = 8M

[mysqlhotcopy]

interactive-timeout

15、拷貝mysql服務

[root@rhel7 ~]# cp /usr/local/mysql/support-files/mysql.server  /etc/rc.d/init.d/mysqld

16、初始化資料庫

[root@rhel7 scripts]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --defaults-file=/etc/my.cnf 

17、啟動資料庫

[root@rhel7 ~]# /etc/rc.d/init.d/mysqld start

18、檢視端口是否正常

[root@rhel7 ~]# netstat -tunlp|grep 3306

tcp6       0      0 :::3306                 :::*                    LISTEN      1090/mysqld    

19、設定MariaDB root密碼

[root@node1 system]# /usr/local/mysql/bin/mysqladmin -u root  password "root@123"

20、登陸MariaDB資料庫

[root@rhel7 ~]# mysql -u root -p

Enter password: 

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 10

Server version: 10.2.6-MariaDB Source distribution

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 

21、修改密碼

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root@123';

22、遠端登入權限

GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'root@123';

FLUSH PRIVILEGES;

23、配置mysql自啟動

[root@rhel7 ~]# chkconfig --add mysqld

[root@rhel7 ~]# chkconfig mysqld on

[root@rhel7 ~]# chkconfig --list

Note: This output shows SysV services only and does not include native

      systemd services. SysV configuration data might be overridden by native

      systemd configuration.

      If you want to list systemd services use 'systemctl list-unit-files'.

      To see services enabled on particular target use

      'systemctl list-dependencies [target]'.

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

24、為mysql開啟防火牆 

firewall-cmd --permanent --zone=public --add-port=3306/tcp

 本文轉自 技術花妞妞 51CTO部落格，原文連結:http://blog.51cto.com/xiaogongju/1947588