Solution:
vi /etc/my.cnf.d/openstack.cnf # If you don't have this, fix my.cnf or Baidu 'Centos modify MariaDB configuration file'
Comment out the original assignment of bind-address
and change it to
bind-address=0.0.0.0
Resolution process backtracking
There are old problems when deploying t version keystone. The troubleshooting process is as follows
PS: dual node, hostname – > controller -> 10.0.0.11
1.Troubleshoot MySQL command access rights
a. mysql -h localhost -u<db_name> -p<db_pass> -e 'show databases;'
b. mysql -h controller -u<db_name> -p<db_pass> -e 'show databases;'
c. mysql -h 192.168.75.128 -u<db_name> -p<db_pass> -e 'show databases;'
d. mysql -h 10.0.0.11 -u<db_name> -p<db_pass> -e 'show databases;'
Result: b, d not pass
2. troubleshoot Mysql table
MariaDB [(none)]> select host,user from mysql.user; # Grant localhost & %
Add:
MariaDB [(none)]> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'controller' IDENTIFIED BY 'keystone';
MariaDB [(none)]> flush privileges;
Result: No (This method solved some problems when deploying R version)
3. troubleshoot the Mysql configuration file
vi /etc/my.cnf.d/openstack.cnf
bind-address=192.168.75.128 change to bind-address=0.0.0.0
Outcome: ok
Similar Posts:
- [Install OpenStack] Sync keystone database error: keystone DBConnectionError: (pymysql.err.OperationalError) (2003, “Can’t connect to MySQL server on ‘controller’ ([Errno 111] Connection refused)”)
- When Navicat connects to a database on a server, there is an error prompt: 1130 ‘* *’ host is not allowed to connect to this MySQL server
- mysql 1449 The user specified as a definer does not exist
- [Solved] MYSQL8.0 Error: the user specified as a definer (‘root’@’%’) does not exist
- mysql ERROR 1044 (42000): Access denied for user ‘
- ERROR 1820 (HY000): Unknown error 1820 [How to Solve]
- ERROR 1044 (42000): Access denied for user ‘root’@’localhost’
- [Solved] Mysql Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’
- [Solved] Ubuntu mariadb root access denied after mysql_secure_installation
- MYSQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements