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 184.108.40.206 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=220.127.116.11 Jun 03 09:09:10 roofingsheetsbyrhino sshd: Failed password for invalid user share123 from 18.104.22.168 port 55360 ssh2 Jun 03 09:09:11 roofingsheetsbyrhino sshd: Received disconnect from 22.214.171.124: 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!
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Click below to sign up and get $200 of credit to try our products over 60 days!