Re: LINUX - Configuring multiple instance without using a standalone database.
After founding a typo error in cfg_2.cnf, here new screen log :
-----------------------------------
linux-my-server-yast2:~ # systemctl start mysqld@2
linux-my-server-yast2:~ # systemctl status mysqld@2
mysqld@2.service - MySQL Multi Server for instance 2
Loaded: loaded (/etc/systemd/system/mysqld@.service; enabled)
Active: failed (Result: exit-code) since Wed 2015-01-21 19:58:18 CET; 4s ago
Process: 5296 ExecStop=/usr/bin/mysqld_multi --log=/var/log/mysql/mysql_multi.log stop %i (code=exited, status=0/SUCCESS)
Process: 5275 ExecStart=/usr/bin/mysqld_multi --defaults-file=/etc/mysql/cfg_%i.cnf --log=/var/log/mysql/mysql_multi.log --verbose start %i (code=exited, status=0/SUCCESS)
Main PID: 5281 (code=exited, status=1/FAILURE)
Jan 21 19:58:18 linux-my-server-yast2 systemd[1]: Started MySQL Multi Server for instance 2.
Jan 21 19:58:18 linux-my-server-yast2 systemd[1]:
mysqld@2.service: main process exited, code=exited, status=1/FAILURE
Jan 21 19:58:18 linux-my-server-yast2 systemd[1]: Unit
mysqld@2.service entered failed state.
linux-my-server-yast2:~ #
-------------------------------------------------
Thank you for helping
___________________________________________________________________________________________
SAMBA-LDAP PDC server - opensuse 12.3 KDE - MYSQL 5.6 -- asus R900V desktop 12.3 KDE & WINXP on Virtualbox -- HP DV9350 desktop 12.3 KDE -- acer aspire 7736g win 7 pro - scanner EPSON V500 - Brother HL2150N - Samsung CLP-325W