MySQL为什么要先安装yum仓库_mysql的源码安装与yum 仓库安装

1、准备编译环境。

1. yum groupinstall "Server Platform Development" "Development tools" -y

2. yum install cmake -y

2、准备mysql数据存放目录。

1. # mkdir /mnt/data

2. # groupadd -r mysql

3. # useradd -r -g mysql -s /sbin/nologin mysql

4. # id mysql

uid=497(mysql) gid=498(mysql) groups=498(mysql)

3、更改数据目录属主属组。

# chown -R mysql:mysql /mnt/data

4、解压编译在MySQL官网下载的稳定版源码包，这里使用的是5.6.23版本

# tar xvf mysql-5.6.23.tar.gz -C /usr/local/src

# cd /usr/local/src/mysql-5.6.23

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

-DMYSQL_USER=mysql \

-DMYSQL_DATADIR=/data/mysql \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_ARCHIVE_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

#####-DWITH_SSL=system \

-DWITH_ZLIB=system \

-DWITH_LIBWRAP=0 \

-DMYSQL_TCP_PORT=3306 \

-DMYSQL_UNIX_ADDR=/usr/local/mysql-5.6.23/run/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci

# make && make install

5、修改安装目录的属组为mysql。

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

6、初始化数据库。

[root@java4 mysql-5.6.23]# /usr/local/mysql-5.6.23/scripts/mysql_install_db --user=mysql --datadir=/data/mysql/ --basedir=/usr/local/mysql-5.6.23/

7、配置my.cnf [未开启binlog]

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

[mysqld]

socket=/data/mysql/mysql.sock

pid-file=/data/mysql/mysqld.pid

datadir=/data/mysql

basedir=/usr/local/mysql-5.6.23/

default-storage-engine = innodb

innodb_file_per_table

character-set-server = utf8

collation-server = utf8_general_ci

init-connect = 'SET NAMES utf8'

innodb_log_file_size = 512M

max_allowed_packet = 1024M

log-error = /var/log/mysql/mysql.err

slow_query_log

long_query_time = 2

slow_query_log_file = /var/log/mysql/slow.log

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

max_connections=1000

[client]

socket=/data/mysql/mysql.sock

8、配置环境变量

[root@java4 ~]# echo "export PATH=$PATH:/usr/local/mysql-5.6.23/bin/" > /etc/profile.d/mysql.sh

[root@java4 ~]# source /etc/profile.d/mysql.sh

9、配置开机自启并启动

[root@java4 ~]# echo "/usr/bin/nohup /bin/sh /usr/local/mysql-5.6.23/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql --datadir=/data/mysql/ --basedir=/usr/local/mysql-5.6.23/ --socket=/data/mysql/mysql.sock >> /var/log/mysql.nohup 2>&1 &" >> /etc/rc.local

[root@java4 ~]# /usr/bin/nohup /bin/sh /usr/local/mysql-5.6.23/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql --datadir=/data/mysql/ --basedir=/usr/local/mysql-5.6.23/ --socket=/data/mysql/mysql.sock >> /var/log/mysql.nohup 2>&1 &

9.设置MySQL安全

CREATE DATABASE `xx` DEFAULT CHARACTER SET utf8 ；

mysql> grant all privileges on xx.* to 'xx'@'172.18.xx.%' identified by 'xxx';

mysql> update user set password=password('xxx') where user=root and host=localhost;

mysql> delete user from user where password='';

mysql> flush privileges;

10、导入数据

略。。。

===============

mysql的yum 安装

1.下载rpm 仓库包

2.yum repolist all | grep mysql

sudo yum-config-manager --disable mysql80-community

sudo yum-config-manager --enable mysql56-community

4.yum repolist enabled | grep mysql

5.sudo yum install mysql-community-server