首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >XAMPP/MYSQL - MySQL意外关闭

XAMPP/MYSQL - MySQL意外关闭
EN

Stack Overflow用户
提问于 2019-12-28 19:16:25
回答 1查看 882关注 0票数 1

所以昨天我在做我的项目,一切都很顺利,所以我就睡着了。我醒来,做了我的事情,当我试图运行apache和mysql (通过xampp)时,apache确实启动了,但mysql显示如下错误:

代码语言:javascript
复制
Error: MySQL shutdown unexpectedly.
[mysql]     This may be due to a blocked port, missing dependencies, 
[mysql]     improper privileges, a crash, or a shutdown by another method.
[mysql]     Press the Logs button to view error logs and check
[mysql]     the Windows Event Viewer for more clues
[mysql]     If you need more help, copy and post this
[mysql]     entire log window on the forums

从昨天开始我什么都没做,所以我不知道哪里出了问题。此外,我还检查了Windows事件查看器,并得出了以下结果:

代码语言:javascript
复制
Warning
Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem. 

Error (this one repeats itself couple of times)
Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593  

Error
Failed to create a new master info file (file 'D:\Programs\xampp\mysql\data\master-2019@002d12@002d27@002020@003a50@003a29@00209@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005clsslspd@005cwqhndjvxchcv_users@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info', errno 2)

Error
Initialized Master_info from 'master-2019@002d12@002d27@002020@003a50@003a29@00209@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005clsslspd@005cwqhndjvxchcv_users@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' failed

Error
Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593 

Error
Failed to create a new master info file (file 'D:\Programs\xampp\mysql\data\master-2019@002d12@002d27@002022@003a53@003a23@0020125@0020@005bwarning@005d@0020aborted@0020connection@0020125@0020to@0020db@003a@0020@0027lsslspd@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info', errno 2)

最后两个错误交替重复4次(但值略有不同)

你们能帮我解决这个问题吗?我不想丢失我所有的数据。已尝试重新安装和复制mysql->数据的内容,但不起作用。

EN

回答 1

Stack Overflow用户

发布于 2020-07-25 04:35:55

mysql未启动的情况下,检查是否存在xampp/mysql/data/multi-master.info文件,并将其删除。这对我很有效。

票数 5
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/59510380

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档