MySQL Error: 1142, SELECT command denied to user

So I went through the error while migrating one of the app to cloud. The full error statement goes like : MySQL Error: #1142. Response form the database. SELECT command denied to user “username@ip” for table “table1” From the error statement it looks like that ‘SELECT’ access is missing for the user for that particular … Read more

Different star pattern in Python

In this post we will discuss about different basic star pattern in Python. These are very basic and beginners programs, let me know in case you want me create more shapes and patterns. Star pattern : 1 * * * * * * * * * * * * * * * Program to implement … Read more

C++ program to concatenate two Strings using Pointer

In this post we will write a simple C++ program to concatenate two strings using Pointer, the code is self explanatory with comments for better understanding. Write a C++ program to concatenate two Strings using Pointer: You can also execute this code on our online compiler.   #include <iostream> using namespace std; int main() { … Read more

Shell script to check MySQL Replication Status

Working as MySQL DBA I’ve faced the MySQL replication issue almost every other day, I would say one of the weak point of MySQL RDBMS is the replication and replication down/delay is one of the most common error which can be seen in MySQL replication setups. Let’s discuss how as a DBA or as site … Read more

How to restore single database from MySQLdump

In this post we will discuss about how to restore single database from a full backup dump taken using mysqldump. I’m writing this post because as a MySQL DBA I have faced this scenario where we have a full backup file with more than 100 databases backup, and we are required to restore a single … Read more

UGC NET EXAM PATTERN 2022

Hello Learners, Today I am writing this post for the beginners who wants to make their career in Education field or go for higher studies specially for UGC NET/SET/JRF for the year 2022. Firstly in this blog we focus on the UGC NET exam and discuss about the pattern and the syllabus for this exam … Read more