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

Read Answer

Related posts:

  1. Apache, MySQL won’t start
  2. Upgrading to MySQL 5
  3. Subsonic Connection Error
  4. How can i log in to my server from a remote computer?
  5. Lucene Search Fields