您现在的位置是:主页 > 数据库技术 > 数据库技术
mysql start失败的解决方法
IDCBT2021-12-28【服务器技术】人已围观
简介这篇文章主要为大家展示了“mysql start失败的解决方法”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“mysql start失败的解决方法”
这篇文章主要为大家展示了“mysql start失败的解决方法”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“mysql start失败的解决方法”这篇文章吧。
mysql start失败的解决办法:1、将原来的数据目录迁移到重新制定的数据目录处;2、执行“chown -R mysql:mysql /mydata/data/”;3、执行“kill -9 进程号”;4、删除mysql-bin。
本文操作环境:Windows7系统,mysql5.5版,Dell G3电脑。
mysql start 失败怎么办?
mysql数据库启动失败
简介:
重启服务器后-->重启应用服务(Confluence)-->报错,数据库连接失败(mysql设置了开机自启动)-->查看mysql数据库状态:
[root@fisheye ~]# ps -ef | grep mysql root 25555 21974 0 11:28 pts/0 00:00:00 grep mysql
启动mysql服务器
[root@fisheye data]# service mysql start MySQL server PID file could not be found![失败] Starting MySQL.............. ERROR! The server quit without updating PID file (/mydata/data/fisheye..pid).[失败]
查看错误日志:
[root@fisheye data]# tail -100 fisheye.err InnoDB: Last MySQL binlog file position 0 337403929, file name ./mysql-bin.000016 141013 1:13:28 InnoDB: Waiting for the background threads to start 141013 1:13:29 InnoDB: 5.5.33 started; log sequence number 1006647152 17:13:29 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help di141013 01:13:29 mysqld_safe mysqld from pid file /mydata/data/fisheye.pid ended
未发现明显性错误提示,所以手动创建一个pid文件试试
[root@fisheye data]# touch /mydata/data/fisheye.pi
再进行重启服务:
[root@fisheye data]# service mysql restart ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)标签:很赞哦! ()