On Thu, 2004-07-08 at 00:19, Paul DuBois wrote: > At 22:34 +0530 7/7/04, Sanjay Arora wrote: > >I am using Mysql on RH Linux 9. I am getting the following error. > >Command and result are given below alongwith \s output for diagnostic > >purposes. > > > >I have created a dns database and am trying to create a user mysql user > >dns with all privileges on it. > > > >mysql> use mysql > >Reading table information for completion of table and column names > >You can turn off this feature to get a quicker startup with -A > > > >Database changed > >mysql> GRANT ALL PRIVILEGES ON dns.* TO [EMAIL PROTECTED] IDENTIFIED BY > >PASSWORD "dns"; > >ERROR 1133: Password hash should be a 16-digit hexadecimal number > > OMIT the word PASSWORD. > Thanks for replying. Query is executing now but does not seem to effect any changes in the database....0 rows affected!
How do I diagnose the problem? mysql> GRANT ALL PRIVILEGES ON dns.* TO [EMAIL PROTECTED] IDENTIFIED BY "dns"; Query OK, 0 rows affected (0.78 sec) With regards and thanks. Sanjay. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
