Robert, I also think the read me is a little vague. I see what they're getting at but I don't understand why it was phrased that way.
When you think about it, the error message makes sense. When you do any command through mysqladmin your authenticating to MySQL then executing the command. You were attempting to connect to MySQL without a password when you had just set one. MySQL responded by telling you your login attempt was unsuccessful. After all, you can set your root user's password as many times as you like. Its been a while but I believe MySQL identifies the full hostname, lazarus.local. versus the short name lazarus (see command line example below). So yes, I wouldn't be surprised to see a host name like that returned. [machine] prompt% hostname lazarus.local. [machine] prompt% hostname -s lazarus If you have additional questions, let me know. I don't use MySQL too much these days, but I'll be glad to tell you what I know. Regards, Adam -----Original Message----- From: Robert Lund [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:00 PM To: [EMAIL PROTECTED] Subject: Re: OS X - can't set root password Fortuno, Adam wrote: >If I follow you're email correctly, it looks like you attempting to assign a >password to the root user twice. The first statement you provide: > > >>bin/mysqladmin -u root password ****** >> >> >Sets the password to whatever value you've set in-place of ******. Then in >the statement below you attempt to set the password again. > > >>/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password ****** >> >> > >Take a good look at that second line. You're assigning a new password to the >root account, but when you attempt to reset the password for root as root >you don't use root's new (as set in line 1) password. Make sense? > What you say makes sense - although I would expect the mysql response to be something indicating that I'm trying to set the root password twice, instead of telling me: error: 'Host '192.168.1.100' is not allowed to connect to this MySQL server' I only entered those two instructions because in the README supplied with the Installation PKG, the following was included: 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> Am I missing something here? Do they actually mean "either of the following two commands"? Robert PS: Does 'lazarus.local.' look like a normal response from 'hostname' or should it be just the plain name 'lazarus'? -- 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]
