在mac osx10.6下安装mysql后，启动总是报错ERROR 2002 (HY000): Can't connect to local MySQL ser

0 0

在mac osx10.6下安装mysql后，启动总是报错ERROR 2002 (HY000): Can't connect to local MySQL ser5

要在mac10.6下安装mysql以便rails开发，装了两天都没有成功。之前没用过mac或linux开发，一直用windows，所以希望高手们能指点一下。
我在安装时参考了以下文章：
http://beike.iteye.com/blog/617341
http://hqman.iteye.com/blog/258979
下面是我的安装过程及错误：
安装和初始化mysql

port search mysql
sudo port install mysql5-server
###########################################################
# A startup item has been generated that will aid in
# starting mysql5-server with launchd. It is disabled
# by default. Execute the following command to start it,
# and to cause it to launch at startup:
#
# sudo port load mysql5-server
###########################################################
--->  Installing mysql5-server @5.1.50_0
******************************************************
* In order to setup the database, you might want to run
* sudo -u _mysql mysql_install_db5
* if this is a new install
******************************************************
--->  Activating mysql5-server @5.1.50_0
--->  Cleaning mysql5-server

sudo  /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/opt/local/lib/mysql5/bin/mysqladmin -u root password 'new-password'
/opt/local/lib/mysql5/bin/mysqladmin -u root -h bogon password 'new-password'

Alternatively you can run:
/opt/local/lib/mysql5/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /opt/local ; /opt/local/lib/mysql5/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /opt/local/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /opt/local/lib/mysql5/bin/mysqlbug script!

配置mysql：
开机自动启动mysql

sudo  launchctl load -w  /Library/LaunchDaemons/org.macports.mysql5.plist

启动mysql
如果要快捷启动，则要先设置aliases，再用aliases来启动：
mate ~/.profile打开这个配置文件，输入以下内容：

alias mysqlstart='sudo /opt/local/bin/mysqld_safe5 &'  
alias mysqlstop='/opt/local/bin/mysqladmin5 -u root -p shutdown'

启动mysql

mysqlstart
[1] 62478

如果没有设置aliases，则用以下命令来启动
/opt/local/share/mysql5/mysql/mysql.server start

验证mysql安装成功：

mysqladmin5 -u root -p ping
error: 'Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/opt/local/var/run/mysql5/mysqld.sock' exists!

或

mysql5 -u root –p
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2)

mate /opt/local/etc/mysql5/my.cnf并输入以下内容（参考http://beike.iteye.com/blog/617341）：

[mysqld_safe]
socket = /tmp/mysql.sock

再调用 mysql5 -u root –p还是报相同错误。

问题补充：

引用

试一下用这个命令能否连接：

mysql5 -u root –p -h 127.0.0.1

我用这个命令就可以连接成功了，但如果不加-h 127.0.0.1就会报我的贴子中的错误，请问是什么原因？通过你提供的命令连接上去的应该也是一样使用的吧？是不是我以后用这个命令来连接就可以啦？

引用

如果能连接，使用这个命令看看socket到底是什么？

show variables like 'socket';

socket是：

mysql> show variables like 'socket';
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| socket        | /tmp/mysql.sock | 
+---------------+-----------------+
1 row in set (0.03 sec)

我调用这个命令得到的结果跟你的一样。

Rails

2010年9月11日 17:04

nepalon
0
0 0 0

3个答案按时间排序按投票排序

0 0

采纳的答案

试一下用这个命令能否连接：

mysql5 -u root –p -h 127.0.0.1

如果能连接，使用这个命令看看socket到底是什么？

show variables like 'socket';

我是直接装的这个：http://www.mysql.com/downloads/mirror.php?id=392754
socket是：

mysql> show variables like 'socket';
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| socket        | /tmp/mysql.sock | 
+---------------+-----------------+
1 row in set (0.03 sec)

2010年9月14日 10:40

isimon
257
0 0 0