无法创建测试文件 /var/lib/mysql/Daniil-Myasnikovs-MacBook-Pro.lower-test

发布于 2024-12-01 14:01:39 字数 606 浏览 4 评论 0原文

我的环境：

Mac Snow Leopard 10.6.8 MySQL Ver 14.14 Distrib 5.5.8，适用于 osx10.6 (i386)，使用 readline 5.1

我一直在使用这个版本，直到我尝试在其上安装 MAMP。之后我停止了MySQL服务器，现在我无法再次启动它。在终端中，它给我回信：

  110825 17:09:04 [Warning] Can't create test file /var/lib/mysql/Daniil-Myasnikovs-MacBook-Pro.lower-test
  110825 17:09:04 [Warning] Can't create test file /var/lib/mysql/Daniil-Myasnikovs-MacBook-Pro.lower-test
  mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)
  110825 17:09:04 [ERROR] Aborting

  110825 17:09:04 [Note] mysqld: Shutdown complete

如果您能帮我解决这个问题，那将非常有帮助，非常感谢。

原文

My environment:

Mac Snow Leopard 10.6.8
MySQL Ver 14.14 Distrib 5.5.8, for osx10.6 (i386) using readline 5.1

I was using this version until I tried to install MAMP on top of that. After that I have stoped MySQL server, and now I can't start it again. In terminal it writes me back:

  110825 17:09:04 [Warning] Can't create test file /var/lib/mysql/Daniil-Myasnikovs-MacBook-Pro.lower-test
  110825 17:09:04 [Warning] Can't create test file /var/lib/mysql/Daniil-Myasnikovs-MacBook-Pro.lower-test
  mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)
  110825 17:09:04 [ERROR] Aborting

  110825 17:09:04 [Note] mysqld: Shutdown complete

If you can give me a hand with this, that would be more than helpful, thank you very much.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

情场扛把子 2024-12-08 14:01:39

您是否检查过目录 /var/lib/mysql 确实存在并且与您的数据目录相对应？
如果没有，那么您可能必须另外指定 mysqld 部分下的 datadir 参数

[mysqld]
datadir=/var/lib/mysql

Have you checked that the directory /var/lib/mysql does actually exist and corresponds to your data directory?
If it does not, then you probably must specify otherwise the datadir parameter under the mysqld section