mysql源码安装

本是古典何须时尚 2022-09-23 08:09 250阅读 0赞

检查是否安装了MySQL

root@bd-qa-mongodb-85:~\#rpm -qa | grep -i mysql

mysql-libs-5.1.73-5.el6\_6.x86\_64

使用yum来删除MySQL

[root@bd-qa-mongodb-85][root_bd-qa-mongodb-85]:~\#yum -y remove mysql-libs

安装依赖包

[root@bd-qa-mongodb-85][root_bd-qa-mongodb-85]:~\#yum -y install gcc gcc-c++ ncurses ncurses-devel cmake

下载相应源码包

wget http://downloads.sourceforge.net/project/boost/boost/1.59.0/boost\_1\_59\_0.tar.gz

wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.9.tar.gz

添加mysql用户

useradd -M -s /sbin/nologin mysql

解压

tar xzf boost\_1\_59\_0.tar.gz

tar xzf mysql-5.7.9.tar.gz

创建文件夹

mkdir -p /data/mysql

cd mysql-5.7.9

预编译

首先cmake参数的一些解释

\-DCMAKE\_INSTALL\_PREFIX= 安装根目录

\-DSYSCONFDIR=配置文件(my.cnf)目录

\-DCMAKE\_INSTALL\_PREFIX=  unix套接字目录

\-DDEFAULT\_CHARSET= 默认字符集

\-DDEFAULT\_COLLATION=默认编码

\-DWITH\_EXTRA\_CHARSETS= 额外的编码，请使用ALL来编译。

\-DWITH\_MYISAM\_STORAGE\_ENGINE=1  编译myisam存储引擎，默认的存储引擎，不加也可以

\-DWITH\_INNOBASE\_STORAGE\_ENGINE=1 支持InnoDB存储引擎，这个也是默认安装的

\-DWITH\_READLINE=1 使用readline功能

\-DENABLED\_LOCAL\_INFILE=1 可以使用load data infile命令从本地导入文件

\-DMYSQL\_DATADIR=数据库 数据目录

cmake . -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql -DMYSQL\_DATADIR=/data/mysql -DDOWNLOAD\_BOOST=1 -DWITH\_BOOST=../boost\_1\_59\_0 -DSYSCONFDIR=/etc -DWITH\_INNOBASE\_STORAGE\_ENGINE=1 -DWITH\_PARTITION\_STORAGE\_ENGINE=1 -DWITH\_FEDERATED\_STORAGE\_ENGINE=1 -DWITH\_BLACKHOLE\_STORAGE\_ENGINE=1 -DWITH\_MYISAM\_STORAGE\_ENGINE=1  -DENABLED\_LOCAL\_INFILE=1 -DENABLE\_DTRACE=0 -DDEFAULT\_CHARSET=utf8mb4 -DDEFAULT\_COLLATION=utf8mb4\_general\_ci -DWITH\_EMBEDDED\_SERVER=1

注意：\#从MySQL 5.7.5开始Boost库是必需的

编译安装

[root@bd-qa-mongodb-85][root_bd-qa-mongodb-85]:/opt/app/mysql/mysql-5.7.9\# make -j \`grep processor /proc/cpuinfo | wc -l\`   \#编译很消耗系统资源，小内存可能编译通不过

[root@bd-qa-mongodb-85][root_bd-qa-mongodb-85]:/opt/app/mysql/mysql-5.7.9\# make install

三个节点均执行上述操作

启动脚本，设置开机自启动

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

chmod +x /etc/init.d/mysqld

chkconfig --add mysqld

chkconfig mysqld on

[root@bd-qa-mongodb-85][root_bd-qa-mongodb-85]:/opt/app/mysql/config\#cat my.cnf

\[client\]

port = 3306

socket = /tmp/mysql.sock

default-character-set = utf8mb4

\[mysqld\]

port = 3306

socket = /tmp/mysql.sock

basedir = /usr/local/mysql

datadir = /data/mysql

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

user = mysql

bind-address = 0.0.0.0

server-id = 1

init-connect = 'SET NAMES utf8mb4'

character-set-server = utf8mb4

\#skip-name-resolve

\#skip-networking

back\_log = 300

max\_connections = 1000

max\_connect\_errors = 6000

open\_files\_limit = 65535

table\_open\_cache = 128

max\_allowed\_packet = 4M

binlog\_cache\_size = 1M

max\_heap\_table\_size = 8M

