Doing a :
mysql> show grants for root@localhost;
+---------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost
| |
+---------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD
|'6ffc60a31940f7bd' WITH GRANT OPTION |
+---------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
However I can't find anywhere in the docs about IDENTIFIED BY PASSWORD
(the PASSWORD part in particular)
I looked here:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#GRANT
and
http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#Adding_users
thanks,
-- Andrew