Hi, Did the usual RPM install, got the usual message
------------------------------------------------ [root@us-penguin MYSQL]# rpm -Uvh MySQL-4.0.3-0.i386.rpm Preparing... ########################################### [100%] 1:MySQL ########################################### [100%] Installing all prepared tables 020909 8:24:26 /usr/sbin/mysqld: Shutdown Complete 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 us-penguin 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 ------------------------------------------------ Setting the first password went easy ---------------------------------------------------------------- [root@us-penguin MYSQL]# mysqladmin -u root password 'FooBar' ---------------------------------------------------------------- But setting the 2nd password failed ------------------------------------------------------------------------ ----- [root@us-penguin MYSQL]# mysqladmin -u root -h us-penguin password 'FooBar' mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' ------------------------------------------------------------------------ ----- Doing a looksee at the user table ------------------------------------------------- mysql> select Host, User, Password from user; +------------+------+------------------+ | Host | User | Password | +------------+------+------------------+ | localhost | root | XXXXXXXXXXXXXXXX | | us-penguin | root | | | localhost | | | | us-penguin | | | +------------+------+------------------+ ------------------------------------------------- Any ideas ? -pete --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
