Try this: GRANT USAGE ON *.* TO 'openpne'@'locahost' IDENTIFIED BY 'openpne' ;
Or try this: create user 'openpne'@'localhost' identified by password 'openpne'; - Spell domain correctly - there was a typo - put quote around userid and domain -----Original Message----- From: Padmanabhan G [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 3:18 AM To: mysql@lists.mysql.com Subject: Password hash should be a 41-digit hexadecimal number hi Issuing the grant command yields an error: mysql> create user [EMAIL PROTECTED] identified by password 'openpne'; Error 1372: Password hash should be a 41-digit hexadecimal number -- With Thanks & Regards G. Padmanabhan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ******************************************** This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. ******************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]