Thank you very much for your quick replies by the way.
Since this is a test box, I'll run the zmmyinit:
* Creating required directories
* Generating mysql config /opt/zimbra/conf/my.cnf
* Creating database in /opt/zimbra/db/data
* Starting mysql server
* Failed to connect to mysql...retrying
* Failed to connect to mysql...retrying
* Failed to connect to mysql...retrying
* Failed to connect to mysql...retrying
* Failed to connect to mysql...retrying (just repeats)
* Failed to connect to mysql...giving up!
zimbra@green:~/libexec$ mysql.server start
mysqld_safe already running with pid 6369
Is it running? I think so...
zimbra@green:~/libexec$ ps -ef | grep [s]ql
zimbra 3928 1 0 Sep11 ? 00:00:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.logger.cnf --ledir=/opt/zimbra/logger/mysql/libexec
zimbra 3991 3928 0 Sep11 ? 00:00:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.logger.cnf --basedir=/opt/zimbra/logger/mysql --datadir=/opt/zimbra/logger/db/data --pid-file=/opt/zimbra/logger/db/mysql.pid --skip-external-locking --port=7307 --socket=/opt/zimbra/logger/db/mysql.sock
zimbra 6333 1 0 Sep11 pts/0 00:00:00 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.cnf --ledir=/opt/zimbra/mysql/libexec
zimbra 6369 6333 0 Sep11 pts/0 00:00:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.cnf --basedir=/opt/zimbra/mysql --datadir=/opt/zimbra/db/data --pid-file=/opt/zimbra/db/mysql.pid --skip-external-locking --port=7306 --socket=/opt/zimbra/db/mysql.sock  |