MySQL编译安装（单实例）

最新推荐文章于 2024-07-24 14:35:13 发布

脚灬印

最新推荐文章于 2024-07-24 14:35:13 发布

阅读量424

点赞数

分类专栏： MySQL 文章标签： mysql

本文链接：https://blog.csdn.net/lt53130640688/article/details/49639363

版权

MySQL 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

CentOS6.5编译安装Mysql5.5.32
1. 网络配置

[root@mysql ~]# vi /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
HWADDR=08:00:27:b8:ed:81
TYPE=Ethernet
UUID=e70002ef-8582-4e24-bf8a-76f34cf7ad3f
ONBOOT=yes
NM_CONTROLLED=yes
BOOTPROTO=none
IPADDR=10.0.0.10
NETMASK=255.255.255.0
GATEWAY=10.0.0.1

[root@mysql ~]# vi /etc/sysconfig/network-scripts/ifcfg-eth1
DEVICE=eth1
HWADDR=08:00:27:80:af:45
TYPE=Ethernet
UUID=3f89d03c-fcf9-465c-806b-bc5d3dd33b58
ONBOOT=yes
NM_CONTROLLED=yes
BOOTPROTO=none
IPADDR=192.168.0.10
NETMASK=255.255.255.0

service network restart
route add default gw 10.0.0.1 ##重启网卡后失效  ##永久方式 网卡添加GATEWAY=10.0.0.1
##DNS配置
[root@mysql ~]# cat /etc/resolv.conf 
nameserver 10.0.0.1

2. 防火墙设置

[root@mysql ~]#chkconfig iptables off
[root@mysql ~]#service iptables stop
[root@mysql ~]#service iptables status
[root@mysql ~]#sed -i "s#SELINUX=enforcing#SELINUX=disabled#g" /etc/selinux/config
[root@mysql ~]#setenforce 0

3. 安装环境

[root@mysql ~]# cat /etc/redhat-release  
CentOS release 6.5 (Final)
[root@mysql ~]# uname -r
2.6.32-431.el6.x86_64 [root@mysql ~]# uname -m 
x86_64 
[root@mysql ~]# uname -a Linux mysql 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09
UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

4.yum源配置

##网络yum源
[root@mysql ~]# mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup
[root@mysql ~]# wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo
[root@mysql ~]# yum makecache

##本地yum源
[root@mysql repodata]# cd /etc/yum.repos.d/
[root@mysql yum.repos.d]# vi CentOS-Base.repo
[base]
name=CentOS-$releasever - Base
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
baseurl=file:///mnt/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6

[root@mysql yum.repos.d]# yum clean all

http://mirrors.aliyun.com/help/centos

5.软件包安装

**选择最小化安装CentOS**
http://blog.csdn.net/lt53130640688/article/details/49638381

##上传下载软件包
[root@mysql yum.repos.d]# yum install lrzsz -y
##tree命令包
[root@mysql yum.repos.d]# yum install tree -y
##Mysql依赖包(重要)
[root@mysql yum.repos.d]# yum install ncurses-devel -y

6.上传cmake-2.8.8.tar.gz 和mysql-5.5.32.tar.gz

[root@mysql tools]# rz -y
rz waiting to receive.
Starting zmodem transfer.  Press Ctrl+C to cancel.
Transferring cmake-2.8.8.tar.gz...
  100%    5558 KB    5558 KB/sec    00:00:01       0 Errors  
Transferring mysql-5.5.32.tar.gz...
  100%   24019 KB    12009 KB/sec    00:00:02       0 Errors

7.安装Cmake 编译工具

[root@mysql tools]# tar xf cmake-2.8.8.tar.gz 
[root@mysql tools]# cd cmake-2.8.8
[root@mysql tools]# ./configure 
[root@mysql tools]# gmake
[root@mysql tools]# gmake install

8.安装MySQL

[root@mysql tools]# groupadd mysql
[root@mysql tools]# useradd mysql -s /sbin/nologin -M -g mysql
[root@mysql tools]# tar zxf mysql-5.5.32.tar.gz
[root@mysql tools]# cd mysql-5.5.32

[root@mysql mysql-5.5.32]# cmake -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \
-DMYSQL_DATADIR=/application/mysql-5.5.32/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock \
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0

##-DDEFAULT_CHARSET=utf8 \
##-DDEFAULT_COLLATION=utf8_general_ci \
[root@mysql mysql-5.5.32]# make && make install

9.配置MySQL

[root@mysql tools]# ln -s /application/mysql-5.5.32 /application/mysql
[root@mysql tools]# cp /application/mysql/support-files/my-small.cnf /etc/my.cnf
##添加环境变量
[root@mysql tools]# echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile
[root@mysql tools]# tail -1 /etc/profile
[root@mysql tools]# source /etc/profile
[root@mysql tools]# echo $PATH

10.初始化MySQL

##授权用户
[root@mysql scripts]# chown -R mysql.mysql /application/mysql/data/
##调整/tmp权限否则初始化报错
[root@mysql scripts]# chmod -R  1777 /tmp
[root@mysql scripts]# cd /application/mysql/scripts/
[root@mysql scripts]# ./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql

11.配置启动

[root@mysql support-files]# cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@mysql support-files]# chmod +x /etc/init.d/mysqld 
[root@mysql support-files]# /etc/init.d/mysqld start
Starting MySQL.. SUCCESS!

