FreeBSD 12, Mysql 8 not working

[Shahin 275]

Hello,  i just installed mysql 8, latest update but it is not working. err file attached. thank you very much

discord: Revenge Arena#4229

Quote

2020-04-02T21:08:04.6NZ mysqld_safe Logging to '/var/db/mysql/Metin.err'.
2020-04-02T21:08:04.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2020-04-02T21:08:04.991717Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2020-04-02T21:08:04.991785Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2020-04-02T21:08:04.991832Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2020-04-02T21:08:04.991870Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2020-04-02T21:08:04.996171Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.19) starting as process 11041
2020-04-02T21:08:05.063989Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2020-04-02T21:08:05.264099Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2020-04-02T21:08:05.264229Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2020-04-02T21:08:05.264348Z 1 [ERROR] [MY-012594] [InnoDB] If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2020-04-02T21:08:05.264488Z 1 [ERROR] [MY-012646] [InnoDB] File /var/db/mysql/ibdata1: 'open' returned OS error 71. Cannot continue operation
2020-04-02T21:08:05.264619Z 1 [ERROR] [MY-012981] [InnoDB] Cannot continue operation.
2020-04-02T21:08:05.6NZ mysqld_safe mysqld from pid file /var/db/mysql/Metin.pid ended

 

Edited April 3, 2020 by Shahin

[Shogun 5745]

File /var/db/mysql/ibdata1: 'open' returned OS error 71. Cannot continue operation

 

This file either doesn't exist or is not readable by the user mysql. Check the permissions. Which version of MySQL were you running before?

[Shahin 275]

 

Solved,

i deleted the /var/db/mysql directory

then ->

# sysrc mysql_enable=yes
mysql_enable: yes -> yes
# service mysql-server start
Starting mysql.
# service mysql-server status
mysql is running as pid 25457.

 

Edited April 3, 2020 by Shahin

[Shogun 5745]

I can't stop being in awe that deleting your whole database folder is a solution to something. Does it actually work, besides the service being up?

[Shahin 275]

On 4/3/2020 at 5:43 AM, Shogun said:

I can't stop being in awe that deleting your whole database folder is a solution to something. Does it actually work, besides the service being up?

it was a fresh db so i don't mind. 

The service is up and running until i start the server. after that, it goes down and i can't open it back up only if i reboot the server.

[Shogun 5745]

Check /var/db/mysql/hostname.err

 

Where "hostname" is the hostname of the machine. If you don't know it, use uname -a to find out.