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!
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.