Solution to login failure after adding a common user in MySQL

Install openstackfolsom today. After installing mysql, add the corresponding database and user for each service, and you will find that you cannot use the new user to log on to mysql. I added

Install openstack folsom today. After installing mysql, Add corresponding databases and users to each service, and you will find that new users cannot log on to mysql. I added

Install openstack folsom today. After installing mysql, add the corresponding database and user for each service and find that new users cannot log on to mysql. The method for adding users is as follows:

Mysql-uroot-p $ MYSQL_PASS <
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;
Failed to log on to EOF but using the user:

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!