[CentOS] Frustrations with MySQL loss, tcpdump, netstat, etc

2009-12-22 Thread ML
Hi All, Hi All, MySQL 5.0.77 on CentOS 5.4 MySQL is running, my Wordpress stuff is working, but I cannot connect to the server from my house. This server is in my house, however, but on a public IP, behind a firewall, etc. I checked my hardware firewall (a dedicated UnTangle system) and that

Re: [CentOS] Frustrations with MySQL loss, tcpdump, netstat, etc

2009-12-22 Thread John Kienitz
UPDATE mysql.user SET Password=PASSWORD('mypassword') WHERE User='root'; GRANT ALL ON mysql.* to 'root'@'127.0.0.1'; GRANT ALL ON mysql.* TO 'root'@'localhost'; GRANT ALL ON mysql.* TO 'root'@'my home IP'; FLUSH PRIVILEGES; commit; and I still cannot connect. But the database starts and this

Re: [CentOS] Frustrations with MySQL loss, tcpdump, netstat, etc

2009-12-22 Thread Les Mikesell
ML wrote: MySQL 5.0.77 on CentOS 5.4 MySQL is running, my Wordpress stuff is working, but I cannot connect to the server from my house. This server is in my house, however, but on a public IP, behind a firewall, etc. I checked my hardware firewall (a dedicated UnTangle system) and that

Re: [CentOS] Frustrations with MySQL loss, tcpdump, netstat, etc

2009-12-22 Thread ML
Hi Les, MySQL is running, my Wordpress stuff is working, but I cannot connect to the server from my house. This server is in my house, however, but on a public IP, behind a firewall, etc. I checked my hardware firewall (a dedicated UnTangle system) and that is successfully allowing the

Re: [CentOS] Frustrations with MySQL loss, tcpdump, netstat, etc

2009-12-22 Thread Les Mikesell
ML wrote: Hi Les, MySQL is running, my Wordpress stuff is working, but I cannot connect to the server from my house. This server is in my house, however, but on a public IP, behind a firewall, etc. I checked my hardware firewall (a dedicated UnTangle system) and that is successfully

Re: [CentOS] Frustrations with MySQL loss, tcpdump, netstat, etc

2009-12-22 Thread Les Mikesell
ML wrote: Rick, have you tried to telnet to port 3306 of the machine where the mysql server is located, from your home machine? if so, what do you get? If you're successful you'll get a connect bit that includes a string that will show your mysql server version number. if you don't have

Re: [CentOS] Frustrations with MySQL loss, tcpdump, netstat, etc

2009-12-22 Thread Kai Schaetzl
MySQL is *not* listening on TCP 3306 since *long* unless you tell it to in the my.cf. It uses a local Unix socket by default. Kai -- Kai Schätzl, Berlin, Germany Get your web at Conactive Internet Services: http://www.conactive.com ___ CentOS