11.登陆优化mysql

[root@mysql support-files]# netstat -lntup
   tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      20719/mysqld        
[root@mysql support-files]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.32 Source distribution

Copyright (c) 2000, 2013, 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 clear the current input statement.
mysql> select host,user from mysql.user;
+-----------+------+
| host      | user |
+-----------+------+
| 127.0.0.1 | root |
| ::1       | root |
| localhost |      |
| localhost | root |
| mysql     |      |
| mysql     | root |
+-----------+------+
6 rows in set (0.00 sec)

mysql> delete from mysql.user where user='';
Query OK, 2 rows affected (0.00 sec)

mysql> delete from mysql.user where host='mysql';
Query OK, 1 row affected (0.00 sec)

mysql> select host,user from mysql.user;
+-----------+------+
| host      | user |
+-----------+------+
| 127.0.0.1 | root |
| ::1       | root |
| localhost | root |
+-----------+------+
3 rows in set (0.00 sec)

mysql> delete from mysql.user where host='::1';  
Query OK, 1 row affected (0.00 sec)
##::1 为IPV6地址
mysql> select host,user from mysql.user;
+-----------+------+
| host      | user |
+-----------+------+
| 127.0.0.1 | root |
| localhost | root |
+-----------+------+
2 rows in set (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)

mysql> drop database test;
Query OK, 0 rows affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)

12.其他

--设置密码
/application/mysql/bin/mysqladmin -u root password '123456'

--额外授权管理员用户 with grant option
grant all privileges on *.* to system@'localhost' identified by '123456' with grant option;

--系统字符集
[root@mysql support-files]# cat /etc/sysconfig/i18n 
LANG="en_US.UTF-8"
SYSFONT="latarcyrheb-sun16

13.网上相关资源
报错大全
http://www.tuicool.com/articles/E3yYV3
http://www.sijitao.net/1563.html

MySQL5.7.7 Release Candidate install 和 my.cnf文件
http://www.360doc.com/content/15/0629/08/14900341_481386848.shtml

https://typecodes.com/web/centosmysqlconfig.html
http://leeyin.iteye.com/blog/1459274

使用cmake命令，参数详解

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql  \              [MySQL安装的根目录]
-DMYSQL_DATADIR=/mydata/mysql/data  \                   [MySQL数据库文件存放目录]
-DSYSCONFDIR=/etc \                                     [MySQL配置文件所在目录]
-DMYSQL_USER=mysql \                                    [MySQL用户名]      
-DWITH_MYISAM_STORAGE_ENGINE=1 \                        [MySQL的数据库引擎]
-DWITH_INNOBASE_STORAGE_ENGINE=1 \                      [MySQL的数据库引擎]
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \                       [MySQL的数据库引擎]
-DWITH_MEMORY_STORAGE_ENGINE=1 \                        [MySQL的数据库引擎]
-DWITH_READLINE=1 \                                     [MySQL的readline library]
-DMYSQL_UNIX_ADDR=/var/run/mysql/mysql.sock \           [MySQL的通讯目录]
-DMYSQL_TCP_PORT=3306 \                                 [MySQL的监听端口]
-DENABLED_LOCAL_INFILE=1 \                              [启用加载本地数据]
-DENABLE_DOWNLOADS=1 \                                  [编译时允许自主下载相关文件]
-DWITH_PARTITION_STORAGE_ENGINE=1  \
-DEXTRA_CHARSETS=all \                                  [使MySQL支持所有的扩展字符]
-DDEFAULT_CHARSET=utf8 \                                [设置默认字符集为utf8]
-DDEFAULT_COLLATION=utf8_general_ci \                   [设置默认字符校对]
-DWITH_DEBUG=0 \                                        [禁用调试模式]
-DMYSQL_MAINTAINER_MODE=0 \
-DWITH_SSL:STRING=bundled \                             [通讯时支持ssl协议]
-DWITH_ZLIB:STRING=bundled                              [允许使用zlib library]

快速安装命令整合：

cat /etc/redhat-release  
uname -a
vi /etc/sysconfig/network-scripts/ifcfg-eth0
vi /etc/sysconfig/network-scripts/ifcfg-eth1
service network restart
echo 'nameserver 10.0.0.1'>> /etc/resolv.conf 

chkconfig iptables off
service iptables stop
service iptables status
setenforce 0
sed -i "s#SELINUX=enforcing#SELINUX=disabled#g" /etc/selinux/config

mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo
yum makecache
yum install lrzsz -y
yum install tree -y
yum install ncurses-devel -y

tar xf cmake-2.8.8.tar.gz 
cd cmake-2.8.8
./configure 
gmake
gmake install

groupadd mysql
useradd mysql -s /sbin/nologin -M -g mysql
tar zxf mysql-5.5.32.tar.gz
cd  mysql-5.5.32

cmake -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \
-DMYSQL_DATADIR=/application/mysql-5.5.32/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock \
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0

 make && make install

ln -s /application/mysql-5.5.32 /application/mysql
cp /application/mysql/support-files/my-small.cnf /etc/my.cnf

echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile
tail -1 /etc/profile
source /etc/profile

chown -R mysql.mysql /application/mysql/data/
chmod -R  1777 /tmp
cd /application/mysql/scripts/
 ./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql

cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld 
/etc/init.d/mysqld start
netstat -lntup