I ran mysqltuner.pl (as zimbra user) on my Zimbra server (8.0.2 on Ubuntu 10.04) and one of its recommendations is to run OPTIMIZE TABLE. I figure this won't hurt (right?), so I want to do it. However, when I run "mysqlcheck -o --all-databases" as user zimbra, I get the error:
Sorry to be such a n00b. What am I doing wrong? How can I accomplish this?
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect