Directadmin cannot create DB user on FreeBSD 9.1 with MySQL 5.6

[wattie]

When I go to add new database I get:

Unable to add user <xxx>. Lost connection to MySQL server during query

It shouldn't be related to timeout:

mysql> SHOW VARIABLES LIKE '%timeout%';
+-----------------------------+----------+
| Variable_name               | Value    |
+-----------------------------+----------+
| connect_timeout             | 10       |
| delayed_insert_timeout      | 300      |
| innodb_flush_log_at_timeout | 1        |
| innodb_lock_wait_timeout    | 50       |
| innodb_rollback_on_timeout  | OFF      |
| interactive_timeout         | 300      |
| lock_wait_timeout           | 31536000 |
| net_read_timeout            | 30       |
| net_write_timeout           | 60       |
| slave_net_timeout           | 3600     |
| wait_timeout                | 300      |
+-----------------------------+----------+
11 rows in set (0.00 sec)

The mysql error log is full of these messages:

2013-04-13 20:12:11 86bfe5c00 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-04-13 20:12:11 86bfe5c00 InnoDB: Error: Fetch of persistent statistics requested for table "<DB>"."<TABLE>" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

I tried this fix (which is shown as "for windows machine" but anyway...) but it did not resolve the issue with creating new user. The errors above stopped...

 

[wattie]

During install:

Installing mysql-5.6.10-freebsd9.1-x86_64.tar.gz...
mysql-5.6.10-freebsd9.1-x86_64/data/test/dummy.bak: Cannot extract through symlink mysql-5.6.10-freebsd9.1-x86_64/data
mysql-5.6.10-freebsd9.1-x86_64/data/mysql/dummy.bak: Cannot extract through symlink mysql-5.6.10-freebsd9.1-x86_64/data
tar: Error exit delayed from previous errors.

Anyway, after reinstall the issue is fixed.

DirectAdmin support should make a test just in case.