Re: getting mysql query browser to work

2009-04-24 Thread Brian Simons
On Fri, 2009-04-24 at 10:15 -0600, Kyle Waters wrote: You'll need to change that in the mysql conf files. You can set the server to listen on all interfaces (on a debian-based linux distro) by commenting out all 'bind-address' lines in the configuration file. /* PLUG: http://plug.org, #utah

Re: getting mysql query browser to work

2009-04-24 Thread Jessie Morris
On Friday 24 April 2009 10:08:49 am Merrill Oveson wrote: I want to get mysql query browser to work. The host is remote. I can ping the host and I know the port is correct. I can ssh in to the host, then launch mysql using the username, passwords, etc. But when I put this info in mysql

Re: getting mysql query browser to work

2009-04-24 Thread Brian Simons
On Fri, 2009-04-24 at 10:08 -0600, Merrill Oveson wrote: I get the MySQL Error Number 2003 Can't connect to MySQL server... Probable causes are that the server isn't listening on the right interface, there's a firewall in the way, etc. When things are set up correctly this command should

Re: getting mysql query browser to work

2009-04-24 Thread William Attwood
You may have port 3306 blocked for external connections. First, what OS are you running? Second, do you have an account on your MySQL server that allows connections from %, or, your specific host? On Fri, Apr 24, 2009 at 10:08 AM, Merrill Oveson move...@gmail.com wrote: I want to get mysql

Re: getting mysql query browser to work

2009-04-24 Thread Kyle Waters
Merrill Oveson wrote: I get the MySQL Error Number 2003 Can't connect to MySQL server... Any ideas? There are two likely problems. The first has been mentioned. The second is that the dameon is not listening remotely. You can check this by running: netstat -ltp and seeing the

Re: getting mysql query browser to work

2009-04-24 Thread Merrill Oveson
I change the bind in the my.cnf file, now I get the error Host is not allowed to connect.. So I guess I need to have a pin hole put into the firewall on the remote site allowing my host to connect. On Fri, Apr 24, 2009 at 10:10 AM, Jessie Morris jes...@confettiantiques.com wrote: On

getting mysql query browser to work

2009-04-24 Thread Merrill Oveson
I want to get mysql query browser to work. The host is remote. I can ping the host and I know the port is correct. I can ssh in to the host, then launch mysql using the username, passwords, etc. But when I put this info in mysql query browser - no go. I get the MySQL Error Number 2003 Can't

Re: getting mysql query browser to work

2009-04-24 Thread Spencer Gibb
On Fri, Apr 24, 2009 at 10:42 AM, Merrill Oveson move...@gmail.com wrote: I change the bind in the my.cnf file, now I get the error Host is not allowed to connect.. So I guess I need to have a pin hole put into the firewall on the remote site allowing my host to connect. I would tunnel