mysql5.6编译安装包_MySQL5.6编译安装

比眉伴天荒 2023-01-11 13:17 132阅读 0赞

从mysql-5.6开始，Mysql改为用cmake编译安装。安装方法如下：

一、检查&安装cmake

\[root@Mysql-249 ~\]\# rpm -qa cmake

cmake-2.8.12.2-4.el6.x86\_64

如未安装，用yum方式安装cmake

yum install cmake -y

安装其他依赖包

yum install gcc gcc-c++ cmake ncurses-devel bison perl  -y

二、环境配置

\[root@Mysql-249 ~\]\#mkdir -p  /www/data

\[root@Mysql-249 ~\]\#useradd mysql

\[root@Mysql-249 ~\]\#chown -R mysql:mysql /www/data/

三、安装包准备

\[root@Mysql-249 ~\]\# cd /usr/local/src/

\[root@Mysql-249 src\]\# wget http://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.30.tar.gz

\[root@Mysql-249 src\]\# tar -xzf mysql-5.6.30.tar.gz

\[root@Mysql-249 src\]\# cd mysql-5.6.30

四、编译安装

\[root@Mysql-249 mysql-5.6.30\]\# cmake \\

\-DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql-5.6.30 \\

\-DMYSQL\_DATADIR=/www/data \\

\-DSYSCONFDIR=/etc/my.cnf \\

\-DWITH\_MYISAM\_STORAGE\_ENGINE=1 \\

\-DWITH\_INNOBASE\_STORAGE\_ENGINE=1 \\

\-DWITH\_MEMORY\_STORAGE\_ENGINE=1 \\

\-DWITH\_PARTITION\_STORAGE\_ENGINE=1 \\

\-DWITH\_READLINE=1 \\

\-DMYSQL\_UNIX\_ADDR=/www/data/mysqld.sock \\

\-DENABLED\_LOCAL\_INFILE=1 \\

\-DEXTRA\_CHARSETS=all \\

\-DDEFAULT\_CHARSET=utf8 \\

\-DDEFAULT\_COLLATION=utf8\_general\_ci \\

\-DMYSQL\_TCP\_PORT=3306

\[root@Mysql-249 mysql-5.6.30\]\# make && make install

五、修改Mysql配置文件

\[root@Mysql-249 mysql-5.6.30\]\# cat  > /etc/my.cnf <

\[mysqld\]

datadir=/www/data

socket=/www/data/mysqld.sock

user=mysql

\# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

\[mysqld\_safe\]

log-error=/www/data/mysqld.log

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

EOF

六、添加Mysql服务，配置开机自动启动

\[root@Mysql-249 mysql-5.6.30\]\#cp /usr/local/mysql-5.6.30/support-files/mysql.server  /etc/init.d/mysqld

\[root@Mysql-249 mysql-5.6.30\]\#chkconfig --add mysqld

\[root@Mysql-249 mysql-5.6.30\]\#chkconfig mysqld --level 345 on

七、初始化数据库，设置Mysql超级用户密码

\[root@Mysql-249 mysql-5.6.30\]\# ln -s /usr/local/mysql-5.6.30 /usr/local/mysql

\[root@Mysql-249 mysql-5.6.30\]\# ln -s /usr/local/mysql/bin/\* /usr/bin/

\[root@Mysql-249 mysql-5.6.30\]\# ln -s /usr/local/mysql/include/\* /usr/local/include/

\[root@Mysql-249 mysql-5.6.30\]\# /usr/local/mysql/scripts/mysql\_install\_db  --basedir=/usr/local/mysql  --datadir=/www/data/  --user=mysql

\[root@Mysql-249 mysql-5.6.30\]\# /etc/init.d/mysqld start

\[root@Mysql-249 mysql-5.6.30\]\# /usr/local/mysql/bin/mysql\_secure\_installation

八、Mysql测试

\[root@Mysql-249 mysql-5.6.30\]\# mysql -uroot -p

Enter password:

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

Your MySQL connection id is 1

Server version: 5.6.30 Source distribution

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> \\s

\--------------

mysql  Ver 14.14 Distrib 5.6.30, for Linux (x86\_64) using  EditLine wrapper

Connection id:          1

Current database:

Current user:           root@localhost

SSL:                    Not in use

Current pager:          stdout

Using outfile:          ''

Using delimiter:        ;

Server version:         5.6.30 Source distribution

Protocol version:       10

Connection:             Localhost via UNIX socket

Server characterset:    utf8

Db     characterset:    utf8

Client characterset:    utf8

Conn.  characterset:    utf8

UNIX socket:            /www/data/mysqld.sock

Uptime:                 16 sec

Threads: 1  Questions: 5  Slow queries: 0  Opens: 70  Flush tables: 1  Open tables: 63  Queries per second avg: 0.312

\--------------

编译参数说明：

\-DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql-5.6.30\#Mysql安装路径

\-DMYSQL\_DATADIR=/www/data\#数据存放路径

\-DSYSCONFDIR=/etc/my.cnf\#配置文件路径

\-DWITH\_MYISAM\_STORAGE\_ENGINE=1\#支持MyISAM存储引擎

\-DWITH\_INNOBASE\_STORAGE\_ENGINE=1\#支持INNODB存储引擎

\-DWITH\_MEMORY\_STORAGE\_ENGINE=1\#支持MEMORY引擎

\-DWITH\_ARCHIVE\_STORAGE\_ENGINE=1\#支持ARCHIVE引擎

\-DWITH\_PARTITION\_STORAGE\_ENGINE=1\#支持数据库分区

\-DWITH\_READLINE=1\#支持快捷键

\-DMYSQL\_UNIX\_ADDR=/www/data/mysqld.sock\#Unixsocket文件路径

\-DENABLED\_LOCAL\_INFILE=1\#允许本地导入数据库

\-DEXTRA\_CHARSETS=all\#安装所有字符集

\-DDEFAULT\_CHARSET=utf8\#设置默认字符集为UTF8

\-DDEFAULT\_COLLATION=utf8\_general\_ci\#设置默认字符校验

\-DMYSQL\_TCP\_PORT=3306\#设置Mysql端口

mysql5.6编译安装包_MySQL5.6编译安装

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 56、mysql的作业

相关 mysql57和56能同时安装吗linux

相关 mysql5.6编译安装包_MySQL5.6编译安装

相关 centos 7 mysql 编译安装_CentOS7 编译安装 MySQL5.7

相关编译安装MySQL

相关 Mac 升级到php56 ,手动启动mysql56方法

相关 MySQL的编译安装

相关 MySQL编译安装笔记

相关 mysql编译安装

相关编译安装apache php mysql