Connecting to Linode DB from my localhost

I'm trying to do this but always get refused. In virtualmin I added my own IP address under "remote hosts". As "host" value in my PHP connection script I just use the IP address of my Linode.

Should this work in theory?

2 Replies

By default MySQL binds to 127.0.0.1, meaning only local connections are allowed, regardless of what's in your privileges table.

2 other things to check.

1) Make sure you don't have skip-networking set in your /etc/my.cnf

2) Make sure your firewall allows incoming connections to mysql (port 3306)

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