MySQL安装

Zz.17

已于 2023-02-08 14:49:38 修改

阅读量132

点赞数

文章标签： mysql 数据库 linux

于 2023-02-08 14:43:37 首次发布

本文链接：https://blog.youkuaiyun.com/m0_60040684/article/details/128931525

版权

仓库安装

[root@localhost ~]# rpm -ivh  https://repo.mysql.com//mysql80-community-release-el9-1.noarch.rpm     从官方网站下载仓库文件
[root@localhost ~]# cat /etc/fstab   把挂载信息写入/etc/fstab这个文件中，添加最后一行

#
# /etc/fstab
# Created by anaconda on Tue Feb  7 12:14:00 2023
#
# Accessible filesystems, by reference, are maintained under '/dev/disk/'.
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info.
#
# After editing this file, run 'systemctl daemon-reload' to update systemd
# units generated from this file.
#
/dev/mapper/rhel_192-root /                       xfs     defaults        0 0
UUID=bd5389bd-8393-45c7-a776-857203b42661 /boot                   xfs     defaults        0 0
/dev/mapper/rhel_192-swap none                    swap    defaults        0 0
/dev/sr0 /mnt iso9660 defaults,_netdev 0 0
[root@localhost ~]# cat /etc/yum.repos.d/rhel9.repo  切换到yum源仓库配置目录
[base]
name=baseos
baseurl=file:///mnt/BaseOS
gpgcheck=0

