Thanks a lot Kenneth,

On 05/15/2018 12:09 PM, Kenneth Penza wrote:

Good morning Muhammad,

I have checked and I am using your mariadb.service file. For some reason, mariadb is failing to start. We need to determine if the issue is coming from systemd or something in MariaDB datadir.

To start it without systemd, run:

/opt/mariadb/bin/mysqld --defaults-file=/opt/mariadb-data/my.cnf &

When I called the above mariadb worked as shown below so the problem definitely in my mariadb.service file

# /opt/mariadb/bin/mysqld --defaults-file=/opt/mariadb-data/my.cnf &
[1] 3415
# 2018-05-15 12:37:37 140672642451264 [Note] /opt/mariadb/bin/mysqld (mysqld 10.2.14-MariaDB-log) starting as process 3415 ...

The below should work:

/opt/mariadb/bin/mysqladmin --defaults-file=/opt/mariadb-data/my.cnf -uroot -p version

# /opt/mariadb/bin/mysqladmin --defaults-file=/opt/mariadb-data/my.cnf -uroot -p version
Enter password:
/opt/mariadb/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

/opt/mariadb/bin/mysqladmin --defaults-file=/opt/mariadb-data/my.cnf -uroot -p shutdown

# /opt/mariadb/bin/mysqladmin --defaults-file=/opt/mariadb-data/my.cnf -uroot -p shutdown
Enter password:
/opt/mariadb/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

Strangely!!!

I passed the correct password of Ubuntu's root user!

-- 
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi