Mysql手工编译安装--纯干货

最新推荐文章于 2024-05-05 18:59:03 发布

黑夜下的月光

最新推荐文章于 2024-05-05 18:59:03 发布

阅读量138

点赞数

文章标签：数据库 mysql linux

本文链接：https://blog.csdn.net/m0_46476544/article/details/107900067

版权

文章目录

Mysql手工编译安装

Mysql手工编译安装

一、编译安装MYSQL

1.1安装MYSQL环境依赖包

[root@localhost ~]#

yum -y install \
ncurses \
ncurses-devel \
bison \
cmake

1.2 创建运行用户

[root@localhost ~]# useradd -s /sbin/nologin mysql

1.3 编译安装

1.3.1 上传MySQ-boost-5.7.20.tar.gz到/opt目录下

[root@localhost opt]# rz -E
rz waiting to receive.
[root@localhost opt]# ls
mysql-boost-5.7.20.tar.gz  rh  wangwu

1.3.2 解压MySQ-boost-5.7.20.tar.gz

[root@localhost opt]# tar zxvf mysql-boost-5.7.20.tar.gz

1.3.3 配置

[root@localhost opt]# cd/opt/mysql-5.7.20/

[root@localhost mysql-5.7.20]#

cmake  \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
-DSYSCONFDIR=/etc \
-DSYSTEMD_PID_DIR=/usr/local/mysql \
-DDEFAULT_CHARSET=ut8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DWITH_BOOST=boost \
-DWITH_SYSTEMD=1

1.3.4编译安装

make && make install

二、优化调整

2.1数据库目录权限调整

[root@localhost mysql-5.7.20]# chown -R mysql:mysql /usr/local/mysql/

2.2调整配置文件

vim /etc/my.cnf

将里面内容删除，插入下面内容

[client]
port= 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock 

[mysql]
port =3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock 

[mysqld]
user = mysql
basedir = /usr/local/mysql
datadir= /usr/local/mysql/data 
port =3306
character_set_server=utf8
pid-file= /usr/local/mysql/mysqld.pid 
socket = /usr/local/mysql/mysql.sock 
server-id= 1
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER，NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,PIPES_AS_CONCAT,ANSI_QUOTES

2.3 设置环境变量

echo 'PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH' >> /etc/profile 
echo 'export PATH' >> /etc/profile 
source /etc/profile

三、初始化数据库

cd /usr/local/mysql/

执行

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

cp usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/

四、启动MYSQL服务并设置root数据库账号的密码

4.1开始数据库，检查状态

systemctl enable mysqld
systemctl start mysqld 
systemctl stop mysqld 
systemctl status mysqld
 netstat -ntap |grep mysqld

[root@localhost mysql]# systemctl enable mysqld   设置开机自启
Created symlink from /etc/systemd/system/multi-user.target.wants/mysqld.service to /usr/lib/systemd/system/mysqld.service.
[root@localhost mysql]# systemctl start mysqld    开启数据库
[root@localhost mysql]# netstat -ntap |grep mysqld    查查看端口
tcp6       0      0 :::3306                 :::*                    LISTEN      72596/mysqld        
[root@localhost mysql]# systemctl status mysqld 查看状态
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since 日 2020-08-09 20:44:15 CST; 25s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 72593 ExecStart=/usr/local/mysql/bin/mysqld --daemonize --pid-file=/usr/local/mysql/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
  Process: 72573 ExecStartPre=/usr/local/mysql/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 72596 (mysqld)
    Tasks: 27
   CGroup: /system.slice/mysqld.service
           └─72596 /usr/local/mysql/bin/mysqld --daemonize --pid-file=...

8月 09 20:44:15 localhost.localdomain mysqld[72593]: 2020-08-09T12:44...
8月 09 20:44:15 localhost.localdomain mysqld[72593]: 2020-08-09T12:44...
8月 09 20:44:15 localhost.localdomain mysqld[72593]: 2020-08-09T12:44...
8月 09 20:44:15 localhost.localdomain mysqld[72593]: 2020-08-09T12:44...
8月 09 20:44:15 localhost.localdomain mysqld[72593]: 2020-08-09T12:44...
8月 09 20:44:15 localhost.localdomain mysqld[72593]: Version: '5.7.20...
8月 09 20:44:15 localhost.localdomain mysqld[72593]: 2020-08-09T12:44...
8月 09 20:44:15 localhost.localdomain mysqld[72593]: 2020-08-09T12:44...
8月 09 20:44:15 localhost.localdomain mysqld[72593]: 2020-08-09T12:44...
8月 09 20:44:15 localhost.localdomain systemd[1]: Started MySQL Server.
Hint: Some lines were ellipsized, use -l to show in full.
[root@localhost mysql]# systemctl stop mysqld    关闭
[root@localhost mysql]# netstat -ntap |grep mysqld

4.2 设置密码

mysqladmin -u root -p password '//刚开始没密码是空的直接回车，然后输入密码abe123，再次确认密码'

4.3登录数据库

mysql -u root -p   '//这个命令敲下，提示要输入密码，这个就是刚才设置的密码abc123'

示例

[root@localhost mysql]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.20 Source 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 clear the current input statement.

mysql>

tered 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>