Mysql on mac

Ruby
1

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$

many thanks,

Angelo Joseph

2

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

  1. To quit mysql prompt, type:

mysql> exit

  1. To shut down mysql:

$ sudo mysqladmin shutdown

  1. For help, type:

mysql> help