Remote connection to MySQL

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Remote connection to MySQL

Postby jnymris » 15. February 2012 23:41

Hello,

I'm trying to make a remote connection to MySQL
I have created a new user and have given them the hostname of * so they should be able to log-in from any host
Here is the record for the user in the Priviledges table:
externalUser % No ALL PRIVILEGES Yes Edit Privileges Export

i then went into the my.ini file and change the bind-address from the default to 0.0.0.0 (With and without "")

then restarted the mySQL Service

Any ideas on how to get this going? I can access the phpmyadmin page from another host and log in that way but i'm trying to make a direct database request using another program. (VB file)

I have tried to connect using a number of programs SQLYog and Creating an ODBC connection (Using MySQL Connector)

I have ran cmd and ran netstat and this is the result:
Proto Local Address Foregin Address State
TCP (Local Address:1069) (Local Address:3306) Time_WAIT
TCP (Local Address:1073) (Local Address:3306) Time_WAIT
TCP (Local Address:1076) (Local Address:3306) Time_WAIT
TCP (Local Address:1079) (Local Address:3306) Time_WAIT

these are all port 3306 which is MySQL Right?

Any Pointers/Help
jnymris
 
Posts: 8
Joined: 11. November 2006 00:07
Operating System: Windows 7 XP Mode/Windows 7

Re: Remote connection to MySQL

Postby JonB » 16. February 2012 16:37

have you tried binding to your exposed IP?

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Remote connection to MySQL

Postby jnymris » 16. February 2012 16:43

JonB wrote:have you tried binding to your exposed IP?

Good Luck
8)



Hello,

Thanks for your reply JonB,

I have also tried binding it to my external ip address, unfort this also this did not giv ethe correct response.

Any other suggestions?
jnymris
 
Posts: 8
Joined: 11. November 2006 00:07
Operating System: Windows 7 XP Mode/Windows 7

Re: Remote connection to MySQL

Postby JonB » 16. February 2012 17:10

You might look for a local firewall policy...
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Remote connection to MySQL

Postby jnymris » 16. February 2012 17:15

I'm using two Virtual machines, (XP Mode) neither have any firewall, i can ping each other and able to bounce onto the http server from the VM that i'm using to try and create the MySQL request from.
jnymris
 
Posts: 8
Joined: 11. November 2006 00:07
Operating System: Windows 7 XP Mode/Windows 7

Re: Remote connection to MySQL

Postby jnymris » 19. February 2012 20:20

Anyone?
jnymris
 
Posts: 8
Joined: 11. November 2006 00:07
Operating System: Windows 7 XP Mode/Windows 7

Re: Remote connection to MySQL

Postby hackattack142 » 20. February 2012 01:33

Knowing any specific error messages you are getting when trying to make a remote connection would be helpful.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 703
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 62 guests