Menu
TAG

MySQL series

Create New MySQL User With Password And Grant Permissions
MySQL series 3 min read

Create New MySQL User With Password And Grant Permissions

MySQL databases handle all the data for websites and apps. Security is of extreme importance when it comes to handling data. So far we have been using the root user for everything. But in real websites, the root user is never used as it has access to all databases. This means that if the root user is compromised, it could result in damage to all databases. So for the security purposes, we should create a new user with password in MySQL. Also Read Import & Export databases

MySQL seriesUncategorizedhow-to
Import & Export Databases In MySQL Ubuntu CLI - Part 5
MySQL series 2 min read

Import & Export Databases In MySQL Ubuntu CLI - Part 5

In this article of MySQL series, we’ll learn to import & export DBs. When you work with SQL, you will often be taking a backup of your databases. You will also be importing previously taken backups. All of this is an integral part of learning MySQL. Exporting a Database We first need a database that can be exported. You can see in the image below that I have a database named theitstuff. We will be exporting it here. To export the database we need to open our command line and ty

MySQL seriesUncategorizedhow-to
Inserting Data Into Tables - MySQL Series Part 4
MySQL series 2 min read

Inserting Data Into Tables - MySQL Series Part 4

Data insertion is very important in understanding MySQL databases. If the right data is not inserted in the right columns, we may get a lot of errors. Let us quickly create a small employee table by running the following command. create table employee(name varchar(20), city varchar(10), salary int); Once we are done with creating the table we can start inserting some data into it. Follow the complete MySQL Series here. Inserting Single Record To insert one record in

MySQL seriesUncategorizedtutorial
Creating and Modifying Tables - MySQL Series Part 3
MySQL series 4 min read

Creating and Modifying Tables - MySQL Series Part 3

Today we’ll continue our MySQL series and learn how to create and modify tables. MySQL tables are the containers that actually hold data. A table with multiple columns and records can be seen as an excel sheet. In this article, we will try to create some tables that can hold our data and also modify them. So fire up your mysql command line clients and Let’s learn.   Creating Tables The first thing we will do is create a table. To do this we need to select the database we w

MySQL seriesUncategorizedtutorial
Data Types & Data Modelling In MySQL - MySQL Series Part 2
MySQL series 3 min read

Data Types & Data Modelling In MySQL - MySQL Series Part 2

In this article, we will be learning about the various data types in MySQL and also how data modeling is done. I am assuming you have a working instance of MySQL on your computer. If not, you can read the step by step installation instructions. Data Types in MySQL MySQL is very rich when it comes to data types. There are a wide variety of options available to efficiently store and retrieve data. The following data types are most commonly available. * INT– For storing integ

MySQL seriesUncategorizedtutorial
How to Install MySQL in Ubuntu
MySQL series 4 min read

How to Install MySQL in Ubuntu

The Internet is a wild animal. Hungry enough to consume all the data in the world, and still be left wanting for more. Internet was very different earlier. The demand and supply for data was fulfilled in mostly using files that were often manually created. But once enough people were on the internet, the need for data was getting out of manual control. This led to the usage of database systems in websites and application. One of the oldest, most popular and widely used database syst

MySQL seriesUncategorizedhow-to