From: 7stud -- <bbxx789_05ss@...>
Date: 2008-03-27T03:59:39+09:00
Subject: Re: mysql on mac.

Angelo Joseph wrote:
> I installed my sql on my mac tiger and tried to run it but i keep
> getting the error message below and i've looked everywhere but there
> seems to be no solution for this can anyone shed any light. ?
> 
> angelojoseph:~ angelojoseph$ mysql
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> angelojoseph:~ angelojoseph$
> 
> 

I used the instructions here:

http://www.benslade.com/projects/java/tomcat/InstallingJavaTomcatMySQLOnMacOSX/

which refer to the mysql installation instructions here:

http://dev.mysql.com/doc/refman/5.0/en/mac-os-x-installation.html

which are a little confusing about how to start mysql.


I also used the additional steps here:

http://switch.richard5.net/isp-in-a-box-v2/installing-mysql-on-mac-os-x/


I put /usr/local/mysql/bin in my PATH environment variable(in my 
.bash_profile file).


1) To start, type:

$ cd /usr/local/mysql
$ sudo ./bin/mysqld_safe
(Enter your password, if necessary)
(Press Control-Z)
$ bg    #continue a stopped job in the background--Ctrl+Z stops job?
(Press Control-D or enter "exit" to exit the shell)
To get mysql prompt:
$ mysql -u root

2) To quit mysql prompt, type:

mysql> exit

3) To shut down mysql:

$ sudo mysqladmin shutdown

4) For help, type:

mysql> help
-- 
Posted via http://www.ruby-forum.com/.