Cannot connect to MySQL server on ‘localhost’: Cacti Error
Kedar
FATAL: Cannot connect to MySQL server on ‘localhost’: Cacti Error – Solution to the issue while setting-up.
Browsing Category
MySQL
113 posts
Articles related to MySQL, Percona Server, MariaDB
How-to extract from mysqldump | mysql-dump-splitter recipes
This post will answer how to extract database, tables etc from mysqldumpsplitter utility.
How to fix definer does not exist error 1449 MySQL
Explaining and providing solutions of MySQL error 1449: The user specified as a definer does not exist using SQL SECURITY INVOKER and DEFINER.
How to Restore / point in time recovery using binary logs MySQL
In this post I will share a recovery scenario of a MySQL database restore from the binary logs. This post is also a good example of how we can achieve…
MySQL grant syntax & dynamic database using wildcards
The MySQL grant syntax allows you to specify dynamic database names using the wildcard characters. This article explains the usecase of dynamic section of mysql grants.
Debugging Percona Xtradb (Galera) Cluster node startup / SST errors
A Percona Xtradb (Galera) Cluster node may fail to join it due to many possible mistakes causing SST to fail. It could be a configuration item or purely setup requirement. In this article we will be troubleshooting step by step the SST issues faced.