On Mon, 2003-01-13 at 08:54, Terry Hobart wrote: > Sorry, brain fart. Was typing telnet 10.1.10.3:3306 > > Using the correct syntax I got 'connection to host lost'. > > And that's correct - no telnetd on this server. I will go ahead and install > it and reply back.
Once again, you don't need telnetd. You only need telnet. Please reread my last post. > Terry > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Cliff Wells > Sent: Monday, January 13, 2003 7:35 AM > To: [EMAIL PROTECTED] > Subject: Re: Mysql will not answer outside localhost > > On Sun, 2003-01-12 at 21:54, Terry Hobart wrote: > > I agree it is not a firewall issue. I have no firewall running on this > machine > > and am accessing it from a workstation on its local network > server:10.1.10.3/8 > > workstation: 10.1.0.101/8 > > > > dns is also not running. The named server is not even on. I have not got > that > > far in setting the server up. > > > > My access from the workstation to the server is by direct ip address in > dbtools > > > > I wish I could telnet to the port but for security I did not put telnet on > the > > server so it tries to connect but gets a failure on port 23. Sorry. I did > load > > ssh but can't remember how to login to that port using it from my win2000 > > workstation (still learning). > > You mean you didn't put *telnetd* on the server. telnetd is the telnet > server, telnet is the client. You can use telnet to connect to *any* > port, not just 23 (although your results may vary, depending on what is > listening on that port). Most telnet clients take the port number as a > second argument: > > telnet somehost 3306 > > This is a basic diagnostic technique. It doesn't matter that the server > doesn't have telnetd running on it as you won't be connecting to telnetd > (port 23), but rather mysqld (port 3306). > > I haven't read this entire thread, so maybe you've covered all of the > stuff outlined here, but you might look anyway: > > http://www.mysql.com/doc/en/Can_not_connect_to_server.html > > > > Larry Brown wrote: > > > > > Can you telnet to 3306 and get a prompt? If so it has nothing to do > with a > > > firewall. If you can it may be that the client has to be identified by > the > > > server which would require either dns resolution or a listing in the > hosts > > > file. It has nothing to do with the client being able to find the > server, > > > just the server's ability to identify the calling client (I suspect). > > > > > > Larry S. Brown > > > Dimension Networks, Inc. > > > (727) 723-8388 > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On > > > Behalf Of Terry Hobart > > > Sent: Sunday, January 12, 2003 6:41 PM > > > To: [EMAIL PROTECTED] > > > Subject: Re: Mysql will not answer outside localhost > > > > > > I checked all that out and even re-did some users with no luck. They all > > > check > > > out with % in the Host column and Y in all the privleges. I set this > machine > > > up befor using the rpm directly from the mysql site and it worked fine. > I > > > wanted to use RedHat's rpm this time because I want to maintain it with > rhn. > > > > > > It just continues to give me 'Lost connection to MySQL server during > query'. > > > > > > I have pinged the server and it is there. The portscanner shows the port > > > open. > > > I am VERY puzzled. Another person answered questioning DNS (which is > not > > > yet > > > running on this machine) but I don't remember having to have it running > when > > > I > > > did this before. Plus I am setting dbtools to go directly to the ip > address > > > of > > > the mysql server. > > > > > > John Nichel wrote: > > > > > > > Did you set up the users in the user table to access from remote > hosts? > > > > > > > > Try this when logged in on the local host, then restart MySQL.... > > > > > > > > INSERT INTO `mysql.user` (`Host`, `User`, `Password`, `Select_priv`, > > > > `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, > `Drop_priv`, > > > > `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, > > > > `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`) VALUES > > > > ('%', 'user_to_have_outside_access', PASSWORD('your_password'), 'Y', > > > > 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); > > > > > > > > Terry Hobart wrote: > > > > > I have an RH 8 stock installation (meaning I have not yet updated it > > > > > from rhn). I had it install MySQL from the disks. I cannot however > > > > > access it from outside the localhost box. > > > > > > > > > > I can always access it from inside the box. > > > > > mysql - u root -p > > > > > or any other user I create @localhost > > > > > > > > > > The following is what I have installed for users: > > > > > > > > > > GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY '******' > > > > > WITH GRANT OPTION; > > > > > > > > > > I repeated this process for other 'outside users' replacing > > > > > root@localhost with test@"%" + a password and [EMAIL PROTECTED] (my > > > > > workstation ip on the local net). But no user password combo will > allow > > > > > me to login from my workstation. > > > > > > > > > > The linux box is on 10.1.10.3/8 > > > > > > > > > > The my.cnf: > > > > > > > > > > [mysqld] > > > > > datadir=var/lib.mysql > > > > > socket=/var/lib/mysql/mysql.sock > > > > > > > > > > [mysql.server] > > > > > user=mysql > > > > > basedir=/var/lib > > > > > > > > > > [safe_mysql] > > > > > err-log=/var/log/mysql.log > > > > > pid-file=/var/run/mysql/mysql.pid > > > > > > > > > > I remember messing with sendmail for months with this same problem > until > > > > > > > > > > I found out that on 7.3 RedHat disabled outside access by default -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe https://listman.redhat.com/mailman/listinfo/redhat-list
