Mac OS 10.4.4 Tiger Server update broke mysql

[afterhoursc]

a new working install of OSC was just getting fleshed out when I broke it this pm. We were tracking a mail server issue where mail would not be sent from a VH domain when one used the 'recommend this product' feature.

 

noting that 10.4.4 had been released a few weeks ago, I ran the update. Now, I get

 

Warning: mysql_connect(): Access denied for user 'customer'@'localhost' (using password: YES)

 

on different pages. Apple has one KB post about this that I've found:

 

http://docs.info.apple.com/article.html?artnum=302977

 

but it hasn't helped as our directories appear intact and proper.

 

Has anyone experienced (and fixed) this?

 

thx

[Mediajuggle]

you should try posting on the Apple forums at Apple.com as well. Between these two sites, you're bound to get an answer.

[AlanR]

After updating to Mac OS X 10.4.4, you may find that the connection between PHP and MySQL running on your local webserver is broken.

 

Apparently the socket file got moved in the update. You can make it start working again by entering the following commands in a Terminal window:

 

$ sudo mkdir /var/mysql

$ sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

 

http://www.macosxhints.com/article.php?sto...060111113313511

 

Go read the thread, there is more than one solution.

[afterhoursc]

http://www.macosxhints.com/article.php?sto...060111113313511

 

Go read the thread, there is more than one solution.

 

Yes, I have read both that and the two apple kb entries. I've followed the apple instructs to the letter (for the more secure method, as we aren't using unexpected builds). I note that in phpmyadmin, it acts as though it is a clean install -- none of the existing databases are there. Yet if I ls in term, I see datafiles with content in

 

/var/mysql/

 

along with the mysql.sock file.

 

But I also see another dir /var/mysql/mysql/ with a number of small (<12 kb) files, such as columns.priv.frm, dolumns.priv.MYD, columns_priv.MYI and more.

 

phpmysql doesn't show any of the formerly-existing databases.

 

 

any other ideas?

[AlanR]

I don't run a local version so I don't have any ideas of my own. I just remembered reading that 10.4.4 broke the install (for good reason).

[ccubed_99]

have you tried checking really obvious things like the configure php's...? I would say in the past most of the problems were resolved there for me.