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 < [email protected]> 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 : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
