Can't connect to mysql server (NOT LOCALHOST!)

Hey,

I just installed mysql on my server. But when I try to connect to this server it says me "Can't connect to MYSQL server on 'ip address(not local ip address)' (10061)

Please help me :)

-Nils

I meant "I just installed mysql/mariadb"

I guess nobody can help you, with such a lack of information regarding your connection settings (eg. using SSH Tunnel,... ) or server info. Usually on most servers the access to mysql is only allowed from localhost for security reasons. Did you check that?

greets

How do I check that?

i guess you don´t have shell access to your server...?

So in Windows open commandline and type: telnet <YOUR-SERVER-IP> 3306 If you can´t make a connection (getting an error), your server is not listening to mysql port from outside. AND it´s not a good idea to open it!

Is it working ?

I do have shell access. But I tried "telnet IP 3389(my port)" and it said "connected to IP"

I do have shell access. But I tried "telnet IP 3389(my port)" and it said "connected to IP"

MySQL port is 3306 not 3389

Versuch mal im mysql terminal client : GRANT ALL ON . TO 'DEINDBUSER'@'%'; FLUSH PRIVILEGES;

Now try again

GRANT ALL ON . TO 'DEINDBUSER'@'%'; FLUSH PRIVILEGES; FLUSH PRIVILEGES;