ERROR! MariaDB is running but PID file could not be found

在CentOS7.6上安装了MariaDB10.3,采用的yum方式安装的,用命令查看数据库的状态会报错误

[root@centos7 ~]# service mysql status
 ERROR! MariaDB is running but PID file could not be found

在配置文件/etc/my.cnf中增加一行,pid_file=/var/lib/mysql/centos7.pid
然后在查询mysql的状态,正常!

[root@centos7 ~]# service mysql status
 SUCCESS! MariaDB running (3867)
姚远ACE CSDN认证博客专家 ACE 华为云 MVP
Oracle ACE,华为云 MVP,Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890;获得过两次国家部级科技进步奖;发明过两项计算机专利。微信:yaoyuanace 邮箱:yaoyuanace(at)qq.com
已标记关键词 清除标记
相关推荐
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页