Connect DB Borked After Upgrade

Hi, I have 2 linodes, a website and a Mysql db (Ip bound obviously). I updated to Ubuntu 16 and now can't get that binding to work

* Removed mysql and reinstalled

  • Verified mysql is working both via ssh and Workbench

  • Verified all accounts, dbs and tables are accounted for (In short, almost everything is like before the upgrade)

  • Tried changing "bind-address" from 127… to what it used to be (double checked backup cnf file)

  • Even tried commenting out the bind-address line

  • Verified hosts file was unaffected

Just can't find the solution. Could use some advice.

3 Replies

> Just can't find the solution. Could use some advice.

OK - what do the logs and the command output say when attempting to start mysql? Post them verbatim, please.

-Chris

The Mysql service itself is working fine. I can ssh log in and do queries no problem.

It's simply the connection to my website linode that's now broken after the upgrade.

I've tried binding it to 127.0.0.1, 0.0.0.0, the website Ip, "Mysql", even my websites FQDN. I've also tried commenting out the bind-address line. None of that works.

Got it fixed. :D

For the record the FINAL problem ending up being: When upgrading, the php modules got lost, so no PDO driver. After installing, all good again.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct