Issuing this command: > mysql>SET PASSWORD FOR 'root'@'localhost' = PASSWORD xxxxxxxxxx
set your password to xxxxxxxxxx You will need to use mysql -u root -p xxxxxxxxxx from the local machine to get access with the root user. This: mysql -u root -p is specifying a blank password. I believe that this: mysql -u root will prompt you for the password without echoing it to the screen. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]