[TriLUG] installing MySQL on SUSE 8.0

[Joseph Tate]

Mysql authentication is host based.  That allows for virtual hosts in 
the database as well as the web server, mail server, etc.  Thus you can 
have jondoe at host1 and jondoe at host2 be two completely different users 
with separate passwords.  That's all well and good, but it makes for 
very convoluted "single host" authentication.

The -h is the remote host.  It couldn't find Linux1.local to connect to. 
 What you really want to do is mysqladmin -u 'root@%' password 
'newpassword'.

This will set the root password across all domains (read virtual 
servers) to 'newpassword'

Joseph

Jon Carnes wrote:

>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
>  
>