Can't connect to local MySQL server through sock

fengwenzi

如题:启动mysql时出现如下错误,请教高手该如何解决?(附:系统为:RH AS 3,系统自带的mysql)

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

fengwenzi

我看了精华贴里的内容,关于这个问题出现的很普遍啊,希望哪位高手能帮忙解决.期待中...............

archangle

你看看你的错误日志就明白了.

fengwenzi

现在mysql数据库可以使用了，可又有一个问题出现了
mysql -uroot -pxxx 可以进入mysql,也可以在里面建数据表。
可如果用phpmyadmin连接，就进不去
错误提示：
#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
请教该如何解决这个问题？？期待高手。
顺便将mysqld.log贴出来供大家参考：
050616 15:02:22  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
050616 15:02:22  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
050616 15:02:22  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
050616 15:02:22  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
050616 15:02:23  InnoDB: Started
050616 15:02:23 /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
/usr/local/mysql/bin/mysqld: ready for connections.

fengwenzi

期待高手

goodloveboys

确定那个目录有写的权限

yejr

问题都不难，自己先分析一下吧