Bug #36520 Unable to run mySQL on MAC OS X 10.5

• Submitted: 5 May 2008 22:20
• Modified: 6 May 2008 6:06
• Reporter: Mirage P
• Status: Not a Bug
• Category: MySQL Server: Command-line Clients
• Severity: S1 (Critical)
• Version: 5.0.51a
• OS: MacOS (10.5)
• CPU Architecture: Any
• Tags: connect, Error 2002, hy000

[5 May 2008 22:20] Mirage P

Description:
Unable to start mysql prompt using Terminal window. 

Here's my outputs:

$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

$ mysql -uroot -p --socket=/tmp/mysql.sock
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

$ sudo mysqld_safe -uroot
Password:
Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/mehul-patels-macbook-pro.local.pid
080505 15:18:42  mysqld ended

How to repeat:
Start up Terminal window
type, mysql -u root
and it gives the above mentioned error.

[5 May 2008 22:22] Mirage P

Can's start mySQL to run

[6 May 2008 6:06] Sveta Smirnova

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

$ sudo mysqld_safe -uroot
Password:
Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/mehul-patels-macbook-pro.local.pid
080505 15:18:42  mysqld ended

means MySQL server is not running. Add log-error option to the configuration file and examine why.