Newbie trying to make root password

[Michael Greisman]

Hi, I'm installing and using mySQL for the first time, and it shows.

I've downloaded and installed mysql-standard-4.0.13.pkg on my OS X 
box (b&w G3, OS X 10.2.6)

I'm following the directions given in the Readme:
"
If you installed MySQL for the first time, *please remember to set a
password for the MySQL root user!*
This is done with the following two commands:

     /usr/local/mysql/bin/mysqladmin -u root password <password>
     /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password <password>
"
The first command, /usr/local/mysql/bin/mysqladmin -u root password 
<password>, worked fine.
The second command gives me errors. I have questions about it, too, 
if you don't mind answering them.

1. What does this command do? It looks like it defines the root 
password a second time while specifying the host machine. Why do we 
do that?

2. Here's what I tried. Please tell me what I should /really/ be doing.
I initially typed the command as shown:
"/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password <password>"
with <password> replaced by the root password I used in the first command.
Doing that gave me this error:
"
bash-2.05a$ /usr/local/mysql/bin/mysqladmin -u root -h `hostname` 
password MYPASSWORD
/usr/local/mysql/bin/mysqladmin: connect to server at 'Ungoliant.local.' failed
error: 'Host '10.0.0.14' is not allowed to connect to this MySQL server'
"

Next I tried this:
"
bash-2.05a$ /usr/local/mysql/bin/mysqladmin -u root -h 
`Ungoliant.local' password MYPASSWORD

"
You can see that I got a caret (greater-than-symbol) prompt which I 
did NOT know what to do with.
(Ungoliant is the name of my machine.)

Now when I try
"bash-2.05a$ /usr/local/mysql/bin/mysqladmin -u root -h '10.0.0.14' 
password MYPASSWORD"
or try again:
"bash-2.05a$ /usr/local/mysql/bin/mysqladmin -u root -h 
'Ungoliant.local.' password MYPASSWORD"

I get the same "connect to server at..." error.

Please advise? I'd wanted to start out right before I moved on.
--
Michael Greisman
[EMAIL PROTECTED]
Web Developer
Scanalytics, Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]