Issues with MySQL

Question

Issues with MySQL

I cannot connect to MySQL 5 through Dreamweaver CS3 after upgrading to Leopard. I get the "MySQL Error#: 2002" error which states "Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2). Had no problems at all in Tiger. Does MySQL 5 actually support Leopard?

PowerMac G5 Dual 2.5Ghz, 1.5GB RAM, 23" Apple Cinema Display, Mac OS X (10.5), - www.CMIWebStudio.com

Posted on Oct 31, 2007 9:56 PM

Reply

Answer 1

Tuttle

Level 7

29,541 points

Oct 31, 2007 10:28 PM in response to Jonny Apple Seed

Does MySQL 5 actually support Leopard?

Yes.

See if the information in this MySQL bug report is helpful.

Reply

Answer 2

Nov 3, 2007 10:06 AM in response to Jonny Apple Seed

I had the same problem. I installed MySQL5+server via MacPort.

Mainly because "/opt/local/var/db/mysql5/: No such file or directory", & "Permission denied"

What is the proper Permission setting of this directory?

cd /opt/local ; /opt/local/lib/mysql5/bin/mysqld_safe &
[1] 434
mediters-powerbook-g4-12:local mediter$ touch: /opt/local/var/db/mysql5/mediters-powerbook-g4-12.local.err: Permission denied
chown: /opt/local/var/db/mysql5/mediters-powerbook-g4-12.local.err: No such file or directory
Starting mysqld daemon with databases from /opt/local/var/db/mysql5
/opt/local/lib/mysql5/bin/mysqld_safe: line 380: /opt/local/var/db/mysql5/mediters-powerbook-g4-12.local.err: Permission denied
/opt/local/lib/mysql5/bin/mysqld_safe: line 386: /opt/local/var/db/mysql5/mediters-powerbook-g4-12.local.err: Permission denied
STOPPING server from pid file /opt/local/var/db/mysql5/mediters-powerbook-g4-12.local.pid
tee: /opt/local/var/db/mysql5/mediters-powerbook-g4-12.local.err: Permission denied
071104 01:01:26 mysqld ended
tee: /opt/local/var/db/mysql5/mediters-powerbook-g4-12.local.err: Permission denied

Message was edited by: &#38589

Reply