MySQL安装故障解决

mysql故障：[root@MYSQL_M ~]# /etc/init.d/mysqld restartStarting MySQL....... ERROR！ Manager of pid-file quit without updating file.[root@MYSQL_M ~]#可能一：启动配置文件/etc/init.d/mysqld 中的basedir和datadir目录没有指定，默认找安装目录去了。需要就需要指定datadir的目录。上面两个目录应该为初始化数据库时候指定的基础目录和数据目录。例如我的初始化目录为下面的命令。/application/mysql/bin/mysql_install_db --basedir=/application/mysql --datadir=/data --user=mysql所以我修改为：vim /etc/init.d/mysqld 46 basedir=/application/mysql 47 datadir=/data可能二mysqld的数据目录属主不是MYSQL，或者uid不对。也就是上面中的data目录的属主不对。修改为相同的属主即可。chown -R mysql.mysql /data可能三是mysql下的tmp目录权限问题。导致无法创建socket.日志中报下面的错误：151105 13:42:49 InnoDB: Started; log sequence number 0 44233151105 13:42:49 [ERROR] Can"t start server : Bind on unix socket: Permission denied151105 13:42:49 [ERROR] Do you already have another mysqld server running on socket: /application/mysql5.1.72/tmp/mysql.sock ？151105 13:42:49 [ERROR] Aborting查看/application/mysql/tmp权限问题[root@MYSQL_S ~]# ll /application/mysql/total 32drwxr-xr-x 2 root root 4096 Nov 5 09:32 bindrwxr-xr-x 3 root root 4096 Nov 4 23:55 includedrwxr-xr-x 3 root root 4096 Nov 4 23:55 libdrwxr-xr-x 2 root root 4096 Nov 4 23:55 libexecdrwxr-xr-x 10 root root 4096 Nov 4 23:55 mysql-testdrwxr-xr-x 6 root root 4096 Nov 4 23:55 sharedrwxr-xr-x 5 root root 4096 Nov 4 23:55 sql-benchdrwxr-xr-x 2 root root 4096 Nov 5 13:25 tmp[root@MYSQL_S ~]#发现/application/mysql/tmp这个目录的属主是root了。但是这个目录的属主本应该是mysql，也就是你用下面命令初始化数据库时指定的用户名/application/mysql/bin/mysql_install_db --basedir=/application/mysql --datadir=/data --user=mysql所以授权为mysql即可[root@MYSQL_S ~]# chown mysql /application/mysql/tmp/[root@MYSQL_S ~]# /etc/init.d/mysqld start Starting MySQL. SUCCESS！[root@MYSQL_S ~]#本文永久更新链接地址