New mysql users cannot log on.

Install openstack folsom today. After installing mysql and adding corresponding databases and users to various services, you will find that
You cannot use the new user to log on to mysql. The method for adding users is as follows:
Mysql-uroot-p $ MYSQL_PASS <EOF
Create database nova;
Grant all privileges on nova. * TO 'nova '@' % 'identified BY '$ MYSQL_PASS ';
Create database glance;
Grant all privileges on glance. * TO 'glance '@' % 'identified BY '$ MYSQL_PASS ';
Create database keystone;
Grant all privileges on keystone. * TO 'keystone '@' % 'identified BY '$ MYSQL_PASS ';
Create database cinder;
Grant all privileges on cinder. * TO 'cinder '@' % 'identified BY '$ MYSQL_PASS ';
Create database quantum;
Grant all privileges on quantum. * TO 'quantum '@' % 'identified BY '$ MYSQL_PASS ';
Flush privileges;
EOF
However, User Login Failed.:
Root @ controller :~ # Mysql-h localhost-ukeystone-ppassword
ERROR 1045 (28000): Access denied for user 'keystone '@ 'localhost' (using password: YES)
Solution:
After adding a common user, run:
Mysql> use mysql
Mysql> delete from user where user = '';
Mysql> flush privileges;
Deletes anonymous users.
OK, get it done, enjoy!