Percona XtraDB Cluster 8.0 root password is not working on ubuntu 20.04 LTS Percona XtraDB Cluster 8.0 with MySQL 8.0 is no doubt a very good combination for a seamless and highly available database platform. Installation of Percona XtraDB cluster 8.0 on Ubuntu is simple and easy. Its just a few commands away with having … Read more
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
[Solved] How to install MySQL Server 5.7 on Ubuntu 20.04 LTS (Focal Fossa) UBUNTU 20.04 code named Focal Fossa is available for the general users and can be installed on anything physical or virtual. This is a pretty awesome operating system which gives liberty to the users to perform beyond limits. MySQL and Linux are … Read more
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