Linux, Windows, Security, Programming, Network Tutorials
Database systems are an important part of the IT system. Relational Database Management System is a database that mainly stored data in a relational model by creating different relations between different data. Relational Database Management Systems simply called RDMS. RDMS mainly uses the Structured Query Language simply SQL in order to store and query data. … Read more
XAMP is a popular software that provides some tools to run a website. These tools names first letters created the XAMP where X is used for both Linux and Windows, A for Apache Webserver, M for MySQL Database Server, P for PHP Programming Language and Interpreter. Also, some extra tools are provided to complement Apache, … Read more
MySQL is the most popular open-source database in the world. MySQL is a Relational Database Management System (RDMS) which is used to store data in a relational manner inside different tables. What makes MySQL different is it is production-ready enterprise-level features without a cost or lower costs. The name of the MySQL comes from the … Read more
MySQL or MariaDB database servers can be managed in different ways. Generally, GUI tools are provided because of their easiness. But in some cases, a command-line connection may be required to connect and manage MySQL and MariaDB database server. Install MySQL/MariaDB Client For Ubuntu, Debian, Kali, Mint We will start by installing MySQL/MariaDB command-line client … Read more
LAMP stack is a popular term in the IT world. It is used to express multiple application packages to server PHP applications. Here is the formula Linux+Apache+MySQL+PHP=LAMP . LAMP stack can be created by installing these components one by one. In this tutorial, we assume that we have already installed the Linux distribution like Ubuntu, Debian, … Read more
MySQL is a popular relational data that stores information 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 Shell … Read more
MySQL is a free and opensource database server which is very popular in the opensource community. MySQL is used by a lot 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 be used … Read more
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 TCP 3306. This port can … Read more
MySQL is a very popular and open source database server. Python is an old but lately discovered language. In this tutorial, we will look at how to use this popular tech in our applications in order to run SQL queries. Install Python MySQL Connector In order to connect the MySQL database from Python application, we … Read more
Backup and Restore operations are important part of the database administration. mysqlimport command is used to load data in file into Mysql or Mariadb servers. Mysql import is generally used by providing SQLfile. Syntax Syntax of mysqlimport is like below. mysqlimport OPTIONS DBNAME FILE OPTION is used provide detailed configuration DBNAME is the name of the database we … Read more