Hi folks, The following is copied exactly from my machine, except for the munged password. Setting the root password can't be completed, because the host apparently can't connect the mysql server. What am I doing wrong?:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h melody.yalemusic.ca password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting mysqld daemon with databases from /var/lib/mysql [EMAIL PROTECTED] local]# /usr/bin/mysqladmin -u root password 'xxxxxxx' [EMAIL PROTECTED] local]# /usr/bin/mysqladmin -u root -h melody.yalemusic.ca password 'xxxxxxx' /usr/bin/mysqladmin: connect to server at 'melody.yalemusic.ca' failed error: 'Host 'melody.yalemusic' is not allowed to connect to this MySQL server' [EMAIL PROTECTED] local]# Thanks, Rob Yale -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
