Hi,

I have installed a new Ubuntu VM 16.04, installed MySQL 5.7 from Ubuntu repositories and MariaDB using the outline provided in the link https://ubuntuforums.org/showthread.php?t=2391680&p=13765881#post13765881 and got it working.

The problem is stemming from the configuration files. By default, both MariaDB and MySQL read the options from /etc/mysql/my.cnf. A side effect of this is that the MariaDB installation under /opt is reading from /etc/mysql that has the options for MySQL, which is causing all your errors. To get around this you need to use the "--defaults-file=/opt/mariadb-data/my.cnf" option with every MariaDB command.

In the example below, I started MariaDB using systemctl.

# Verify MySQL 5.7 is running

root@ubuntu:/etc/systemd/system# mysqladmin -uroot -p version

...

Server version 5.7.22-0ubuntu0.16.04.1

Protocol version 10

Connection Localhost via UNIX socket

UNIX socket /var/run/mysqld/mysqld.sock

Uptime: 12 min 7 sec

Threads: 1 Questions: 9 Slow queries: 0 Opens: 107 Flush tables: 1 Open tables: 26 Queries per second avg: 0.012

root@ubuntu:/etc/systemd/system#

Start MariaDB:

# systemctl start mariadb

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

...

Server version 10.2.14-MariaDB-log

Protocol version 10

Connection Localhost via UNIX socket

UNIX socket /opt/mariadb-data/mariadb.sock

Uptime: 1 min 18 sec

Threads: 8 Questions: 1 Slow queries: 0 Opens: 17 Flush tables: 1 Open tables: 11 Queries per second avg: 0.012

root@ubuntu:/etc/systemd/system#

To view which option a command has set use "--print-defaults", for example:

root@ubuntu:/etc/mysql# mysqladmin --print-defaults

mysqladmin would have been started with the following arguments:

root@ubuntu:/etc/mysql# mysqladmin --defaults-file=/opt/mariadb-data/my.cnf --print-defaults

mysqladmin would have been started with the following arguments:

--port=3308 --socket=/opt/mariadb-data/mariadb.sock

root@ubuntu:/etc/mysql#

Hope this clarified the matters

Kenneth

On Sat, May 12, 2018 at 10:26 AM, Muhammad Bashir Al-Noimi <mbnoimi@gmail.com> wrote:

On 05/03/2018 05:16 AM, Muhammad Bashir Al-Noimi wrote:
Hi,

I applied exactly the mentioned instructions in MariaDB documentation but unfortunately I always receive the following error message:

# systemctl status mariadb.service
● mariadb.service - LSB: start and stop MariaDB
   Loaded: loaded (/etc/init.d/mariadb; bad; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Thu 2018-05-03 04:54:02 +03; 15min ago
     Docs: man:systemd-sysv-generator(8)
Process: 17145 ExecStart=/etc/init.d/mariadb start (code=exited, status=1/FAILURE)

May 03 04:54:01 domain.com systemd[1]: Starting LSB: start and stop MariaDB...
May 03 04:54:01 domain.com mysqld[17145]: Starting MariaDB
May 03 04:54:01 domain.com mysqld[17145]: .2018-05-03T01:54:01.525119Z mysqld_safe Logging to '/var/lib/mysql/domain.com.err'.
May 03 04:54:01 domain.com mysqld[17145]: 2018-05-03T01:54:01.551305Z mysqld_safe A mysqld process already exists
May 03 04:54:02 domain.com systemd[1]: mariadb.service: Control process exited, code=exited status=1
May 03 04:54:02 domain.com systemd[1]: Failed to start LSB: start and stop MariaDB.
May 03 04:54:02 domain.com systemd[1]: mariadb.service: Unit entered failed state.
May 03 04:54:02 domain.com systemd[1]: mariadb.service: Failed with result 'exit-code'.

How can I fix this issue?

IMPORTANT:

In the attachments you can find "/opt/mariadb-data/my.cnf" AND "/etc/init.d/mariadb files"

Ubuntu Linux 16.04.2 x64

Downloaded mariadb-10.2.14-linux-x86_64.tar.gz
-- 
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
Guys, may I get some help here. I'm unable to bypass this issue since days weeks!

I posted a full format version of this issue in ubuntu forums too:
https://ubuntuforums.org/showthread.php?t=2391680&p=13765881#post13765881

-- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp