Welcome to WebmasterWorld Guest from 3.231.226.211

Forum Moderators: bakedjake

Message Too Old, No Replies

mysqld ended Can't get mysql running

     
11:56 pm on Jul 16, 2003 (gmt 0)

New User

10+ Year Member

joined:July 11, 2003
posts:34
votes: 0


A few months back I managed to get Apache, PHP, mysql and phpmyAdmin all running nicely on a G4 running OS 10.2.6. It didn't seem like a big deal. Today I have been unable to get mysql running...

first I confirmed the usr and group accounts for mysql... all was well

then I downloaded the mysql standard 4.0.13 and ran the installer...

then at terminal
cd /usr/local/mysql
sudo ./scripts/mysql_install_db... this looked like it worked...plenty of information came by, including an admonishment to change password for root...then some more commands at the terminal

sudo chown -R mysql:mysql data....
sudo ./bin/safe_mysqld --user=mysqld &

it reports back
Starting mysqld daemon with databases from /usr/local/mysql/data
030716 16:10:49 mysqld ended

something sure doesn't seem right

4:11 am on July 17, 2003 (gmt 0)

Junior Member

10+ Year Member

joined:Oct 8, 2002
posts:65
votes: 0


tail /var/log/mysql/mysqld.log

?

5:00 am on July 17, 2003 (gmt 0)

Full Member

10+ Year Member

joined:Dec 9, 2002
posts:325
votes: 0


Check the user permissions and ownership on /var/lib/mysql (ls -al /var/lib/mysql) (or the data directory if you have specified it manually)

The files should be set to be readable user mysql.

1:06 am on July 18, 2003 (gmt 0)

New User

10+ Year Member

joined:July 11, 2003
posts:34
votes: 0


Those /var paths don't do anything on a mac. After stumbling around all day, I went ahead and did a clean system install and retraced my steps. PHP, Apache, mySql, phpMyAdmin all working perfectly in about 30 minutes flat.

I am guessing that what went wrong was that I attempted to install mySql on top of a version of mySql which was running and that none of the recovery steps posted could save the mess.

Unless someone pipes in with a better suggestion, my reaction to this problem in the future will be the clean install.... it takes less than an hour and so compares very favorably with the day and a half I spent trying to recover.

1:12 pm on Aug 1, 2003 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member 10+ Year Member

joined:Aug 1, 2003
posts:815
votes: 0

I had this problem on my iMac 1GHz running MySQL 4.x under Mac OS X 10.2 (Jaguar).

Marc Liyanage's "Cleanup Instructions for old MySQL versions" fixed the trouble. He's got a little shell script that deletes all the old MySQL files that might mess things up.

Glad I didn't have to do a system reinstall...

This URL:
http://www.entropy.ch/software/macosx/mysql/remove-old-mysql.html