cnetos源码安装mysql8.0.18，启动mysql.server报错解决

阿里云国内75折回扣微信号：monov8

阿里云国际，腾讯云国际，低至75折。AWS 93折免费开户实名账号代冲值优惠多多微信号：monov8 飞机：@monov6

linux系统contos 7
mysql源码包mysql-8.0.18.tar.xz

1.创建一个mysql用户
# useradd -M -s /sbin/nologin mysql

2.解压mysql源码包
# tar -xvf mysql-8.0.18.tar.xz

3.创建mysql安装目录
# mkdir -p /usr/local/mysql

4.将解压后的mysql全部文件移动到/usr/local/mysql目录
# mv /usr/local/src/mysql-8.0.18-linux-glibc2.12-x86_64/* /usr/local/mysql/

5.创建mysql的数据存放目录
# mkdir -p /usr/local/mysql/data

6.修改mysql目录权限目录属主属组都是mysql用户
# chown -R mysql:mysql /usr/local/mysql

7.初始化mysql数据库注这里会生成一个mysql的root用户登录密码密码先记下来后面登录mysql需要用到
# ./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

8.添加环境变量
# vim ~/.bash_profile
在这一行后面添加上mysql的这个/usr/local/mysql/bin目录
PATH=$PATH:$HOME/bin:/usr/local/nginx/sbin:/usr/local/mysql/bin
# source ~/.bash_profile

9.设置mysql开机启动
# cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/
# chmod a+x /etc/init.d/mysql.server
# chkconfig mysql.server on

Tips
配置好脚本文件后便可以用 service 命令来管理 mysqld 数据库服务了
例service mysql.server restartservice mysql.server status 等操作。

10.启动mysql.server但是报错了
# /etc/init.d/mysql.server start
报错信息如下
Starting MySQL.2023-01-05T18:30:10.825078Z mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'. ERROR! The server quit without updating PID file (/var/lib/mysql/server.pid).

解决报错
1将/etc/my.cnf删除掉这里是做改名备份也是一样的让改文件不生效即可
# mv /etc/my.cnf /etc/my.cnf.bak
2重新启动mysql.server
# /etc/init.d/mysql.server start
Starting MySQL.Logging to '/usr/local/mysql/data/server.err'.
. SUCCESS!
启动成功

Tips
/etc/my.cnf配置文件是安装系统后就有了的并不是后面安装mysql后生成的所以可能是产生了冲突导致mysql启动失败报错。解决办法将my.cnf文件改个名称备份让它不起作用即可。

11.登录mysql
# mysql -u root -p
登录密码是执行数据库初始化的时候生成的密码

mysql> alter user ‘root’@‘localhost’ identified by ‘QWE123asd’;
mysql> use mysql;
mysql> alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘QWE123asd’;