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