tmp\_table\_size = 16M

read\_buffer\_size = 2M

read\_rnd\_buffer\_size = 8M

sort\_buffer\_size = 8M

join\_buffer\_size = 8M

key\_buffer\_size = 4M

thread\_cache\_size = 8

query\_cache\_type = 1

query\_cache\_size = 8M

query\_cache\_limit = 2M

ft\_min\_word\_len = 4

log\_bin = mysql-bin

binlog\_format = mixed

expire\_logs\_days = 30

log\_error = /data/mysql/mysql-error.log

slow\_query\_log = 1

long\_query\_time = 1

slow\_query\_log\_file = /data/mysql/mysql-slow.log

performance\_schema = 0

explicit\_defaults\_for\_timestamp

\#lower\_case\_table\_names = 1

skip-external-locking

default\_storage\_engine = InnoDB

\#default-storage-engine = MyISAM

innodb\_file\_per\_table = 1

innodb\_open\_files = 500

innodb\_buffer\_pool\_size = 64M

innodb\_write\_io\_threads = 4

innodb\_read\_io\_threads = 4

innodb\_thread\_concurrency = 0

innodb\_purge\_threads = 1

innodb\_flush\_log\_at\_trx\_commit = 2

innodb\_log\_buffer\_size = 2M

innodb\_log\_file\_size = 32M

innodb\_log\_files\_in\_group = 3

innodb\_max\_dirty\_pages\_pct = 90

innodb\_lock\_wait\_timeout = 120

bulk\_insert\_buffer\_size = 8M

myisam\_sort\_buffer\_size = 8M

myisam\_max\_sort\_file\_size = 10G

myisam\_repair\_threads = 1

interactive\_timeout = 28800

wait\_timeout = 28800

\[mysqldump\]

quick

max\_allowed\_packet = 16M

\[myisamchk\]

key\_buffer\_size = 8M

sort\_buffer\_size = 8M

read\_buffer = 4M

write\_buffer = 4M

初始化数据库

/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

注：

之前版本mysql\_install\_db是在mysql\_basedir/script下，5.7放在了mysql\_install\_db/bin目录下,且已被废弃

“–initialize”会生成一个随机密码(~/.mysql\_secret)，而”–initialize-insecure”不会生成密码

–datadir目标目录下不能有数据文件

启动数据库

[root@bd-qa-mongodb-85][root_bd-qa-mongodb-85]:~\#service mysqld start

Starting MySQL. SUCCESS!

//添加path路径： vim /etc/profile 添加下面2行 在文件的结尾

\[root@oracle mysql-5.7.9\]\# export  MYSQL\_HOME=/usr/local/mysql

\[root@oracle mysql-5.7.9\]\# export PATH=$PATH:$MYSQL\_HOME/bin

//修改root密码，和授权新用户：

mysql> set password=password('fafa123');

Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> grant all on \*.\* to dba\_user@'%' identified by 'fafa123';

Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)

检查用户权限

mysql>  select user,host,authentication\_string from mysql.user;

\+-----------+-----------+-------------------------------------------+

| user      | host      | authentication\_string                     |

\+-----------+-----------+-------------------------------------------+

| root      | localhost | \*8C53D2FE0782BF01ACB952CF9C84B79701B310E5 |

| mysql.sys | localhost | \*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |

| dba\_user  | %         | \*8C53D2FE0782BF01ACB952CF9C84B79701B310E5 |

\+-----------+-----------+-------------------------------------------+

3 rows in set (0.03 sec)

测试登录

\[ [root@oracle][root_oracle] mysql-5.7.9\]\# mysql -u root -p

Enter password:

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

Your MySQL connection id is 3

Server version: 5.7.9-log 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>

成功

卸载数据库，注意删除的时候，直接删除目录就行

[root_bd-qa-mongodb-85]: mailto:root@bd-qa-mongodb-85
[root_oracle]: mailto:root@oracle

mysql源码安装

发表评论取消回复

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

相关阅读

相关 mysql源码安装脚本

相关 mysql 源码文档_mysql源码安装官方文档

相关 php mysql 源码安装教程_mysql的源码安装_MySQL

相关 Centos 源码安装 MySQL

相关 mysql源码安装

相关 ubuntu源码安装mysql

相关 mysql数据库——源码安装

相关 mysql源码包安装

相关 Linux源码安装MySQL

相关 Centos 源码安装安装Mysql