cubieboard mysql_a20装mysql有问题

本帖最后由 ergoli 于 2013-6-23 11:48 编辑

mysql在启动时报错，死循环，反复启动关闭，查看/var/log/mysql/error.log  启动错误日志如下

.....

130623 10:22:04 [Note] Plugin 'FEDERATED' is disabled.

130623 10:22:04 InnoDB: The InnoDB memory heap is disabled

130623 10:22:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins

130623 10:22:04 InnoDB: Compressed tables use zlib 1.2.7

130623 10:22:04 InnoDB: Using Linux native AIO

130623 10:22:04 InnoDB: Initializing buffer pool, size = 128.0M

130623 10:22:05 InnoDB: Completed initialization of buffer pool

130623 10:22:05 InnoDB: highest supported file format is Barracuda.

130623 10:22:05  InnoDB: Waiting for the background threads to start

130623 10:22:06 InnoDB: 1.1.8 started; log sequence number 1595675

130623 10:22:06 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306

130623 10:22:06 [Note]   - '127.0.0.1' resolves to '127.0.0.1';

130623 10:22:06 [ERROR] Failed to create a socket for IPv4 '127.0.0.1': errno: 13.

130623 10:22:06 [ERROR] Can't create IP socket: Permission denied

130623 10:22:06 [ERROR] Aborting

130623 10:22:06  InnoDB: Starting shutdown...

130623 10:22:07  InnoDB: Shutdown completed; log sequence number 1595675

130623 10:22:07 [Note] /usr/sbin/mysqld: Shutdown complete

130623 10:22:08 [Note] Plugin 'FEDERATED' is disabled.

.........

查看/etc/mysql/my.cnf中关于socket的设置

socket = /var/run/mysqld/mysqld.sock

查看对应目录/var/run/mysqld/没有文件创建

且权限为：

drwxr-xr-x  2 mysql root  40 Jun 23 10:39 .

drwxr-xr-x 16 root  root 640 Jun 23 10:39 ..

通过chmod -R 777 /var/run/mysqld修改权限，ls后确认修改成功：

drwxrwxrwx  2 mysql root  40 Jun 23 10:39 .

drwxr-xr-x 16 root  root 640 Jun 23 10:39 ..

reboot重启后/var/run/mysqld目录的权限又变为：

drwxr-xr-x  2 mysql root  40 Jun 23 10:39 .

drwxr-xr-x 16 root  root 640 Jun 23 10:39 ..

mysqld目录应该是在mysql启动时自动新建的，不一定存在权限问题，

只好怀疑是网络配置问题，痛苦中。。。

ps：刷完后已经扩过nand了，否则mysql装不上的