mysql不可写

shaitou

数据 不可写     把数据目录 设为 777   就 出错   请问  怎么回事呢   谢谢

licess

什么错误提示？
发一下/usr/local/mysql/var/主机名.err 的错误日志

jingkoo

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

shaitou

我设置的时候 没有   设置日志  请问在什么地方修改

shaitou

我的是服务器  空间 不是问题

shaitou

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

日志里已经说了，已经有一个mysql再运行，ps aux你自己看一下