Robert, 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? Normally, once you've set the root password you don't need to set it again. If you garble the password and cannot access the root account restart MySQL and bypass the GRANT tables (see below for direction). If you need more help, let me know. I'm running 4.0.15 on a 12" PB with OS X 10.2.8 (get that system patch brother!). # See what MySQL processes are running. ps -aux | grep -i mysql # Enable the sudo construct (you will need to enter your OS X password) sudo -v # Start MySQL and without using the grant tables. sudo mysqld_safe --user=mysql --skip-grant-tables & # Assign a new root password (ONLY do this ONCE) mysqladmin -uroot password 'password' # Access MySQL as root. You will be prompted to enter root's password. mysql -uroot -p Regards, Adam -----Original Message----- From: Robert Lund [mailto:[EMAIL PROTECTED] Sent: Saturday, October 18, 2003 8:32 PM To: [EMAIL PROTECTED] Subject: OS X - can't set root password I just installed 4.0.15 on an iBook running Mac OS X 10.2.6. I started the daemon using bin/mysqld_safe, and then tried to initialize the root password as instructed. The first, bin/mysqladmin -u root password ****** ran apparently successfully. When I tried to execute the second: /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password ****** the response was: /usr/local/mysql/bin/mysqladmin: connect to server at 'lazarus.local.' failed error: 'Host '192.168.1.100' is not allowed to connect to this MySQL server' That is the IP address assigned my Mac by my DSL router; and its name is 'lazarus'. Where can I find out the source of this permissions gap and how the channel might be opened up? Thanks -- 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]
