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]
