comp.lang.ruby

7stud --

3/26/2008 7:00:00 PM

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/InstallingJavaTomcatMySQ...

which refer to the mysql installation instructions here:

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

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...


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-....