User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

Robot spider for disastersAfter upgrading my OpenSuse to 12.3 I could not start mysql.

# systemctl start mysql.service
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -n' for details.

journalctl -n gave me among others:

Mar 17 05:55:09 gruz systemd[1]: mysql.service: control process exited, code=exited status=1
Mar 17 05:55:09 gruz systemd[1]: Failed to start LSB: Start the MySQL database server.
Mar 17 05:55:09 gruz systemd[1]: Unit mysql.service entered failed state

Running # mysql_secure_installation asked passwrod but didn't accept any:

Enter current password for root (enter for none): 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

Solution:

I had two problems - mysql database folder and files owner and an empty file .run-mysql_upgrade.

So here is how I solved it:

chown -R mysql:mysql /var/lib/mysql; rm /var/lib/.run-mysql_upgrade

Comments   

ralph
+1 # ralph 2013-09-21 13:01
had the same problem - your solution worked for me too. Thank you!
Chris
+1 # Chris 2014-01-07 23:34
Bravo! The chown command you suggested worked perfectly. Thanks very much!!
Chris

Please register to post comments.

Found a typo? Please select it and press Ctrl + Enter.
FaLang translation system by Faboba
Електронна бібліотека «Exlibris»: історичні дослідження, мемуаристика, публіцистика, художня література Українська етнографія: книги, курси лекцій, статті й матеріали, мапи, фотоальбоми, веб-ресурси Правителі України: портрети, життєписи, матеріали Твори Адріана Кащенка: романтика козацьких часів Народна війна 1917-1932

See a typo?

Select the text block and press

CTRL+Enter

Comments

  • NotificationAry - get emails on Joomla content is submitted, added or changed

    gruz gruz 24.05.2019 15:43
    I don't understand you. You can send notifications to users and to specific emails (who are not joomla ...

    Read more...

     
  • NotificationAry - get emails on Joomla content is submitted, added or changed

    Berndi Berndi 24.05.2019 14:27
    Hello Gruz, is it somehow possible to configure additional mailadresses like this ...

    Read more...

     
  • NotificationAry - get emails on Joomla content is submitted, added or changed

    Berndi Berndi 24.05.2019 09:28
    Found the issue When I set one of these parameters to "NO", the button disappears.https://i.ibb.co/F4zdJ9H/notification-A ...

    Read more...

     
  • NotificationAry - get emails on Joomla content is submitted, added or changed

    gruz gruz 22.05.2019 12:02
    http://gruz.ml/images/x/2019_05_22_12_00_08_lm.png

    Read more...

     
  • NotificationAry - get emails on Joomla content is submitted, added or changed

    Berndi Berndi 22.05.2019 11:35
    How can I activate this? It istn't shown on my Joomla! installation (3.9.6) ...

    Read more...