I have a problem with running mysql server. I've just installed FreeBSD 10.3 and I want to run here MySQL server, but process doesn't starts.Here are all commands i gave after install FreeBSD, step-by-step:portsnap fetch extractpkg updatepkg install mysql57-server/* Here mysql says about .mysql_secret file with password to root, but it's not generating at all. I can use but there is no result... */find / -iname .mysql_secretWhen I try to first run MySQL using this command:mysqld_safe --initialize --user=mysqlI get this one:mysqld_safe Logging to '/var/db/mysql/host.err'mysqld_safe Starting mysqld deamon with databases from /var/db/mysqlmysqld_safe mysqld from pid file /var/db/mysql/host.pid endedHere you are /var/db/mysql/host.err2016-08-22T11:56:27.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql2016-08-22T11:56:27.533572Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.2016-08-22T11:56:27.533635Z 0 [ERROR] Aborting2016-08-22T11:56:27.6NZ mysqld_safe mysqld from pid file /var/db/mysql/host.pid endedI found something simmilar:https://forums.freebsd.org/threads/56275/https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=209512There is still no solution. Any ideas? I really need MySQL. I have tried with MySQL 5.6 too. Same problem...At the end /usr/local/etc/mysql/my.cnf# $FreeBSD: branches/2016Q3/databases/mysql57-server/files/my.cnf.sample.in 414707 2016-05-06 14:39:59Z riggs $[client]port                            = 3306socket                          = /tmp/mysql.sock[mysql]prompt                          = \u@\h [\d]>\_no_auto_rehash[mysqld]user                            = mysqlport                            = 3306socket                          = /tmp/mysql.sockbind-address                    = 127.0.0.1basedir                         = /usr/localdatadir                         = /var/db/mysqltmpdir                          = /var/db/mysql_tmpdirslave-load-tmpdir               = /var/db/mysql_tmpdirsecure-file-priv                = /var/db/mysql_securelog-bin                         = mysql-binlog-output                      = TABLEmaster-info-repository          = TABLErelay-log-info-repository       = TABLErelay-log-recovery              = 1slow-query-log                  = 1server-id                       = 1sync_binlog                     = 1sync_relay_log                  = 1binlog_cache_size               = 16Mexpire_logs_days                = 30default_password_lifetime       = 0enforce-gtid-consistency        = 1gtid-mode                       = ONsafe-user-create                = 1lower_case_table_names          = 1explicit-defaults-for-timestamp = 1myisam-recover-options          = BACKUP,FORCEopen_files_limit                = 32768table_open_cache                = 16384table_definition_cache          = 8192net_retry_count                 = 16384key_buffer_size                 = 256Mmax_allowed_packet              = 64Mquery_cache_type                = 0query_cache_size                = 0long_query_time                 = 0.5innodb_buffer_pool_size         = 1Ginnodb_data_home_dir            = /var/db/mysqlinnodb_log_group_home_dir       = /var/db/mysqlinnodb_data_file_path           = ibdata1:128M:autoextendinnodb_temp_data_file_path      = ibtmp1:128M:autoextendinnodb_flush_method             = O_DIRECTinnodb_log_file_size            = 256Minnodb_log_buffer_size          = 16Minnodb_write_io_threads         = 8innodb_read_io_threads          = 8innodb_autoinc_lock_mode        = 2skip-symbolic-links[mysqldump]max_allowed_packet              = 256Mquote_namesquick
mysqld_safe not starting after install MySQL 5.7.13 port in FreeBSD/amd64 10.3 using pkg
freebsd;mysql
Finally I found solution myself:cd /var/db/mysql #IMPORTANT STEP/usr/local/libexec/mysqld --initialize --user=mysql #SECOND IMPORTANT STEPecho mysql_enable=YES >> /etc/rc.confservice mysql-server startmysql -u root -p (here password randomly generated from the terminal)and so on...