[TriLUG] installing MySQL on SUSE 8.0

[Jon Carnes]

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