Remote Access to hivemind

[ZAadmin]

Hi there,

I am trying to connect to the hivemind database remotely by doing this in the SQL Command Line, but I am not able to connect to the DB remotely.

All I can see if the normal 'information_schema' Database.

What am I doing wrong and how to I enable remote access to hivemind DB? Port is 3316

GRANT ALL PRIVILEGES ON hivemind.* to user@'x.x.x.x' IDENTIFIED BY 'password';

 

[beowolfschaefer]

make sure for the [email protected] that the ip x.x.x.x is the ip of the remote user and not 127.0.0.1 or localhost. I'm guessing you already know this but just to be sure.

 

[ZAadmin]

Yip, I used my own IP and can connect to MySQL, just not the correct DB

 

[beowolfschaefer]

weird. it looks like you are doing it all correctly. Maybe use navicat or something and edit the use to grant all privileges to the user. I have had problem using the usual statements from time to time for some reason.

 

[Pwn]

If you are connecting to it remotely make sure the port is allowed TCP and UDP on your firewall.

 

[ZAadmin]

Thanx, I opened the ports on the firewall as well. Some weird stuff going on.

BTW, thank you for the 1.7.4.4 update!