mysql5.36_01 Mysql 的安装( 5.36 社区版)-编译安装

1. 隆一个模板机器(使用centos6)，克隆完做快照2. IP 10.0.0.52主机名db023. 安装好依赖包yum install -y ncurses-devel libaio-devel

...4. 安装cmake命令yum install cmake -y

...5.创建用户

[root@db02 tools]# useradd-s /sbin/nologin -M mysql

[root@db02 tools]#idmysql

uid=501(mysql) gid=501(mysql) groups=501(mysql)6. 下载mysql5.6.36.tar.gz 到 /server/tools 目当下

#将下载好的文件夹,放到server/tools/目录下

[root@db02 tools]# ll

total31440

-rw-r--r-- 1 root root 32192348 Dec 30 15:50 mysql-5.6.36.tar.gz

[root@db02 tools]#tar xf mysql-5.6.36.tar.gz7. 进入到mysql 目录, 进行预编译

[root@db02 tools]# cd mysql-5.6.36[root@db02 mysql-5.6.36]#

cmake .-DCMAKE_INSTALL_PREFIX=/application/mysql-5.6.36\-DMYSQL_DATADIR=/application/mysql-5.6.36/data \-DMYSQL_UNIX_ADDR=/application/mysql-5.6.36/tmp/mysql.sock \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_EXTRA_CHARSETS=all \-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_FEDERATED_STORAGE_ENGINE=1\-DWITH_BLACKHOLE_STORAGE_ENGINE=1\-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1\-DWITH_ZLIB=bundled \-DWITH_SSL=bundled \-DENABLED_LOCAL_INFILE=1\-DWITH_EMBEDDED_SERVER=1\-DENABLE_DOWNLOADS=1\-DWITH_DEBUG=0....8. 运行make && make install[root@db02 mysql-5.6.36]#make && make install.... 此操作时间较长9. 创建软链接

[root@db02 application]# ll

total4drwxr-xr-x 13 root root 4096 Dec 30 17:10 mysql-5.6.36[root@db02 application]#ln -s /application/mysql-5.6.36/ /application/mysql

[root@db02 application]# ll

total4lrwxrwxrwx1 root root 26 Dec 30 17:11 mysql -> /application/mysql-5.6.36/drwxr-xr-x 13 root root 4096 Dec 30 17:10 mysql-5.6.36

10. 拷贝配置文件到/etc 下面

[root@db02 application]# cd mysql-5.6.36/[root@db02 mysql-5.6.36]# ll

total68drwxr-xr-x 2 root root 4096 Dec 30 17:10bin-rw-r--r-- 1 root root 17987 Mar 18 2017COPYING

drwxr-xr-x 3 root root 4096 Dec 30 17:10data

drwxr-xr-x 2 root root 4096 Dec 30 17:10docs

drwxr-xr-x 3 root root 4096 Dec 30 17:10include

drwxr-xr-x 3 root root 4096 Dec 30 17:10lib

drwxr-xr-x 4 root root 4096 Dec 30 17:10 mandrwxr-xr-x 10 root root 4096 Dec 30 17:10 mysql-test-rw-r--r-- 1 root root 2496 Mar 18 2017README

drwxr-xr-x 2 root root 4096 Dec 30 17:10scripts

drwxr-xr-x 28 root root 4096 Dec 30 17:10share

drwxr-xr-x 4 root root 4096 Dec 30 17:10 sql-bench

drwxr-xr-x 2 root root 4096 Dec 30 17:10 support-files

[root@db02 mysql-5.6.36]# cp support-files/my*.cnf /etc/my.cnfcp: overwrite `/etc/my.cnf'? y

11. 初始化数据库

[root@db02 mysql-5.6.36]#/application/mysql/scripts/mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data --user=mysql

......12. 创建关键目录并设置权限

[root@db02 mysql-5.6.36]# mkdir -p /application/mysql/tmp

[root@db02 mysql-5.6.36]# chown -R mysql.mysql /application/mysql/

13. 复制启动脚本到/etc/init.d/mysqld

[root@db02 mysql-5.6.36]# cp support-files/mysql.server /etc/init.d/mysqld14. 启动数据库

[root@db02 mysql-5.6.36]# /etc/init.d/mysqld start

Starting MySQL.Logging to'/application/mysql-5.6.36/data/db02.err'.

. SUCCESS![root@db02 mysql-5.6.36]# netstat -lntup|grep 330tcp0 0 :::3306 :::* LISTEN 20060/mysqld15. 配置环境变量

[root@db02 mysql-5.6.36]# echo 'PATH=/application/mysql/bin/:$PATH' >>/etc/profile

[root@db02 mysql-5.6.36]# source /etc/profile

[root@db02 mysql-5.6.36]# echo$PATH/application/mysql/bin/:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin16登录数据库

[root@db02 mysql-5.6.36]# mysql

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

Your MySQL connectionid is 1Server version:5.6.36Source distribution

Copyright (c)2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

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

mysql>mysql> selectuser,host,password from mysql.user;+------+-----------+----------+

| user | host | password |

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

| root | localhost | |

| root | db02 | |

| root | 127.0.0.1 | |

| root | ::1 | |

| | localhost | |

| | db02 | |

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

6 rows in set (0.00 sec)