[Solved] How To: Install Percona XtraDB Cluster 8.0 on Ubuntu 20.04LTS

Percona XtraDB Cluster 8.0 on Ubuntu 20.04LTS Percona XtraDB Cluster is a database clustering solution for MySQL. It ensures high availability, prevents downtime and data loss, and provides linear scalability for a growing environment. This is very efficient in managing data and replicating it between nodes. It can be a life saver in many ways …

Read more

ERROR 1045 (28000): Access denied for user ‘username’@’%’ (using password: YES)

The above given is a simple error which shows that the user don’t have access to login from the console but this can turn into a nightmare if you were able to login a couple of moments ago and now you are getting this error. After a couple of moment when you enter a command show databases and you only get test database and nothing else, you will certainly knock your head in the wall. but keep calm take a deep breath, think twice and then shutdown the MySQL Server.

Go to /etc/my.cnf

Read more