Re: Problem with MySQL 5 on OS X Tiger
Hello. Some tips from the manual could be helpful. See: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html http://dev.mysql.com/doc/refman/5.0/en/starting-server.html untz wrote: Hello there, I just downloaded the MySQL 5 Community Edition for OS X Tiger... Ran the installer and it installed everything to /usr/local/ ... Updated my .bash_profile by creating a MYSQL_HOME variable and appending that MYSQL_HOME/bin to the PATH variable... Now, the problem is that when I try to check my installation by typing mysql, I receive an ERROR message... Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Here's my .bash_profile: Raven:~ untz$ cat .bash_profile . ~/.profile AXIS_HOME=/Developer/axis-1_3; AXIS_LIB=$AXIS_HOME/lib; AXISCLASSPATH=$AXIS_LIB/axis.jar:$AXIS_LIB/commons-discovery.jar: $AXIS_LIB/commons-logging.jar:$AXIS_LIB/jaxrpc.jar:$AXIS_LIB/saaj.jar: $AXIS_LIB/log4j-1.2.8.jar:$AXIS_LIB/xml-apis.jar:$AXIS_LIB/ xercesImpl.jar; JAVA_HOME=/System/Library/frameworks/JavaVM.framework/Versions/1.5.0/ Home; J2EE_HOME=/Developer/JavaTools/j2sdkee1.3.1; J2ME_HOME=/Developer/JavaTools/j2me_wireless_toolkit2.2; CATALINA_HOME=/Developer/JavaTools/tomcat/jakarta-tomcat-5.5.9; MYSQL_HOME=/usr/local/mysql CLASSPATH=.:$J2EE_HOME/lib/j2ee.jar:$CATALINA_HOME/common/lib/ servlet-api.jar:$CATALINA_HOME/common/lib/jsp-api.jar:/Developer/ Database/hsqldb/lib/hsqldb.jar; PATH=$PATH:$JAVA_HOME/bin:$J2EE_HOME/bin:$J2ME_HOME/bin:/usr/local/ bin:/opt/local/bin:$MYSQL_HOME/bin; VIMRUNTIME=/Applications/Vim.app/runtime; export AXIS_HOME AXIS_LIB AXISCLASSPATH JAVA_HOME J2ME_HOME J2EE_HOME CATALINA_HOME MYSQL_HOME PATH VIMRUNTIME bash Can anyone tell me what possibly I am doing wrong? Many, many thanks! -Unnsse -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with MySQL 5 on OS X Tiger
Hello there, I just downloaded the MySQL 5 Community Edition for OS X Tiger... Ran the installer and it installed everything to /usr/local/ ... Updated my .bash_profile by creating a MYSQL_HOME variable and appending that MYSQL_HOME/bin to the PATH variable... Now, the problem is that when I try to check my installation by typing mysql, I receive an ERROR message... Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Here's my .bash_profile: Raven:~ untz$ cat .bash_profile . ~/.profile AXIS_HOME=/Developer/axis-1_3; AXIS_LIB=$AXIS_HOME/lib; AXISCLASSPATH=$AXIS_LIB/axis.jar:$AXIS_LIB/commons-discovery.jar: $AXIS_LIB/commons-logging.jar:$AXIS_LIB/jaxrpc.jar:$AXIS_LIB/saaj.jar: $AXIS_LIB/log4j-1.2.8.jar:$AXIS_LIB/xml-apis.jar:$AXIS_LIB/ xercesImpl.jar; JAVA_HOME=/System/Library/frameworks/JavaVM.framework/Versions/1.5.0/ Home; J2EE_HOME=/Developer/JavaTools/j2sdkee1.3.1; J2ME_HOME=/Developer/JavaTools/j2me_wireless_toolkit2.2; CATALINA_HOME=/Developer/JavaTools/tomcat/jakarta-tomcat-5.5.9; MYSQL_HOME=/usr/local/mysql CLASSPATH=.:$J2EE_HOME/lib/j2ee.jar:$CATALINA_HOME/common/lib/ servlet-api.jar:$CATALINA_HOME/common/lib/jsp-api.jar:/Developer/ Database/hsqldb/lib/hsqldb.jar; PATH=$PATH:$JAVA_HOME/bin:$J2EE_HOME/bin:$J2ME_HOME/bin:/usr/local/ bin:/opt/local/bin:$MYSQL_HOME/bin; VIMRUNTIME=/Applications/Vim.app/runtime; export AXIS_HOME AXIS_LIB AXISCLASSPATH JAVA_HOME J2ME_HOME J2EE_HOME CATALINA_HOME MYSQL_HOME PATH VIMRUNTIME bash Can anyone tell me what possibly I am doing wrong? Many, many thanks! -Unnsse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with MySQL 5 on OS X Tiger
Hi Unnsse, Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can anyone tell me what possibly I am doing wrong? The message you are getting is saying that there is no socket file at /tmp/mysql.sock -- This is where the server will create it's socket file by default. It is an indication that your MySQL Server is in fact installed, but simply not started. If my memory serves me correctly the OSX Installer package includes a System Preferences module. Try opening your system prefs and looking for a MySQL button in the Other section. That control panel applet should allow you to easily start the server. Otherwise, running the following command should suffice: sudo mysqld_safe --user=mysql Once you have been prompted for your sudo password you can background the process by press Ctrl-Z and then entering the command bg to the shell. I hope this helps, Kind Regards, -- Lachlan Mulcahy, Support Engineer MySQL AB, Melbourne, Australia Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with MySQL 5 on OS X Tiger
Lachlan Mulcahy wrote: Hi Unnsse, Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can anyone tell me what possibly I am doing wrong? The message you are getting is saying that there is no socket file at /tmp/mysql.sock -- This is where the server will create it's socket file by default. It is an indication that your MySQL Server is in fact installed, but simply not started. If my memory serves me correctly the OSX Installer package includes a System Preferences module. Try opening your system prefs and looking for a MySQL button in the Other section. That control panel applet should allow you to easily start the server. Otherwise, running the following command should suffice: sudo mysqld_safe --user=mysql Once you have been prompted for your sudo password you can background the process by press Ctrl-Z and then entering the command bg to the shell. I hope this helps, Kind Regards, That will work, but I find it simpler when starting manually to run `sudo -v` to get prompted for my password, then `sudo mysqld_safe ` to start mysql. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]