Problema instalar o mysql no pfsense

leandruco

Instalei o mysql com o commando:
pkg_add -r http://ftp-archive.freebsd.org/pub/FreeBSD-Archive/old-releases/amd64/8.1-RELEASE/packages/All/mysql-server-5.5.4.tbz

Tudo ocorre normal, mando instalar o serviço ele n aprensenta erro, porem quando vou tentar conectar apresenta o seguinte erro:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

No log do mysql dentro de /var/db/mysql
Aprenseta o seguinte conteúdo:
130513 18:53:52 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
130513 18:53:52 [Note] Buffered information: Performance schema disabled (reason: start parameters).

130513 18:53:52 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/libexec/mysqld: Table 'mysql.plugin' doesn't exist
130513 18:53:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
130513 18:53:52 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130513 18:53:52 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130513 18:53:52 InnoDB 1.1.0 started; log sequence number 1595687
130513 18:53:52 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
130513 18:53:52 mysqld_safe mysqld from pid file /var/db/mysql/pfsense.localdomain.pid ended

Alguem sabe me dizer como arrumar isso?

Estou tentendo configurar o PF+Radius+Captive portal desse tuto aqui http://forum.pfsense.org/index.php/topic,57260.msg305604.html#msg305604
Porem desda primeira parte está dando erro.

marcelloc

Já tentou executar o que o erro sugere?

 Please run mysql_upgrade to create it.

leandruco

Sim,
Já havia tentado, segue o erro

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed