Bug #53044 incorrect installation of msql 5.1.45 x 64 dmg on Mac OS X 10.5.8

• Submitted: 22 Apr 2010 2:58
• Modified: 27 Apr 2010 3:24
• Reporter: Omar Musaev
• Status: Not a Bug
• Category: MySQL Server: Installing
• Severity: S1 (Critical)
• Version: 5.1.45
• OS: MacOS
• CPU Architecture: Any

[22 Apr 2010 2:58] Omar Musaev

Description:
I installed 5.1.45 version of MySQL : mysql-5.1.45-osx10.5-x86_64

THen I followed instructions in ReadMe to start a demon:see below copy of terminal:

c-phys-459377TU9GU:~ omar$ cd /
kc-phys-459377TU9GU:/ omar$ cd usr/local/mysql
kc-phys-459377TU9GU:mysql omar$ sudo ./bin/mysqld_safe
Password:
100421 21:27:52 mysqld_safe Logging to '/usr/local/mysql-5.1.45-osx10.5-x86_64/data/kc-phys-459377TU9GU.err'.
100421 21:27:52 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql-5.1.45-osx10.5-x86_64/data
^Z
[1]+  Stopped                 sudo ./bin/mysqld_safe
kc-phys-459377TU9GU:mysql omar$ bg
[1]+ sudo ./bin/mysqld_safe &
kc-phys-459377TU9GU:mysql omar$ logout

[Process completed]

THEN tried to connect to mysql according to instructions of README:(terminal output below)

c-phys-459377TU9GU:/ omar$ usr/local/mysql/bin/mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
kc-phys-459377TU9GU:/ omar$ 

THEN I checked for /tmp/mysql.sock
NONEI checked the process in the background (for daemon):

phys-459377TU9GU:/ omar$ ps -f
  UID   PID  PPID   C     STIME TTY           TIME CMD
  502 65681 65679   0   0:00.01 ttys000    0:00.02 -bash
kc-phys-459377TU9GU:/ omar$ 

THEN I INSTALLED Netbeans 6.8 and started MySQL from there:
I was able to start server to create a database and to make a connection. Form Neatbeans I was able execute commands: create tables etc.

How to repeat:
Just follow instructions for installation in the README for Mac OS 10.5.8   mysql-5.1.45-osx10.5-x86_64/data

[22 Apr 2010 11:32] Valeriy Kravchuk

What if you will not execute that last

logout

command? I am sure mysqld_safe and mysqld processes will continue to run, as I start them this way every day. Please, check.

[22 Apr 2010 17:27] Omar Musaev

mysqld was running, that was the reason. I used top and it showed all processes including mysqld. I killed it and repeated the procedure and it work OK. For the newbe it was confusing. Also, ps shows the processes belonging to the user, so top should be used.

[26 Apr 2010 17:13] Valeriy Kravchuk

So, do you see any bug in MySQL code or not?

[26 Apr 2010 21:56] Omar Musaev

No, it is OK. Should I remove the post or it stays there?