mysql 5.5.48源码安装_MySQL 5.6.48源码编译安装

[root@docker-1etc]# cd /usr/local/

#下载MySQL的源码包

[root@docker-1src]# tar xf mysql-5.6.48.tar.gz

#将下载的源码包解压到本地

[root@docker-1src] ll

#  total 31452

-drwxr-xr-x347161314154096Sep1611:38mysql-5.6.48

-rw-r--r--1root root32200158Jun223:54mysql-5.6.48.tar.gz

[root@docker-1mysql-5.6.48]# id mysql

#检查系统是否存在mysql用户id: mysql: no such user

#如果不存在则创建mysql用户

[root@docker-1mysql-5.6.48]# groupadd -g 550 mysql

[root@docker-1mysql-5.6.48]# useradd -g mysql -u 550 mysql

[root@docker-1mysql-5.6.48]# id mysqluid=550(mysql) gid=550(mysql) groups=550(mysql)

#安装编译前的依赖

[root@docker-1mysql-5.6.48]# yum install cmake autoconf wget gcc-c++ gcc ncurses-devel -y

[root@docker-1src]# cd mysql-5.6.48/

注意:默认字符集最好放前面 (-DDEFAULT_CHARSET=utf8)，否则make 编译时容易报错error: ‘DDEFAULT_CHARSET’ was not declared in this scope：

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_DATADIR=/usr/local/mysql/data \

-DSYSCONFDIR=/usr/local/mysql/ \

-DDEFAULT_CHARSET=utf8 \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_engine_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysqld.sock \

-DMYSQL_TCP_PORT=3306 \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DEXTRA_CHARSETS=all \

-DDEFAULT_COLLATION=utf8_general_ci

执行完cmake之后、执行make和make install 整个过程时间较长、请稍等！

编译参数详解 -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

#安装路径

-DMYSQL_DATADIR=/usr/local/mysql/data \

#数据文件存放地

-DSYSCONFDIR=/etc \

#配置文件my.cnf存放地

-DWITH_MYISAM_STORAGE_ENGINE=1 \

#支持MyIASM引擎

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

#支持InnoDB引擎

-DWITH_MEMORY_STORAGE_ENGINE=1 \

#支持Memory引擎

-DMYSQL_UNIX_ADDR=/var/run/mysql/mysqld.sock \

#连接数据库socket路径

-DMYSQL_TCP_PORT=3306 \

#数据库端口号

-DENABLED_LOCAL_INFILE=1 \

#允许从本地导入数据

-DWITH_PARTITION_STORAGE_ENGINE=1 \

#安装支持数据库分区

-DEXTRA_CHARSETS=all \

#安装所有的字符集

-DDEFAULT_CHARSET=utf8 \

#默认字符

-DDEFAULT_COLLATION=utf8_general_ci

[root@docker-1local]# cd /usr/local/mysql

[root@docker-1mysql]# ll #编译后的文件

[root@localhost ~]# ll /usr/local/mysql/

[root@localhost ~]# ll /usr/local/mysql/

total 240

drwxr-xr-x  2 root root  4096 Jul 25 18:37 bin

drwxr-xr-x  3 root root    18 Jul 25 18:36 data

drwxr-xr-x  2 root root    55 Jul 25 18:34 docs

drwxr-xr-x  3 root root  4096 Jul 25 18:34 include

drwxr-xr-x  3 root root    291 Jul 25 18:36 lib

-rw-r--r--  1 root root 219733 Mar  9 18:37 LICENSE

drwxr-xr-x  4 root root    30 Jul 25 18:35 man

drwxr-xr-x 10 root root  4096 Jul 25 18:39 mysql-test

-rw-r--r--  1 root root    587 Mar  9 18:37 README

drwxr-xr-x  2 root root    30 Jul 25 18:37 scripts

drwxr-xr-x 28 root root  4096 Jul 25 18:39 share

drwxr-xr-x  4 root root  4096 Jul 25 18:39 sql-bench

drwxr-xr-x  2 root root    136 Jul 25 18:39 support-files

[root@localhost ~]#

[root@localhost ~]# [root@docker-1mysql]# chown -R mysql.mysql  /usr/local/mysql

#对当前目录授权 数据库初始化 初始化之前需要修改my.cnf文件、内容如下：

[root@localhost mysql]# more my.cnf

[mysql] socket=/usr/local/mysql/mysql.sock

default-character-set=utf8 [mysqld]

skip-grant-tables explicit_defaults_for_timestamp=true

skip-name-resolve

port=3306 socket=/usr/local/mysql/mysql.sock basedir=/usr/local/mysql

max_connections=200

default-storage-engine=INNODB

lower_case_table_names=1

max_allowed_packet=16M

log-error=/usr/local/mysql/mysql.log

pid-file=/usr/local/mysql/mysql.pid

如果初始化报错：FATAL ERROR: Could not find ./bin/my_print_defaults 则加上 --basedir=/usr/local/mysql 就可以了

[root@docker-1mysql]#

./mysql_install_db --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql/ --no-defaults #开始初始化此时MySQL还是启动不了、还需要做些后续操作

[root@docker-1mysql]# cp ./support-files/mysql.server /etc/init.d/mysql #拷贝启动文件

[root@docker-1mysql]# chmod +x /etc/init.d/mysql

[root@docker-1mysql]# /etc/init.d/mysql start

#启动报错了Starting MySQL.Logging to'/var/log/mysql/mysql.log'.17091612:28:00mysqld_safe Directory'/var/lib/mysql'forUNIX socketfiledon't exists.ERROR! The server quit without updating PIDfile(/var/run/mysql/mysql.pid). Starting MySQL.200725 18:59:31 mysqld_safe error: log-error set to '/usr/local/mysql/mysql.log', however file don't exists. Create writable for user 'mysql'. ERROR! The server quit without updating PID file (/usr/local/mysql/mysql.pid).

[root@docker-1mysql]# mkdir /usr/local/mysql   -p

[root@docker-1mysql]# chown -R mysql.mysql   /usr/local/mysql

[root@docker-1mysql]# chown -R mysql.mysql /usr/local/mysql

[root@docker-1mysql]# /etc/init.d/mysql start #再次启动Starting MySQL. SUCCESS! #成功

[root@docker-1mysql] #

[root@docker-1mysql]# ps aux|grep mysql #查看mysql进程

[root@localhost mysql-5.6.48]# /etc/init.d/mysql start Starting MySQL.200725 18:59:31 mysqld_safe error: log-error set to '/usr/local/mysql/mysql.log', however file don't exists. Create writable for user 'mysql'. ERROR! The server quit without updating PID file (/usr/local/mysql/mysql.pid). 启动失败 换种方式启动：

/usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/mysql.pid 设置 /usr/local/mysql/my.cnf

启动成功：

添加登录跳过输入密码

[mysqld] skip-grant-tables

[root@localhost mysql]# /usr/local/mysql/bin/mysql -u root -p123456

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.48 Source distribution Copyright (c) 2000, 2020, 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> use mysql;

Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed

mysql> update user set password=password('123456') where user='root';

Query OK, 3 rows affected (0.00 sec) Rows matched: 3 Changed: 3 Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

授权:root用户

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> quit

#注释掉 设置 /usr/local/mysql/my.cnf

#添加登录跳过输入密码

[mysqld] #skip-grant-tables 可以直接执行

sed -i 's/skip-grant-tables/#skip-grant-tables/' /usr/local/mysql/my.cnf

可以直接登录了

[root@localhost mysql]# /usr/local/mysql/bin/mysql -u root -p123456

Warning: Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.48 Source distribution Copyright (c) 2000, 2020, 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>