Mysql: no connection could be made because the target machine actively refused it.

Question

1.00/5 (1 vote)

See more:

I'm having problems connecting to a MySQL server on a Raspberry Pi from Windows using PHP.

What I've done:

On the pi:

iptables -I INPUT -j ACCEPT

The pi and PC are on the same network.

The code I'm using is able to connect to other servers just fine. Only been able to test servers outside of this network.

I'm able to log in with the same credentials I'm using in the PHP file, using adminer on the pi.

The user I'm trying to log in with has all permissions to the table from '%' ip address.

Both machines are able to ping each other.

Any help would be appreciated.

What I have tried:

Everything mentioned in the question, searching online to no avail.

Posted 4-Apr-18 11:47am

User 13204940

Updated 28-May-20 19:18pm

v2

Add a Solution

Comments

Christiaan van Bergen 4-Apr-18 17:51pm

Have you used the "flush privileges;" for the changes to take effect?

[no name] 4-Apr-18 17:52pm

Yes, and that's why I'm able to make use of the database just fine in adminer using the same user

Christiaan van Bergen 4-Apr-18 18:05pm

So everything works, but remote. Any other firewall or netfilter running on the pi? Check the running processes. Run a check on the open ports and programs:
$ netstat --tcp --listening --programs --numeric

[no name] 4-Apr-18 18:06pm

Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 503/mysqld
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 355/sshd
tcp6 0 0 :::80 :::* LISTEN 483/apache2
tcp6 0 0 :::22 :::* LISTEN 355/sshd

[no name] 4-Apr-18 18:06pm

I can even access the web server on the pi from this pc, just not mysql

Christiaan van Bergen 4-Apr-18 18:13pm

Yeah, but your mysqld is only listening to localhost:3306 . Compare that to the entry of your apache webserver. That one is listening to all ip addresses on port 80.

[no name] 4-Apr-18 18:14pm

Oh dear, how can I allow it to listen on all ips?

Christiaan van Bergen 4-Apr-18 18:23pm

;-)

3 solutions

Solution 3

For others to see, the solution was this;

Change bind-address to 0.0.0.0 in:

/etc/mysql/mariadb.conf.d/50-server.cnf

Posted 4-Apr-18 12:21pm

User 13204940

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jochen Arndt · Accepted Answer · 2018-04-04T12:16:00

Solution 1

The MySQL server on the Pi is probably not listening on the network interface. For security reasons the default is listening on the loopback / local host / 127.0.0.1 interface only.

The common location of the MySQL configuration file is /etc/mysql/my.cnf. If that contains a line

bind-address     127.0.0.1

comment that out or change it to

bind-address     0.0.0.0

Posted 4-Apr-18 12:16pm

Jochen Arndt

Comments

[no name] 4-Apr-18 18:17pm

That file doesn't contain that line, only:

[client-server]
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/

Jochen Arndt 4-Apr-18 18:21pm

Then look for the my.cnf file in those directories.
The option will be in the [mysqld] section.

[no name] 4-Apr-18 18:18pm

Ah perfect, found it.

Christiaan van Bergen · Accepted Answer · 2018-04-04T12:18:00

Solution 2

In your mysql config /etc/mysql/my.conf comment out the following line:

bind-address=

When you do that, it will bind to all addresses. Also make sure that you don't have skip-networking enabled in your my.cnf.

Posted 4-Apr-18 12:18pm

Christiaan van Bergen