Failed to connect to MYSQL database: Can't connect to MySQL server on 'IP' (146) **solved**

All about the standard Meteobridge devices based on mobile routers from TP-Link, D-Link, ASUS

Moderator: Mattk

Post Reply
rmccullough
Fresh Boarder
Fresh Boarder
Posts: 15
Joined: Thu Apr 24, 2014 8:39 pm

Failed to connect to MYSQL database: Can't connect to MySQL server on 'IP' (146) **solved**

Post by rmccullough »

I followed these directions to get the database and table configured. Which seems to have gone fine.

But when I enter the details in my Meteobridge I get the error in the attached screenshot. The details I entered are correct. I can log in to phpMyAdmin with the same credentials and view the table just fine.
Attachments
2018-10-25 19_37_32-Meteobridge.png
2018-10-25 19_37_32-Meteobridge.png (45.49 KiB) Viewed 1917 times
bardek
Senior Boarder
Senior Boarder
Posts: 41
Joined: Fri Jan 16, 2015 7:49 pm
Contact:

Re: Failed to connect to MYSQL database: Can't connect to MySQL server on 'IP' (146)

Post by bardek »

Your database should permit remote insert for the user first and propably myslq server remote access should be enabled too.
rmccullough
Fresh Boarder
Fresh Boarder
Posts: 15
Joined: Thu Apr 24, 2014 8:39 pm

Re: Failed to connect to MYSQL database: Can't connect to MySQL server on 'IP' (146)

Post by rmccullough »

bardek wrote: Fri Oct 26, 2018 10:57 pm Your database should permit remote insert for the user first and propably myslq server remote access should be enabled too.
I figured that If I could login to the phpMyAdmin interface remotely I was good to go. Had no idea that I had to allow remote access to the database itself. Working perfect now.
Post Reply