[TriLUG] installing MySQL on SUSE 8.0

[Mike Kelley]

Thanks,

I knew it would be something simple.

Mike


----- Original Message -----
From: "Jon Carnes" <jonc at nc.rr.com>
To: "Triangle Linux Users Group" <trilug at trilug.org>
Sent: Tuesday, February 04, 2003 10:26 AM
Subject: Re: [TriLUG] installing MySQL on SUSE 8.0


> Just guessing here (since I'm a postgresql guy), but isn't the second
> one just an example of setting the root password from another host.  In
> otherwords the first example is how to do it when you are on the local
> server and the second is how to do it if you are on a workstation
> accessing the server remotely.
>
> In postgres, you simply type one command line to set the password, and
> MySQL is *supposed* to be easier...
>
> Jon Carnes
>
> On Tue, 2003-02-04 at 09:59, Mike Kelley wrote:
> > I'm trying to install MySQL 3.23.55 on SUSE 8.0
> > I installed the RPMs with no problem however when I run the
mysql_install_db it reminds me to set the password for root as:
> >
> > mysqladmin -u root password 'newpassword'
> > mysqladmin -u root -h Linux1 password 'newpassword'
> >
> > The first statement worked fine, however, when I run the second
statement it returns the following (I ran both statements as root):
> >
> > Linux1:/usr/bin # mysqladmin -u root -h Linux1 password mypassword
> > mysqladmin: connect to server at 'Linux1' failed
> > error: 'Host "Linux1.local' is not allowed to connect to this MySQL
server'
> > Linux1:/usr/bin #
> >
> > can someone please tell me what I'm doing wrong and how to fix it.
> >
> > Thanks,
> >
> > Mike
>
>
> _______________________________________________
> TriLUG mailing list
>     http://www.trilug.org/mailman/listinfo/trilug
> TriLUG Organizational FAQ:
>     http://www.trilug.org/~lovelace/faq/TriLUG-faq.html