Hello to all. I need to know how to connect weather display with my remote server MYSQL. Thank you all.
you can set that up
under control panel
MYSQL setup
Thank you for your reply. I have carried out all settings. I entered the 'url of the MYSQL server and I also entered username and password, but I always get this error “ERROR: MySQL server has gone away at time / date 1/5/2017 8:13:26” without having any connection with the server. Why?
so it does initialy connect?
you could try googling that error, there might be a mysql server configuration issue that you can fix
tried to put on google this error, but is not nothing I can relate to this problem.
What do you want to say?
I googled the error
lots of hits
e,g
http://dev.mysql.com/doc/refman/5.7/en/gone-away.html
@micos70 - If the MySQL is on a webhost server, are you sure the host allows remote connections? Many don’t.
I got that error message when I tried to connect to MySQL server via weather display. When I spoke to my host the message was because they don’t allow remote connections.
Paul
I have the same, MySQL can only be accessed from the same server on which the db is
I may be totally misunderstanding this thread, but it sounds like an issue I had a long time ago. Have either of you tried to use MySQL Workbench? I find that if you use this tool to set SQL rules to allow specified IP addresses and user IDs to run MySQL between multiple computers, that will sometimes solve the issue. All you have to do is create a rule and it should allow MySQL to run properly if the db is on one computer and you’re logging on via another. Check it out.
@dan43 - You are assuming the ability to control both PC’s. The posts above concern MySQL databases running on webhost controlled shared hosting servers. Very few non-business hosting plans will allow remote access to MySQL.
you could always install XAMPP