错误日志:
2026-10-09T06:14:32.668751Z mysqld_safe Logging to syslog.
2026-10-09T06:14:32.701369Z mysqld_safe Starting mysqld daemon with databases from /www/server/data
2026-10-09T06:14:33.253649Z mysqld_safe mysqld from pid file /run/mysqld/mysqld.pid ended
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Starting mysqld (via systemctl): mysqld.serviceJob for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.
failed!根据日志分析:
1,Mysqld应该是运行起来了,pid也存在,但是立马“ended”。
2,当service mysql start时,mariadb.service failed,应该有冲突。
我这里是直接卸载了mariadb
apt-get remove --purge mariadb-server mariadb-client
rm -rf /etc/mysql /var/lib/mysql /run/mysqld/mysqld.sock
/www/server/mysql/bin/mysqld_safe --user=mysql &卸载之后,msyql服务依然不能启动。
报错日志:
2026-10-09T06:52:37.537763Z mysqld_safe Logging to '/www/server/data/LZ-182-0.err'.
2026-10-09T06:52:37.573902Z mysqld_safe Starting mysqld daemon with databases from /www/server/data
2026-10-09T06:52:38.124991Z mysqld_safe mysqld from pid file /www/server/data/LZ-182-0.pid ended初始化后,再次重启Mysql服务
su - mysql -c "/www/server/mysql/bin/mysqld --initialize-insecure --user=mysql --datadir=/www/server/data"
/www/server/mysql/bin/mysqld_safe --user=mysql &报错没有mysql用户权限
su: warning: cannot change directory to /home/mysql: No such file or directory创建msyql用户
useradd -r -s /bin/false mysql
mkdir -p /home/mysql
chown mysql:mysql /home/mysql
chmod 755 /home/mysql
/www/server/mysql/bin/mysqld_safe --user=mysql &此时可以启动了,但是会提示链接失败
[Note] Access denied for user 'root'@'localhost' (using password: NO)当root用户登录时密码不正确,继续修改密码
pkill -9 mysqld 2>/dev/null
/www/server/mysql/bin/mysqld_safe --skip-grant-tables --user=mysql &
sleep 5
/www/server/mysql/bin/mysql -u root -e "UPDATE mysql.user SET authentication_string=PASSWORD('xxxx') WHERE User='root'; FLUSH PRIVILEGES;"
/www/server/mysql/bin/mysql -u root -p -e "SELECT VERSION();"输入密码,回车。显示版本号时,服务已经可以正常启动了。