12:52:12 119 Aborted connection 119 to db: 'nova_api' user: 'nova' host: 'controller001' (Got an error reading communication packets) 12:52:12 116 Aborted connection 116 to db: 'nova' user: 'nova' host: 'controller001' (Got an error reading communication packets) 12:52:12 118 Aborted connection 118 to db: 'nova_api' user: 'nova' host: 'controller001' (Got an error reading communication packets) 12:52:12 112 Aborted connection 112 to db: 'nova' user: 'nova' host: 'controller001' (Got an error reading communication packets) Mysql log after restarting nova services: sudo systemctl restart sudo tail -f /var/log/mysql/error.log Have access to databases remotely from compute node: mysql -unova -popenstack -h controller001 | GRANT ALL PRIVILEGES ON `nova_api`.* TO | | GRANT ALL PRIVILEGES ON `nova_cell0`.* TO | Grant all permissions for those databases: MariaDB > SHOW GRANTS FOR nova In the below section improve database permission confgured correctlyĭatabases are created properly: sudo mysql This LAB is running on VirtualBox and I have another LAB with the same configuration and Openstack version on ESXi without any problem.Īt this point one controller with two compute node. This is the IP Address of the source system which connects to the database server.I installed Openstack Wallaby using OpenStack Installation Guide, all command and configuration is on my Github. While connecting to such a database we need to give access to the HOST IP ADDRESS to connect to it. This is a very common error that occurs while connecting to a remote database. Host doesn’t not have permission to connect database
You might encounter the error in due to the following scenarios – Entered wrong password
To fix this, you can update the host name for the user using the code below – mysql> mysql -u root -pabc -h -P 3306 You can use this code to view details of the user – You will encounter Error 1045 in this case. You might be trying to access the server from a host that is different from the defined host name. If the user does not exist, create it with the desired username. You can check if the user exists using the following code- MariaDB > select user from er where user like '%root%' Sometimes, the user you might be trying to access does not exist on the MySQL server. The primary method to fix this error is to enter the correct username and password using the following command – mysql –u username –p Let us look at the ways to fix this problem – Now the new password for root user is abc. Here is the code to set it – Login as user root with blank password You must set the root user password after performing the new installation. The best practice is to change the password after the new installation. Type '\c' to clear the current input statement. Server version: 10.4.11-MariaDB binary distributionĬopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. So, you can login to the MySQL server using the same password. The default password of MySQL is blank () (i.e. It arises when you perform a fresh installation of MySQL and try to login with a password. The error looks something like this - mysql -uroot -prootĮRROR 1045 (28000): Access denied for user (using password: YES) How to fix “Error 1045 (28000) access denied for user (using password: yes)”? In this article, we will look at the ways to resolve this error. Fixing these credentials can resolve this error in no time. This usually occurs when you enter an incorrect password or password for your database. MySQL users often face an issue called Error 1045 (28000) access denied for user (using password: yes).