[App]
name=AppStream
baseurl=file:///mnt/AppStream
gpgcheck=0
[root@localhost ~]# mount /dev/sr0 /mnt  挂载
[root@localhost ~]# dnf install mysql-server -y  安装
[root@localhost ~]# systemctl start mysqld  开启mysql服务
[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log 查看临时密码
[root@localhost ~]# mysql -uroot -p  登录mysql，-u指定用户，-p指定密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Admin117?';  登录之后必须先修改用户密码
mysql> exit
Bye
[root@localhost ~]# mysql -uroot -pAdmin117?  退出后使用新密码进入


mysql> show databases;  查看数据库
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

本地安装

[root@localhost ~]# mkdir mysql
[root@localhost ~]# cd mysql/
[root@localhost mysql]# wget  https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.32-1.el9.x86_64.rpm-bundle.tar   下载
[root@localhost mysql]# tar xvf mysql-8.0.32-1.el9.x86_64.rpm-bundle.tar  解压
[root@localhost mysql]# rpm -ivh mysql-community-server-8.0.32-1.el9.x86_64.rpm mysql-community-client-8.0.32-1.el9.x86_64.rpm  mysql-community-common-8.0.32-1.el9.x86_64.rpm mysql-community-icu-data-files-8.0.32-1.el9.x86_64.rpm   mysql-community-client-plugins-8.0.32-1.el9.x86_64.rpm  mysql-community-libs-8.0.32-1.el9.x86_64.rpm  安装
[root@localhost mysql]# systemctl start mysqld
[root@localhost mysql]# grep 'temporary password' /var/log/mysqld.log
[root@localhost mysql]# mysql -uroot -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Admin117?';  
mysql> exit
Bye
[root@localhost ~]# mysql -uroot -pAdmin117?  


mysql> show databases;  
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

容器安装

[root@localhost ~]# yum remove docker \  如果有旧版先卸载旧版
docker-client \
docker-client-latest \
docker-common \
docker-latest \
docker-latest-logrotate \
docker-logrotate \
docker-engine

[root@localhost ~]# dnf install -y yum-utils device-mapper-persistent-data lvm2  安装
[root@localhost ~]# yum-config-manager --add-repo https://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo  添加仓库

[root@localhost ~]# sed -i 's+download.docker.com+mirrors.aliyun.com/docker-ce+' /etc/yum.repos.d/docker-ce.repo
[root@localhost ~]# dnf install docker-ce --allowerasing -y  安装
[root@localhost ~]# systemctl start docker  启动服务
[root@localhost ~]# docker version  查看容器版本
[root@localhost ~]# docker run --name mysqltest -e MYSQL_ROOT_PASSWORD=123456 -d mysql  运行，设置密码
[root@localhost ~]# docker exec -it mysqltest /bin/bash  进入容器
bash-4.4# mysql -uroot -p  输入密码

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> exit  退出SQL
Bye
bash-4.4# exit  退出容器
exit
[root@localhost ~]#

源码安装

上传下载好的文件
[root@localhost ~]# yum -y install lrzsz
[root@localhost ~]# rpm -qa lrzsz  检查是否安装成功
lrzsz-0.12.20-55.el9.x86_64
[root@localhost ~]# mkdir mysql-source
[root@localhost ~]# cd mysql-source/  
[root@localhost mysql-source]# rz  上传到此目录下
[root@localhost mysql-source]# ll -h  查看是否上传成功
total 417M
-rw-r--r--. 1 root root 417M Feb  6 22:59 mysql-boost-8.0.32.tar.gz

输入rz后会有弹窗，找到要上传的文件即可上传

[root@localhost ~]# groupadd mysql
[root@localhost ~]# useradd -r -g mysql -s /bin/false mysql  添加用户和组
[root@localhost ~]# tar xvf mysql-boost-8.0.32.tar.gz  解压
[root@localhost mysql-source]# ll
total 425992
drwxr-xr-x. 32 7161 31415      4096 Dec 16 10:59 mysql-8.0.32
-rw-r--r--.  1 root root  436207624 Feb  6 22:59 mysql-boost-8.0.32.tar.gz
[root@localhost mysql-source]# cd mysql-8.0.32/
[root@localhost mysql-8.0.32]# ls
boost           components       Doxyfile-ignored   include              libchangestreams  man            packaging  run_doxygen.cmake  sql-common     testclients
client          config.h.cmake   Doxyfile.in        INSTALL              libmysql          mysql-test     plugin     scripts            storage        unittest
cmake           configure.cmake  doxygen_resources  libbinlogevents      libservices       MYSQL_VERSION  README     share              strings        utilities
CMakeLists.txt  Docs             extra              libbinlogstandalone  LICENSE           mysys          router     sql                support-files  vio
[root@localhost mysql-8.0.32]# yum install gcc gcc-c++ cmake -y  安装编译器
[root@localhost mysql-8.0.32]# yum install   cmake gcc-toolset-12-gcc gcc-toolset-12-gcc-c++ gcc-toolset-12-binutils openssl-devel ncurses-devel libtirpc rpcgen git  -y
[root@localhost mysql-8.0.32]# rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/centos-stream/9-stream/CRB/x86_64/os/Packages/libtirpc-devel-1.3.3-0.el9.x86_64.rpm
[root@localhost mysql-8.0.32]# mkdir bld
[root@localhost mysql-8.0.32]# cd bld
[root@localhost bld]# cmake .. -DWITH_BOOST=../boost/boost_1_77_0/
[root@localhost bld]# make   该过程耗费时间长
[root@localhost bld]# make install
[root@localhost mysql]# cd /usr/local/mysql
[root@localhost mysql]# mkdir mysql-files
[root@localhost mysql]# chown mysql:mysql mysql-files
[root@localhost mysql]# chmod 750 mysql-files
[root@localhost mysql]# bin/mysqld --initialize --user=mysql
[root@localhost mysql]# bin/mysql_ssl_rsa_setup
[root@localhost mysql]# bin/mysqld_safe --user=mysql &
[root@localhost mysql]# grep 'temporary password' /var/log/mysqld.log
[root@localhost mysql]# ./bin/mysql -uroot -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Admin117?';  
mysql> exit
Bye

[root@localhost ~]# mysql -uroot -pAdmin117?  

mysql> show databases;  
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)