I recently installed mariaDB
I have checked the configuration file /usr/local/etc/mysql/conf.d/server.cnf which returns:
Quick checking for permits
And checking
Anyone have any clue on what could be happening here, I'm a bit stuck at these point.
pkg install mariadb114-server-11.4.2
. I'm trying to run it by service mysql-server start
which prompts Starting mysql. If I try to use service mysql-server status
it prompts mysql is not running..I have checked the configuration file /usr/local/etc/mysql/conf.d/server.cnf which returns:
Code:
...
[mysqld]
user = mysql
# port = 3306 # inherited from /usr/local/etc/mysql/my.cnf
# socket = /var/run/mysql/mysql.sock # inherited from /usr/local/etc/mysql/my.cnf
bind-address = 127.0.0.1
basedir = /usr/local
datadir = /var/db/mysql
net_retry_count = 16384
log_error = /var/db/mysql/mysqld.err
...
ls -l /var/db/
returns drwxr-xr-x 6 mysql mysql 15 Aug 21 09:36 mysql
.And checking
ls -l /var/db/mysql/
for the file mysqld.err reports:
Code:
total 379
-rw-rw---- 1 mysql mysql 417792 Aug 21 09:36 aria_log.00000001
-rw-rw---- 1 mysql mysql 52 Aug 21 09:36 aria_log_control
-rw-r----- 1 mysql mysql 782 Aug 21 09:36 ib_buffer_pool
-rw-rw---- 1 mysql mysql 100663296 Aug 21 09:36 ib_logfile0
-rw-rw---- 1 mysql mysql 12582912 Aug 21 09:36 ibdata1
-rw-r--r-- 1 mysql mysql 14 Aug 21 09:36 mariadb_upgrade_info
drwx------ 2 mysql mysql 90 Aug 21 09:36 mysql
drwx------ 2 mysql mysql 3 Aug 21 09:36 performance_schema
drwx------ 2 mysql mysql 107 Aug 21 09:36 sys
drwx------ 2 mysql mysql 3 Aug 21 09:36 test
-rw-rw---- 1 mysql mysql 10485760 Aug 21 09:36 undo001
-rw-rw---- 1 mysql mysql 10485760 Aug 21 09:36 undo002
-rw-rw---- 1 mysql mysql 10485760 Aug 21 09:36 undo003