Database Archive

How To Create a New User and Grant Permissions in MySQL

Here i will give you quick overview of how to create Mysql user and how to set their permissions. As you know MySQL is an open-source database management software that helps users store, organize, and later retrieve data. It has a variety of options to grant specific users permissions for the tables

MySQL Commands For Database Administration

In this article we’ve compiled some very useful ‘mysqladmin’ commands that are used by system/database administrators in their day-to-day work. You must have MySQL server installed on your system to perform these tasks. How to change MySQL root password: If you want to change MySQL password, then you need to type the

MySQL Database Commands

Today i am going to show you MySQL commands for performing database opertaions. There are few points which we need to keep in mind: All MySQL commands end with a semicolon ; if the phrase does not end with a semicolon, the command will not execute. Also, although it is not required,

MySQL Storage Engines

Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends using it for tables except for specialized use cases. (The CREATE TABLE statement in MySQL 5.7 creates InnoDB tables by default.) Each storage engine has its

MySQL Interview Questions Part 2

After writing interview questions for beginers, i am going to write some interview questions for experienced guys. Here i am picking up some questions which generally asked in interviews:   1- What is REPLCAE statement, and how do I use it? The REPLACE statement is the same as using an INSERT INTO command.

How to Take Backup and Restore a MySQL Database

It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard before upgrading a MySQL installation, and they can

20 MySql Interview Questions for Beginers

MYSQL database is the one of the popular open source database used mainly with PHP and other online web aplications. I am going to give you some MySQL questions with answers which will help you in interview as well as brushup your MySQL sills with fast review of these questions. 1-What are