MyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.This will help us to write queries faster and easy which was written in Python prompt_toolkit. The REPL (Read,...
There are no changes in table or index formats on MariaDB 5.5, MariaDB 10.0 & MariaDB 10.1. So, most of the servers the upgrade should be painless from MariaDB 5.5 to MariaDB 10.0 &...
MariaDB is a drop-in replacement for MySQL. MariaDB is an opensource Relational Database Management System (RDBMS) which supports database access. MariaDB is a logical choice for database professionals looking for a robust, scalable, and...
MariaDB is a drop-in replacement for MySQL. MariaDB is an opensource Relational Database Management System (RDBMS) which supports database access. MariaDB is a logical choice for database professionals looking for a robust, scalable, and...
There are many ways that we can connect the remote MySQL/MariaDB database. You can use the GUI client called MySQL Workbench. Alternatively, we can access it right from Linux terminal. It’s very simple but...
Some times we may forget MySQL/MariaDB root user password. It’s happening everywhere. It’s human mistake and it known things. It’s happening for everyone and not only for me. If so, how to reset the...
A simple shell script can automate Linux admin job, which will reduce the human effort and save lots of time. As a server administrator you should take a regular backups of your databases. It...
MySQL/MariaDB is an opensource database management software, which is very famous, user friendly and widely used for data storage. This will allow the user to create a database, database user, grant different permission based...
This is a basic tutorial to help new users to learn about the MySQL/MariaDB database. In this tutorial, you will learn about database creation, database user creation and how to grant permissions to users....
