MySQL起不来Can't connect to '/tmp/mysql.sock'

hillstone

我完全是按照mysql的安装说明操作的,步骤如下:
1,从www.mysql.com网站下载mysql-standard_4.1.1-alpha-pc-linux-i686.tar.gz保存在
/home/ydm/soft下
2,解压
shell>; cd /home/ydm/soft
shell>; tar xzvf mysql-standard_4.1.1-alpha-pc-linux-i686.tar.gz
结果在/home/ydm/soft/创建目录/home/ydm/soft/mysql-standard_4.1.1-alpha-pc-linux-i686
3,查看README和INSTALL-BINARY说明文档,我以下的操作是完全按照INSTALL-BINARY执行的
shell>;  groupadd mysql
shell>;  useradd -g mysql mysql
shell>;  cd /usr/local
shell>;  ln -s /home/ydm/soft/mysql-standard_4.1.1-alpha-pc-linux-i686 mysql
shell>;  cd mysql
shell>;  scripts/mysql_install_db
shell>;  chown -R root .
shell>;  chown -R mysql data
shell>;  chgrp -R root .
shell>;  bin/mysqld_safe --user=mysql &
下面是提示
[root@aaa mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data
040109 12:21:20  mysqld ended
于是我又打开一个终端窗口,执行如下操作:
shell>;  cd /usr/local/mysql
shell>;  bin/mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

这时为何?我完全按照说明操作亚

hillstone

040109 11:07:46  /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/aaa.pid' (Errcode: 13)
040109 11:07:46  Fatal error: Can't open privilege tables: Can't open file: 'host.MYI' (errno: 13)
040109 11:07:46  /usr/local/mysql/bin/mysqld: Error on delete of '/usr/local/mysql/data/aaa.pid' (Errcode: 13)
040109 11:07:46  mysqld ended

hillstone

这个问题看来是有点难度,后来我采用rpm包,安装成功,大家需要可以交流

siyeclover

你的mysqld没有起来，原因可能是目录权限不正确。
试试这样。
mysql_install_db
cd /usr/local
chown -R mysql  mysql
chgrp -R mysql  mysql
mysqld_safe --user=mysql &

以上
喜欢魉呼的siyeclover