本地安装
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.30-1.el8.x86_64.rpm-bundle.tar --- 将MySQL软件下载到虚拟机
tar xvf mysql-8.0.30-1.el8.x86_64.rpm-bundle.tar --- 对下载下来的压缩包进行解压
dnf localinstall mysql-community-server-8.0.30-1.el8.x86_64.rpm \
mysql-community-client-8.0.30-1.el8.x86_64.rpm \
mysql-community-common-8.0.30-1.el8.x86_64.rpm \
mysql-community-icu-data-files-8.0.30-1.el8.x86_64.rpm \
mysql-community-client-plugins-8.0.30-1.el8.x86_64.rpm \
mysql-community-libs-8.0.30-1.el8.x86_64.rpm ---- 存在多个依赖包,需要手动全部进行安装
[root@localhost ~]# systemctl start mysqld --- 启动数据库服务
[root@localhost ~]# systemctl status mysqld --- 查看数据库状态
[root@localhost ~]# mysql -uroot -p
Enter password: --- 本地安装需要过滤密码
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@localhost ~]# grep password /var/log/mysqld.log --- 过滤密码
mysql> show databases; --- 没有修改密码无法对数据库进行操作
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!'; --- 使用此命令对密码进行修改,之后退出重新登陆
[root@localhost ~]# mysql -uroot -pMKD
mysql> show databases; --- 此时,就可以对数据库进行操作访问了
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql>
源码安装
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-boost-8.0.29.tar.gz ---- 下载网络源码
groupadd mysql --- 创建MySQL的组(默认存在)
useradd -r -g mysql -s /bin/false mysql --- 创建MySQL的用户
tar zxvf mysql-VERSION.tar.gz ---- 对下载的压缩包进行解压
cd mysql-VERSION --- 将目录切换到解压之后的目录下
mkdir bld --- 创建bld文件
cd bld --- 切换到bld文件下
yum install cmake gcc-toolset-11-gcc gcc-toolset-11-gcc-c++ gcc-toolset-11-binutils openssl-devel ncurses-devel libtirpc-devel -y ---- 安装需要的软件
rpm -i rpcgen-1.3.1-4.el8.x86_64.rpm --- 安装所需要软件
cmake .. -DWITH_BOOST=../boost/boost_1_77_0/
make ########该过程平均4个小时 ########
make install
make;make install
等编译安装完成
cd /usr/local/mysql
mkdir mysql-files
chown mysql:mysql mysql-files
chmod 750 mysql-files
bin/mysqld --initialize --user=mysql
bin/mysql_ssl_rsa_setup
bin/mysqld_safe --user=mysql &