by İsmail Baydan · Published 15/06/2018
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...
by İsmail Baydan · Published 30/05/2018
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...
by İsmail Baydan · Published 13/02/2018
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...
by İsmail Baydan · Published 13/02/2018
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...
by İsmail Baydan · Published 27/01/2018
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...
by İsmail Baydan · Published 26/01/2018 · Last modified 27/01/2018
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 install PostgreSQL into Linux distributions like Debian, Ubuntu, Mint, Fedora, CentOS, RedHat by using different ways like package...
by İsmail Baydan · Published 11/07/2017
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 applications in order to run sql queries. Install Python MySQL Connector In order to connect MySQL database from Python application...
by İsmail Baydan · Published 05/07/2017
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...
by İsmail Baydan · Published 05/07/2017
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,...
by İsmail Baydan · Published 05/07/2017
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.
1 | $ yum install redis -y |
Install Ubuntu,...
