PDA

View Full Version : [xubuntu] Mysql server cant be accessed?



infofo
July 25th, 2010, 12:19 AM
I have a xubuntu mysql server, and my winxp machine is unable to connect to the sql server using mysql ODBC.:( Is there any solution to my problem? Thanks.

minhnghivn
July 25th, 2010, 11:37 AM
It is most likely that your MySQL is "bind" to a fixed IP address. For example:

# my.cf
bind-address = 127.0.0.1

The implies that only connections from 127.0.0.1 are allowed. So, just comment the above directive, restart your MySQL and retry

Good luck

infofo
July 26th, 2010, 03:13 AM
Thanks! I shall try that first thing tomorrow.