mysql 进阶

最新推荐文章于 2024-09-11 14:10:29 发布

享我所想kx

最新推荐文章于 2024-09-11 14:10:29 发布

阅读量332

点赞数

文章标签：大数据

本文链接：https://blog.csdn.net/kx0822/article/details/125503667

版权

1. 二进制格式mysql安装

下载软件包

/usr/src中下载二进制格式的 mysql 软件包

[root@10 ~]# cd /usr/src

[root@10 src]# ls
  mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz

创建 用户 组
[root@10 src]# useradd -r -M -s /sbin/nologin mysql

[root@10 src]# id mysql
uid=993(mysql) gid=991(mysql) groups=991(mysql)

改名
[root@10 local]# mv mysql-5.7.37-linux-glibc2.12-x86_64/ mysql
改属组
[root@10 local]# chown -R mysql.mysql mysql
[root@10 local]# ll
total 0
drwxr-xr-x. 14 root  root  164 Apr 16 11:53 apache
drwxr-xr-x.  6 root  root   58 Apr 16 11:12 apr
drwxr-xr-x.  5 root  root   43 Apr 16 11:15 apr-until
drwxr-xr-x.  5 root  root   43 Apr 16 11:41 apr-util
drwxr-xr-x.  2 root  root    6 Jun 22  2021 bin
drwxr-xr-x.  2 root  root    6 Jun 22  2021 etc
drwxr-xr-x.  2 root  root    6 Jun 22  2021 games
drwxr-xr-x.  2 root  root    6 Jun 22  2021 include
drwxr-xr-x.  2 root  root    6 Jun 22  2021 lib
drwxr-xr-x.  3 root  root   17 Apr 12 16:09 lib64
drwxr-xr-x.  2 root  root    6 Jun 22  2021 libexec
drwxr-xr-x   9 mysql mysql 129 Jun 28 15:43 mysql
drwxr-xr-x.  2 root  root    6 Jun 22  2021 sbin
drwxr-xr-x.  5 root  root   49 Apr 12 16:09 share
drwxr-xr-x.  2 root  root    6 Jun 22  2021 src


添加环境变量
[root@10 local]# ls mysql/
bin  docs  include  lib  LICENSE  man  README  share  support-files
[root@10 local]# echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
[root@10 local]# source /etc/profile.d/mysql.sh


映射文件
[root@10 mysql]# ln -s /usr/local/mysql/include /usr/include/mysql

配置lib库
[root@10 mysql]# vi /etc/ld.so.conf.d/mysql.conf
/usr/local/mysql/lib

[root@10 mysql]# vi /etc/man_db.conf


建立数据存放目录
[root@10 ~]# mkdir -p /opt/data
[root@10 ~]# chown -R mysql.mysql /opt/data
drwxr-xr-x 2 mysql mysql  6 Apr 21 16:02 data


初始化数据库
[root@10 ~]# mysqld --initialize --user mysql --datadir /opt/data

2022-06-28T08:12:04.648395Z 0 [Warning] TIMESTAMP w