Shane,
Maybe I can lend a hand.
When you first install MySQL, there is (basically) only one user root. The
root user exists without a password, which is why pretty much everyone
recommends that you assign root a password immediately. You're first
command:
mysqladmin -uroot password password
Can you explain why you're using that second line. Tell me a little more
about your installation. You're installing MySQL __ machines which are __,
running OS X version __. You're installing ___ version of MySQL. Stuff like
that.
As for getting your hostname on OS X, go to the command prompt and simply
type hostname. The value returned is the hostname for your computer. You
can also go into the System Preferences in the Sharing preference. The
hostname is also the name of your computer.
Regards,
Adam
-Original Message-
From: Shane Korosec [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 9:30 PM
To: [EMAIL PROTECTED]
Subject: Setting root password on OS X
I am a new mysql user. I am installing MySQL for the first time on my mac. I
need to set a password for the 'root' user by using the following 2
commands:
/usr/local/mysql/bin/mysqladmin -u root password password
/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password password
The first worked, but i get the following error when i attempt to run the
second:
/usr/local/mysql/bin/mysqladmin: connect to server at 'skc.local.' failed
error: 'Host ip address is not allowed to connect to this MySQL server'
How do i know what my hostname is? I have entered a number of options of
what i think it might be (like username 'localhost'...), but they have
gotten me nowhere.
I really don't know what im doing here, so i would appreciate any advice.
Cheers
Shane
_
Get less junk mail with ninemsn Premium. Click here
http://ninemsn.com.au/premium/landing.asp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
