Category: Database

0

How To List MySQL Tables with “show tables” SQL Query

MySQL stores given relation data in tables. While using tables we generally need to check and list existing tables. We can use different ways to list tables. In this tutorial we will learn how to use show tables and Select table_name in order to list and print table names. Connect MySQL Interactive...

0

How To Install MySQL On Ubuntu, Debian, Mint Kali

MySQL is free and opensource database server which is very popular in opensource community. MySQL is used by alot of applications and companies like Facebook, Google etc. In this tutorial we will learn how to install MySQL into deb or apt based distributions like Ubuntu, Debian, Mint and Kali. This guide can...

0

“ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock'” Error and Solution

MySQL service provides different connection methods. We generally prefer TCP/IP way where connection is established over Network Socket. There is alternative way named Socket which is connected over local system. During connection we may get error like Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ . In this tutorial we...

0

What Is MySQL Default Port Number?

MySQL is very popular database in the opensource community. While developing applications or connecting MySQL database we need to specify the MySQL port implicitly or explicitly. In this tutorial we will learn MySQL default port number and alternative port numbers. TCP 3306 The default port for the MySQL service is...

0

How To Define, Add, Create User For Postgres or PostgreSQL Server?

PostgreSQL Database Server have a lot of tools to manage the suite. Creating user is one of the most popular issue to manage Postgres Database. In this tutorial we will examine how to create user with different rights, privileges, database. We will mainly follow createuser tool for these and createuser is a...

1

How To Dump Mongodb By Using Mongodump Tool with Examples

Mongodb provides a lot of flexibilities to the application developers and system administrators. As we know mongodb is an nosql database server. Standard Sql database servers provides different tools to dump and backup given database. Mongodb provides mongodump tool for dump and backup operations. Check MongoDB Service Status First we should...

0

Redis Cli Tool

Redis have two main usage types. One is using API provided by redis these API’s can be used by different programming languages like Python, Php C#, Java etc. Other way to interact with redis is using cli tool named redis cli. Redis cli provides simple command line interface to test,...

0

Install Redis To Linux, Ubuntu, Debian ,Fedora, CentOS, RedHat

Redis supports different operating system and Linux distributions. We will look how to install and start redis in Linux distributions Ubuntu, Debian, Fedora, CentOS and RedHat in this tutorial. Install Fedora, CentOS, RedHat We can install redis server on Fedora, CentOS and RedHat with the following yum command.

Install Ubuntu,...

Enjoy this blog? Please spread the word :)