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. This
> > feels like the same thing.
> >
> > PS As a side issue is there anyway to use for example 10.0.0.0/8 or
> > equivalent. It seems to only take exact addresses instead of address
> > ranges in the GRANT line.
> >
> >
> > Thanks in advance for any help
> >
> >
> >
> >
> >
>
> --
> By-Tor.com
> It's all about the Rush
> http://www.by-tor.com
>
> --
> redhat-list mailing list
> unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
> https://listman.redhat.com/mailman/listinfo/redhat-list
--
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list
