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.
Did the server start and could you connect ?
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.
1) Have the mysql daemon running 2) connect with a client
[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
there is an error.log in the data directory. Look there for mysql's complaints.
HERE I HIT RETURN TO GET THE PROMPT AGAIN (Should I have typed the name of the database here, then hit return?)
no
You are mixing up the server and client process.
mysqld is the server. It runs in the background and stores databases in it's data directory. There can be many separate databases.
You'll select one of them later when you connect with the client.
mysql <-- no d (=daemon) is the textmode client that comes with the mysql package.
[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)
Without running server-process there is no socket to connect to.
start by looking at the err-file in the data-dir.
You can run mysqld_save without the & to see more output. Sometimes the server comes up that way. Then you wont regain access to the shell where you ran mysqld_save.
I had a hard time getting this kind of error.
One day I figured out, that mc caused the hick-up. mc is a textmode filemanager I really use often.
mysqld started and died at once again.
If mc produces this effect then perhaps other filemanaging tools do, too. Use pure bash or xterm.
Better yet, install mysql as a service to have it started at boot time.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]