I just installed MariaDB on a new Ubuntu 18.04 box. When I try to start the server, I get this:
sudo /etc/init.d/mysql start (....) Starting mysql (via systemctl): mysql.service Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. failed!
When I type "journalctl -xe", it seems relevant:
Apr 05 11:21:00 oddswatch sshd(26131): Failed password for root from (IP ADDRESS) port 41884 ssh2 Apr 05 11:21:01 oddswatch sshd(26131): Connection closed by authenticating user root (IP ADDRESS) port 41884 (preauth) Apr 05 11:21:01 oddswatch sshd(26133): error: Could not load host key: /etc/ssh/ssh_host_ecdsa_key Apr 05 11:21:03 oddswatch sshd(26133): pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=(IP ADDRESS) user=root Apr 05 11:21:03 oddswatch sudo(26135): jason : TTY=pts/1 ; PWD=/home/jason ; USER=root ; COMMAND=/bin/journalctl -xe Apr 05 11:21:03 oddswatch sudo(26135): pam_unix(sudo:session): session opened for user root by jason(uid=0)
The error message cannot load / etc / ssh / ssh_host_ecdsa_key. I have consulted Google and generated and re-generated this damn thing in a dozen different ways and this message does not go away.
I'm not sure this is my problem. It seems to be trying to connect root @ IP_ADDRESS rather than root @ localhost. When I try to connect with root @ IP_ADDRESS (for example mysql -u email@example.com -p) it doesn't work (i.e. when I log in, it says access denieD) but mysql -u root -p works fine. Could he try to access the server in a way that he cannot authenticate?
And in any case how to verify the password? I didn't enter the password anywhere, so I don't know why a password failed.
Do you have any thoughts on what I can do to fix this problem? Thank you.