Linux MySQL参数及MySQL主从 79-15

tech2025-10-24  5

DAY-15j笔记 1.1 MySQL的启动报错 启动MariaDB报错信息如下: Systemctl restart mariadb.service Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details.

解决方法:查看错误日志:journalctl –xe 查看端口是否被占用:netstat -tnlp|grep 3306 最终的判断,MYSQL进程已经存在,无法启动Mariadb,解决方法,停止原来的MYSQL服务; MYSQL最常见的报错信息 Redirecting to /bin/systemctl restart mariadb.service Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) 解决方法: 使用journalctl –xe查看MYSQL错误信息; 关闭服务器selinux安全策略,关闭防火墙setenforce 0; 检查MYSQL|Mariadb通过什么样的方式部署的;  检查其配置文件/etc/my.cnf,datadir数据目录是

最新回复(0)