On the computer not running MySql with the data base, but running Linux and MySql enter: mysql -h 10.1.10.3 -u root -D database-wanted
This will start mysql on the local machine, but connect to the mysql database on the remote computer. david On Sat, 11 Jan 2003, Terry Hobart wrote: > Forgive the ignorance but can you explain the -h server-name further. I can > only log in as root when on the localhost. > > Thanks > > dbrett wrote: > > > Did you try the "-h 'server-name(or ipaddress)'" option as well when > > logged in as root? > > > > david > > > > On Sat, 11 Jan 2003, 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 > > > > > > > > > > > > > > > > > > -- > > > 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 > > > > -- > 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
