With connection to my problem I ran the phpinfo.php, and found this under the mysql section:
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.39
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE
MYSQL_LIBS
Directive Local Value Master Value
mysql.allow_persistent On On
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
I don't know if this is a live update of the system, but I had version mysql-standard-4.0.15 of mysql installed, plus I finally got fed up and deleted everything including the /tmp/mysql.sock but it still registers it.
Is there a problem there? Is there another version I don't know about?
In the terminal window it keeps saying,:
connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
the sock did exist, the book I read said I should do the permissions thing immediately, but I didn't I switched off my computer and tried to do it another day. Could this be the problem?
If this helps understand the problem then great, thanks.
Rob Snow
On Thursday, November 20, 2003, at 09:21 PM, Ken Menzel wrote:
Hi Rob, My guess would be you did not see this in the Fine Manual http://www.mysql.com/doc/en/Post-installation.html or this http://www.mysql.com/doc/en/Starting_server.html
Hope this helps, Ken ----- Original Message ----- From: "Rob Snow" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 20, 2003 6:15 AM Subject: Errors with MySQL
Dear MySQL
Firstly, let me say, I am very new to this. Secondly, I have been reading Larry Ullman's book PHP and MySQL to get started.
I have installed PHP fine, and it is working well. I have followed the instructions for MySQL and it has installed a folder in my: usr/local/ folder called mysql-standard-4.0.15-apple-darwin6.4-powerpc with a shortcut to this folder called mysql.
The book I'm reading states I should do the following to set permissions: cd /usr/local/mysql sudo echo sudo bin/mysqld_safe &
I do this and I get this result: Last login: Thu Nov 20 10:44:51 on ttyp1 Welcome to Darwin! [Rob-Snows-Computer:~] robsnow% cd /usr/local/mysql [Rob-Snows-Computer:/usr/local/mysql] robsnow% sudo echo Password:
[Rob-Snows-Computer:/usr/local/mysql] robsnow% sudo bin/mysqld_safe & [1] 3254 [Rob-Snows-Computer:/usr/local/mysql] robsnow% Starting mysqld daemon with databases from /usr/local/mysql/data 031120 11:01:23 mysqld ended
[1] Done sudo bin/mysqld_safe [Rob-Snows-Computer:/usr/local/mysql] robsnow% bin/mysqladmin -u root password '•••••••' bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! [Rob-Snows-Computer:/usr/local/mysql] robsnow%
The doesn't have any work arounds to this problem, and I cannot go any further with the tutorials without mySQL running/working. I do a test and I get this result in a browser:
Warning : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) in /Users/robsnow/Sites/mysql_test.php on line 2
Warning : MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) in /Users/robsnow/Sites/mysql_test.php on line 2
Larry Ullman's books states it should have the following result, and he uses the same installer I did:
Last login: Thu Nov 20 10:44:51 on ttyp1 Welcome to Darwin! [Rob-Snows-Computer:~] robsnow% cd /usr/local/mysql [Rob-Snows-Computer:/usr/local/mysql] robsnow% sudo echo Password:
[Rob-Snows-Computer:/usr/local/mysql] robsnow% sudo bin/mysqld_safe & [1] 3254
[Rob-Snows-Computer:/usr/local/mysql] robsnow% bin/mysqladmin -u root password '•••••••' [Rob-Snows-Computer:/usr/local/mysql] robsnow%
For some reason my run states that the mysql has ended, should this be so? Can you please give me any advise on how to check that mySQL is running, how to check the version, and any answers to why I'm getting these errors? I would be most grateful for your assistance.
Rob Snow
Rob Snow "Space may be the final frontier But its made in a Hollywood basement" RHCP 'Californiacation - Californiacation 1999'
[EMAIL PROTECTED] http://homepage.mac.com/robsnow
Rob Snow "Space may be the final frontier But its made in a Hollywood basement" RHCP 'Californiacation - Californiacation 1999'
[EMAIL PROTECTED] http://homepage.mac.com/robsnow
