SQLS*Plus

Check the configuration before starting the MySQL server

MySQL Server supports the validate-config option, which allows checking the startup configuration for problems without starting the server in normal operation mode:If no errors are found,...

MySQL function indexes

MySQL indexes: Starting with MySQL 5.7, you can create indexes for expressions, or functional indexes using the generated columns. Basically you need to first use the generated column to define a...

MySQL DROP USER Statement

The DROP USER statement is used to delete a user from a MySQL database. Syntax of DROP USER statement in MySQL DROP USER user_name; Options and arguments of the statementuser_name - the...

MySQL CREATE USER Statement

The CREATE USER statement creates a database account that allows you to log into a MySQL database. Syntax for CREATE USER statement in MySQL CREATE USER user_name IDENTIFIED BY [ PASSWORD ]...

How to control MySQL and SSH service with Monit on Linux

If you tried to control services manually on Linux servers then here is the solution for you. First of all you will need to install Monit on Linux.We can set up Monit to check the Tomcat and...

Oracle %ROWTYPE attribute

In Oracle PL/SQL, the %ROWTYPE attribute provides a record type representing a string in the Oracle database table (or view).A record may store an entire string of data selected from the...

Query MySQL from SQL Server using a linked server

SQL Server has an interesting feature called Linked Servers. It is about linking other databases to SQL Server and using their data as local. There are many powerful open source systems written...

MySQL Security – Random Password Generation

Thinking about security in MySQL installation, you can consider a wide range of possible procedures/recommendations and their impact on the security of your MySQL server and related...

Architecture of InnoDB thread with related variables in MySQL 8

In this post we are going to share the MySQL 8 InnoDB architecture diagram with related variables.From the official MySQL document we have seen some InnoDB variables related to MySQL 8.0.20....

MySQL 8.0. Security – support for two passwords

Reflecting on security in MySQL installation, you can consider a wide range of possible procedures/recommendations and their impact on the security of your MySQL server and related...

MySQL Row Count: How to get the number of lines in MySQL

In this post you will learn how to get the number of MySQL lines in a database. Getting the number of MySQL rows in one table To get the number of rows per table, you use the COUNT(*) operator...

Optimized permanent minimization in MySQL 8.0

In MySQL 8.0.16 optimizer has improved again! Comparisons of columns of numeric types with constants are checked and stacked or deleted for invalid values or values that are out of...

Encryption of stored data in MySQL 8

MySQL 5.7.11 introduced transparent encryption for InnoDB table space, which included support for table space files. Later, encryption for the shared table space was introduced in MySQL...

Creating databases and tables using SQL commands

This article will show you how to create new databases and tables using SQL commands in a mysql client. It is assumed that this tool is running and connected to the MySQL database...

Why should the MySQL GROUP CONCAT function be used?

This is the function MySQL GROUP CONCAT and how it can change the work with query results. Especially if the database is the data source for the application. Database I will use the Sakila...

How to specify table size in MySQL database

It takes 2 actions to determine the size of tables in a database from a command line hosted on a MySQL or MariaDB server:1. Connect to the database server with the command: mysql -u root -p...