Category: Database

How To Check and Determine MySQL Database Server Version?

Posted on 13/08/201813/08/2018 by İsmail Baydan

MySQL or MariaDB is very popular opensource databases servers. While using these database servers we may need to know the version of the client or server. We can use features

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

Posted on 15/06/2018 by İsmail Baydan

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

How To Install MySQL On Ubuntu, Debian, Mint Kali

Posted on 30/05/201830/05/2018 by İsmail Baydan

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

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

Posted on 13/02/2018 by İsmail Baydan

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.

What Is MySQL Default Port Number?

Posted on 13/02/201808/12/2018 by İsmail Baydan

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

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

Posted on 27/01/201827/01/2018 by İsmail Baydan

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

How To Install PostgreSQL Server Into Linux, Debian, Ubuntu, CentOS, Mint, Fedora, Redhat?

Posted on 26/01/201827/01/2018 by İsmail Baydan

PostgreSQL is very popular open source database. It is used by big companies like Google, Facebook etc. PostgreSQL can be used without a cost. In this tutorial we will look

How To Connect MySQL Database From Python Application and Execute Sql Query with Examples

Posted on 11/07/2017 by İsmail Baydan

MySQL is very popular and open source database server. Python is old but lately discovered language. In this tutorial we will look how to use this popular techs in our

How To Dump Mongodb By Using Mongodump Tool with Examples

Posted on 05/07/201717/08/2018 by İsmail Baydan

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

Redis Cli Tool

Posted on 05/07/2017 by İsmail Baydan

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