HeidiSQL Can't connect to MySQL server on "mylinuxvpsIP" (10061) need help


#1

Hello,

I am trying to setup a server on a Ubuntu 16.04 VPS server runs and i can connect so great

but i am trying to install a mysql database for ESX plugins i can connect external trough http://myexternalip/phpmyadmin and i can log in succesfully but when i try to connect via HeidiSQL it gives me the error

Can’t connect to MySQL server on “mylinuxvpsIP” (10061)

i have no idea what to do since the http://myexternalip/phpmyadmin does work


#2

Most likely because the user you are using to login to mysql is only allowed to login via localhost. This is the default and most secure behavior.

If you’d like to allow your own home IP to connect as well, add it to that user. How to do that? Google is your best friend.


#3

As i already said i can externally connect through the http://myVPSip/phpmyadmin i already allowed all external connections


#4

Logging in via PHPMyAdmin is seen as localhost by the MySQL server.

Again, have a look at the user you use to login and allow your external IP as a host. Also open your MySQL port


#5

Where should i be able to see this


#6

I am using Xampp BTW


#7

google how to do this… it is also dependent on each router.


#8

i said it is an VPS which has all ports open


#9

I have already changed required local to required all granted


#10

if its a linux vps you still need to add it to the iptables or whatever firewall it has.


#11

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.