472,143 Members | 1,819 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,143 software developers and data experts.

Can't connect to local MySQL question

Hi,

I've been writing software on the mac since 1987, but am brand new at
unix/php/mysql, and that's where I'm headed so I'm reading everything I can
get my hands on, but like anything else there's going to be a learning
curve, that having been said...

I followed the install instructions at http://entropy.ch , and was able to
get mySql & php installed on my G4 -> (OSX 10.2.6) last night. I downloaded
Navicat and setup a password for the mysql user. I created a connection
called myDatabase_connection to a database called myDatabase. I was able to
get everything running OK.

Today when I restarted the machine, I tried to launch the php program that I
was running last night, and kept getting an error 2002 below.

Could someone take a look at the syntax below and see if you could spot what
I am doing wrong?

Thank you very much...

Bill Hernandez


Last login: Sat Aug 9 20:00:07 on console
Welcome to Darwin!
[Home:~] justMe% su
Password:

[Home:/Users/justMe] justMe# cd /usr/local/mysql
[Home:/usr/local/mysql] justMe# chown -R mysql data/
[Home:/usr/local/mysql] justMe# echo
[Home:/usr/local/mysql] justMe# ./bin/mysqld_safe &
[1] 479
[Home:/usr/local/mysql] justMe# Starting mysqld daemon with databases from
/usr/local/mysql/data
030809 20:04:58 mysqld ended

HERE I HIT RETURN TO GET THE PROMPT AGAIN (Should I have typed the name of
the database here, then hit return?)

[1] Done ./bin/mysqld_safe
[Home:/usr/local/mysql] justMe# ./bin/mysql myDatabase
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

[Home:/usr/local] justMe# cd /

[Home:/] justMe# /usr/local/mysql/bin/mysql myDatabase
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

[Home:/] justMe# mysql myDatabase
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

[Home:/] justMe#
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1233

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by webhead74 | last post: by
1 post views Thread by Peter Nikolaidis | last post: by
reply views Thread by Bill Hernandez | last post: by
2 posts views Thread by B Squared | last post: by
5 posts views Thread by scorpionbilli | last post: by
reply views Thread by Saiars | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.