Unable to connect to DB

General
1

Hi,

I'm getting the connection error shown below.
I recreated the link with no avail. Rewritten the credentials with no avail either.
My ESP connects to the DB without a problem using the same credentials.
How can I troubleshoot my problem?

TIA

Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'user_iot'@'82.179.66.52' (using password: YES)

2

What database type is that?
The error suggests that you are trying to connect from a Russian IP address on the internet, are you trying to access a database across the internet?

3

:thinking:Russian? I’m in Spain and I’m connecting to my ISP’s mySql server which is about 20km from me. Will look up on that ip. Thanks.

EDIT: I remember now I made some changes to that IP for troubleshooting reason. The actual IP is 82.159.77.52.

4

Can you connect from the command line mysql client on the machine running node-red? Something like
mysql --host=<mysql host ip> --user=user_iot --password=<thepassword>

5

:sweat_smile: It looks like on this new rpi board I didn't install mysql:

-bash: mysql: command not found

6

What do you mean you made changes to the IP? That should be the external IP of the system. You can't change it (well not usually).

7

I think you probably need to install mysql-client to get the command line client.
sudo apt install mysql-client
Node red shouldn't need that though.

8

I know but I was just playing with the IP to see if the error would change.

9

Package 'mysql-client' has no installation candidate

I guess I need to install the whole DB package?

10

I don't understand how you could play with the IP. You shouldn't be specifying it anywhere, it is automatic.

11

In the mysql config window you can set the ip, the user and the password.

12

The mysql server is not on my machine. It's located on the ISP's server.

13

That is the IP of the server, not the ip of the pi. The error is saying you can't connect to the server from 82.179.66.52. At least I think that is what it is saying.

14

Actually, https://www.whatismyip.com/ returns a different IP, so it's not mine but ISP's.

15

Anyhow, as I stated earlier, I have no problems with my ESP connecting to the mysql server with the identical credentials.

16

That is a pain, it seems the mysql client isn't in a separate package in Raspbian.
When you said you could connect from ESP, what did you mean by that?

17

The ESP sends the data to the server every so often. Node-red reads it and display it.

18

What is an ESP?

19

Sorry, ESP/ESP8266/ESP32 are microcontrollers.

20

Is that on the same local network as the pi?