VPS侦探论坛

标题: mysql不可写 [打印本页]

作者: shaitou 时间: 2011-5-3 01:13
标题: mysql不可写
数据不可写把数据目录设为 777 就出错请问怎么回事呢谢谢

作者: licess 时间: 2011-5-3 08:07
什么错误提示？
发一下/usr/local/mysql/var/主机名.err 的错误日志

作者: jingkoo 时间: 2011-5-3 08:40
你看看是不是没有空间了吧，我第一安装的时候也是，用root用户登录mysql都不能创建数据库，权限什么都都查看了，弄了好久最后才发现是空间不够了，你用df -h看看你磁盘信息吧！

作者: shaitou 时间: 2011-5-3 12:47
我设置的时候没有设置日志请问在什么地方修改

作者: shaitou 时间: 2011-5-3 15:01
我的是服务器空间不是问题

作者: shaitou 时间: 2011-5-3 15:19
110503 21:36:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110503 21:36:15 [Note] Event Scheduler: Loaded 0 events
110503 21:36:15 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
110503 21:36:16 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

110503 21:36:16 [Note] Event Scheduler: Purging the queue. 0 events
110503 21:36:16 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110503 21:36:16 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
110503 21:36:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110503 21:36:18 [Note] Event Scheduler: Loaded 0 events
110503 21:36:18 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
110503 21:36:18 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

110503 21:36:18 [Note] Event Scheduler: Purging the queue. 0 events
110503 21:36:18 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110503 21:36:18 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
110503 21:41:54 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110503 21:41:54 [Note] Event Scheduler: Loaded 0 events
110503 21:41:54 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
110503 21:41:56 mysqld_safe A mysqld process already exists

作者: licess 时间: 2011-5-3 16:40
日志里已经说了，已经有一个mysql再运行，ps aux你自己看一下

欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/)