标题: Can't connect to local MySQL server through sock [打印本页] 作者: fengwenzi 时间: 2005-06-16 10:39 标题: Can't connect to local MySQL server through sock 如题:启动mysql时出现如下错误,请教高手该如何解决?(附:系统为:RH AS 3,系统自带的mysql)
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)作者: fengwenzi 时间: 2005-06-16 11:13 标题: Can't connect to local MySQL server through sock 我看了精华贴里的内容,关于这个问题出现的很普遍啊,希望哪位高手能帮忙解决.期待中...............作者: archangle 时间: 2005-06-16 13:16 标题: Can't connect to local MySQL server through sock 你看看你的错误日志就明白了.作者: fengwenzi 时间: 2005-06-17 14:20 标题: Can't connect to local MySQL server through sock 现在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 时间: 2005-06-18 16:37 标题: Can't connect to local MySQL server through sock 期待高手作者: goodloveboys 时间: 2005-06-18 18:17 标题: Can't connect to local MySQL server through sock 确定那个目录有写的权限作者: yejr 时间: 2005-06-18 21:31 标题: Can't connect to local MySQL server through sock 问题都不难,自己先分析一下吧