Mysql CLI gone in Bitrock open source 4.5.0?

[laserted]

Ok, could be a newbie issue, but I can no longer get the mysql CLI to connect to the Sugar database - I used the Bitrock installer (complete with the LAMP stack) to start a new machine that I'm also attempting to install ZuckerDocs onto (I do so love that add-in!). Unfortunately, when I try to open a mysql prompt, it states: "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" Of course, since I can't run SQL scripts, I can't create the tables, and thus the remainder of the Zuckerdocs installation fails. I'm doing this all with root priviledges. Is there another connection that must be made? Firewall is off, hosts tables lookup correctly.....no weird routing or forwarding going on here...

Thoughts?

Ted.

[prismusa]

I've got the same problem.

Installed OpenSuse 10.1 fresh.
Downloaded the 4.5.0d Bitrock install of the rest of the LAMP stack.
Trying to restore a mysqldump from another machine but CLI returns same error.

Somebody help?

[kpit]

First is mysql service running second where is mysql.sock located. if it is not in the default location you must set that in php.ini to the correct location. you can find its location in my.cnf file for mysql.

[laserted]

Ok, first - Sugar does run fine, so wouldn't that preclude that the sockets paths are ok? Anyways, my.cnf states that mysql.sock is located at /var/lib/mysql/mysql.sock
/etc/php.ini has no entries for mysql.default_port, mysql.default_socket, mysql.default_host, mysql.default_user, mysql.defualt_password, and safe_mode = Off.

How much needs to get changed, and aside from the socket patch, what is that information going to be?

Thanks,

Ted.