Blog / Database / MariaDB / MongoDB / MS SQL / MySQL / Oracle / PostgreSQL / SQlite
by İsmail Baydan · Published 17/09/2018
SQL or Structured Query Language is a standard language used to to create, list, update, delete databases, tables, records. It provides this functionality with different type of commands. In this tutorial we will learn popular and useful SQL commands. Command Types SQL language is very advanced language which provides large...
Database / MariaDB / MongoDB / MS SQL / MySQL / Oracle / PostgreSQL / Redis / SQlite
by İsmail Baydan · Published 01/09/2018
SQL provides different statements in order to select into existing table, variable, temp table in various database servers like Oracle, MySQL, PostgreSQL etc. In this tutorial we will examine how to use Select Into SQL statement for different cases. Syntax Select Into statement syntax is the same as with Select syntax....
MySQL provides ability to create and users from its shell. Security is important part of the database servers. In this tutorial we will examine how to create users and manage privileges in MySQL database server. We will specifically learn restrict user access to a database, database server, grant different type...
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 according to these version numbers. In this tutorial we will look how to list MySQL and MariaDB database server versions....
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...
Blog / Database / Debian / Kali / Linux / Mint / MySQL / Ubuntu
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...
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...
Blog / Database / Linux / MariaDB / MySQL
by İsmail Baydan · Published 13/02/2018 · Last modified 08/12/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...
Blog / CentOS / Debian / Fedora / Kali / Linux / Mint / PostgreSQL / RedHat / Ubuntu
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...
Blog / CentOS / Debian / Fedora / Kali / Linux / Mint / PostgreSQL / RedHat / Ubuntu
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...
