Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
MySQL service unable to start...
I’m getting an “Error establishing a database connection” in WordPress, and on further inspection it looks like the MySQL service isnt running.
When I try and run
sudo service mysql start, I get:
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
If I run
systemctl status mysql.service I get:
Loaded: loaded (/etc/init.d/mysql) Active: failed (Result: exit-code) since Mon 2019-06-03 09:00:20 UTC; 18s ago Process: 936 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
sudo journalctl -xn gives me:
-- Logs begin at Mon 2019-06-03 08:58:05 UTC, end at Mon 2019-06-03 09:09:21 UTC. -- Jun 03 09:09:01 roofingsheetsbyrhino cron: Authentication token is no longer valid; new one required Jun 03 09:09:01 roofingsheetsbyrhino cron: Authentication token is no longer valid; new one required Jun 03 09:09:09 roofingsheetsbyrhino sshd: Invalid user share123 from 220.127.116.11 Jun 03 09:09:09 roofingsheetsbyrhino sshd: input_userauth_request: invalid user share123 [preauth] Jun 03 09:09:09 roofingsheetsbyrhino sshd: pam_unix(sshd:auth): check pass; user unknown Jun 03 09:09:09 roofingsheetsbyrhino sshd: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=18.104.22.168 Jun 03 09:09:10 roofingsheetsbyrhino sshd: Failed password for invalid user share123 from 22.214.171.124 port 55360 ssh2 Jun 03 09:09:11 roofingsheetsbyrhino sshd: Received disconnect from 126.96.36.199: 11: Bye Bye [preauth] Jun 03 09:09:21 roofingsheetsbyrhino sudo: tom : TTY=pts/0 ; PWD=/var/www ; USER=root ; COMMAND=/bin/journalctl -xn Jun 03 09:09:21 roofingsheetsbyrhino sudo: pam_unix(sudo:session): session opened for user root by tom(uid=0)
I’m really not sure what the issue is here, or how this has come about - any advice as to what I should do next would be hugely appreciated!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×