MySQL 8.0.45 完整mysqld_safe启动
一、准备工作你已经有包了你的包位置/home/mysql-8.0.45-linux-glibc2.17-x86_64.tar.xz二、正式安装步骤全程复制执行1. 创建安装目录mkdir-p/data/mysoftmkdir-p/data/mysql/mydata/datamkdir-p/data/mysql/mydata/logmkdir-p/data/mysql/mydata/tmp2. 移动并解压安装包mv/home/mysql-8.0.45-linux-glibc2.17-x86_64.tar.xz /data/mysoft/cd/data/mysofttar-xvfmysql-8.0.45-linux-glibc2.17-x86_64.tar.xz3. 创建软链接方便以后升级ln-s/data/mysoft/mysql-8.0.45-linux-glibc2.17-x86_64 /data/mysoft/mysql4. 创建 mysql 用户必须useradd-r-s/sbin/nologin mysql5. 授权目录权限最关键chown-Rmysql:mysql /data/mysqlchmod-R755/data/mysql6. 安装依赖必须yuminstall-ylibaio-devel numactl 7. 初始化 MySQL全新安装才执行/data/mysoft/mysql/bin/mysqld--initialize--usermysql--datadir/data/mysql/mydata/data--basedir/data/mysoft/mysql✔ 执行完会出现临时密码一定要记下来A temporary password is generated for rootlocalhost: xxxxxxxx8. 启动 MySQL/data/mysoft/mysql/bin/mysqld_safe--datadir/data/mysql/mydata/data--basedir/data/mysoft/mysql--usermysql --log-error/data/mysql/mydata/log/error.log--port3306看到下面这句话就是启动成功Starting mysqld daemon9. 登录并修改密码/data/mysoft/mysql/bin/mysql-uroot-p输入刚才的临时密码进入 MySQL 后执行ALTERUSERrootlocalhostIDENTIFIEDBY你的新密码;FLUSHPRIVILEGES;exit10. 配置 systemd 开机自启可选但推荐vi/etc/systemd/system/mysql.service写入以下内容[Unit] DescriptionMySQL Server Afternetwork.target [Service] Usermysql Groupmysql ExecStart/data/mysoft/mysql/bin/mysqld_safe --datadir/data/mysql/mydata/data --basedir/data/mysoft/mysql Restarton-failure [Install] WantedBymulti-user.target启动并设置开机自启systemctl daemon-reload systemctlenablemysql systemctl start mysql✅ 安装完成你现在的 MySQL版本8.0.45路径/data/mysoft/mysql数据目录/data/mysql/mydata/data数据安全、不丢失、不冲突