Faild to start mysql.service

English Install/Boot/Login
1

Hi to all,

I’m a new to openSUSE, I’d like to install MySQL server on my openSUSE, after i install mysql-community-server I have to start mysql.service but I got error (code below)
If any solution for my case or if my case is solved be for please provide me the link


khamlek@lekpkd:~> sudo systemctl start mysql.service
root's password:
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -n' for details.
khamlek@lekpkd:~> systemctl status mysql.service
mysql.service - LSB: Start the MySQL database server
          Loaded: loaded (/etc/init.d/mysql)
          Active: failed (Result: exit-code) since Thu, 2013-10-31 16:50:13 ICT; 4min 1s ago
         Process: 19674 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
          CGroup: name=systemd:/system/mysql.service

Oct 31 16:49:43 lekpkd.fglao mysql[19674]: error: Found option without preceding group in config file: /etc/mysql/my....ine: 1
Oct 31 16:49:43 lekpkd.fglao mysql[19674]: Fatal error in defaults handling. Program aborted
Oct 31 16:49:43 lekpkd.fglao mysql[19674]: Will update MySQL now, if you encounter any problems, please read following file:
Oct 31 16:49:43 lekpkd.fglao mysql[19674]: /usr/share/doc/packages/mysql-community-server/README.SuSE
Oct 31 16:49:43 lekpkd.fglao mysql[19674]: Running protected MySQL...
Oct 31 16:50:13 lekpkd.fglao mysql[19674]: error: /var/tmp/mysql-protected.LjT13U/mysql.sock file didn't appeared...
Oct 31 16:50:13 lekpkd.fglao mysql[19674]: Try checking "/var/log/mysql/mysqld-upgrade-run.log"...
Oct 31 16:50:13 lekpkd.fglao mysql[19674]: ..failed
Oct 31 16:50:13 lekpkd.fglao systemd[1]: Failed to start LSB: Start the MySQL database server.
Oct 31 16:50:13 lekpkd.fglao systemd[1]: Unit mysql.service entered failed state
khamlek@lekpkd:~>

Thanks in advance,
HOMSOMBATH Khamlek

ps. My english is so poor

2

There’s something missing here I guess… :wink:

Try to remove that file. Mysql should start then.

3

Hello and welcome to openSUSE!

What have you done before? Have you installed MySQL with YaST or zypper?

4

Also have to done what the error message says and run:
systemctl status mysql.service
which will give you some information about the status of mysql?