MySQL on Ubuntu Woes

[Tom Metro]

Chris O'Connell wrote:
> So, I create the /var/run/mysqld directory (which is not present on boot)
> and set the permissions and then I can start mysqld.  The problem is that
> when I reboot the /var/run/mysqld directory is missing.

/var/run is a ramdisk, and thus goes away on reboot.


> When I try to run mysqld I get an error about the following missing
> file: /var/run/mysqld/mysqld.sock

This should be created automatically when mysqld starts, if so
configured. Are you sure you are seeing this complaint from mysqld and
not from a mysql client?

Can you post relevant portions of your /etc/mysql/my.cnf, which should
include lines like:

[mysqld]
socket          = /var/run/mysqld/mysqld.sock

[client]
socket          = /var/run/mysqld/mysqld.sock


 -Tom

-- 
Tom Metro
Venture Logic, Newton, MA, USA
"Enterprise solutions through open source."
Professional Profile: http://tmetro.venturelogic.com/