[Solved] MySQL User Operation - ERROR 1396 (HY000): Operation CREATE / DROP USER failed for 'user'@'host'

Error Message: ERROR 1396 (HY000): Operation CREATE USER failed for 'admin'@'%' Generic Error Message:Operation %s failed for %s Error Scenario:Operation CREATE USER failed Operation DROP USER failed Reason:The reason for this error is, you are trying to do some user operation but the user does not...

MySQL Replication Notes

The MySQL Replication was my first project as a Database Administrator (DBA) and I have been working with Replication technologies for last few years and I am indebted to contribute my little part for development of this technology. MySQL supports different replication topologies, having better understanding...

[Solved] Unable to start SQL Server Service after applying service pack Error: Script level upgrade for database 'master' failed because upgrade step 'ISServer_upgrade.sql' encountered error 5069, state 1, severity 16

Problem:SQL Server service not starting after service pack / cumulative update installation.Error Message:Script level upgrade for database 'master' failed because upgrade step 'ISServer_upgrade.sql' encountered error 5069, state 1, severity 16. This is a serious error condition which might interfere...

How to set up MySQL InnoDB Cluster? Part One

This post is about setting up MySQL InnoDB Cluster with 5 nodes on a sandbox deployment.  Here, we focus on implementation part, the core concepts will be explained in separate posts. Prerequisites: MySQL Engine MySQL Shell MySQL Router Deploying MySQL InnoDB Cluster involves the following...