Weird sql error

[Proximity]

So I have a dedicated server I am running a hyper-v box on it which runs the webserver/sql server

I can connect to navicat on my home pc but not the dedicated server that the web server is beign hosted on

So

226 <-- the main box <-- cannot connect
227 <-- The webserver/sql server <--
My ip <-- I can connect with my pc but not the others

And before you ask yes the ports and shit are open

 

[Ecko]

An error message will help

 

[Proximity]

An error message will help

Says 2003 - Cannot connect to server on "" (10061, unknwon error)

 

[Ecko]

Says 2003 - Cannot connect to server on "" (10061, unknwon error)

Now show us your connection string..

 

[Proximity]

Now show us your connection string..

It's navicat..

 

[Ecko]

It's navicat..

AKA you're probably using WAMP or something other gay shit.. and are probably not even running MySQL properly..

Notice how your error message doesn't even show the MySQL host? What user is Navicat connecting as? If the MySQL service is running on a different IP address than the server you are connecting from, then you need to grant access to that IP address.

 

[Proximity]

AKA you're probably using WAMP or something other gay shit.. and are probably not even running MySQL properly..

Notice how your error message doesn't even show the MySQL host? What user is Navicat connecting as? If the MySQL service is running on a different IP address than the server you are connecting from, then you need to grant access to that IP address.

It does show the host I just didn't say the ip address.

P.S: I am using Centos 7 with MariaDB

 

[Ecko]

It does show the host I just didn't say the ip address.

P.S: I am using Centos 7 with MariaDB

Have you granted access to the IP address that Navicat is connecting from? What user are you connecting as?

 

[Proximity]

Have you granted access to the IP address that Navicat is connecting from? What user are you connecting as?

Yes I have.

I tired both root and a non root user

 

[Ecko]

and what's the output of SHOW GRANTS ?

 

[Proximity]

and what's the output of SHOW GRANTS ?

Everything is graned

 

[Ecko]

Everything is graned

Then you're doing something wrong.

 

[Proximity]

Then you're doing something wrong.

I am not doing anything wrong?

It's a fresh install of navicat on the dedicated server and on my pc and my pc is working but the other one isn't?

 

[Ecko]

10 bucks says if you provide me with credentials to work on this I can get it working in under 10 min

 

[Proximity]

10 bucks says if you provide me with credentials to work on this I can get it working in under 10 min

It works on my home pc and the MariaDB server is hosted on a linux server...
And I do not provide credentials to anyone

not even my own mother..
 
This is the configuration:

You must be registered for see links

<-- active and loaded on my home pc

You must be registered for see links

<-- settings on my home pc

You must be registered for see links

<-- configuration on the server

You must be registered for see links

<-- trying to connect to the server

 

[Markshall]

It works on my home pc and the MariaDB server is hosted on a linux server...
And I do not provide credentials to anyone

not even my own mother..
 
This is the configuration:

You must be registered for see links

<-- active and loaded on my home pc

You must be registered for see links

<-- settings on my home pc

You must be registered for see links

<-- configuration on the server

You must be registered for see links

<-- trying to connect to the server

Even if you don't give them to him, I'm sure he'd find a way to get them lol

 

[Ecko]

226 <-- the main box <-- cannot connect
227 <-- The webserver/sql server <--

psychez.net (ps - you're trying not to show the IP but it's showing in one of those images) (pps - they don't see to be a good host, takes forever for it even show me fingerprint key:
ECDSA key fingerprint is 40:94:ee:e4:53:fc:be:4a:be:5d:ae:94:6c:f9:28:b8.)

now the real question is what is your bind address actually set to in my.cnf ? since you're using hyper-v my guess is you should be using an internal address when connecting in network, and the public IP when connecting from home

 

[Proximity]

psychez.net (ps - you're trying not to show the IP but it's showing in one of those images) (pps - they don't see to be a good host, takes forever for it even show me fingerprint key:
ECDSA key fingerprint is 40:94:ee:e4:53:fc:be:4a:be:5d:ae:94:6c:f9:28:b8.)

now the real question is what is your bind address actually set to in my.cnf ? since you're using hyper-v my guess is you should be using an internal address when connecting in network, and the public IP when connecting from home

Oh well it doesn't really matter I have 40GBPS ddos protection and they are a decent host.