How to Change a Default MySQL/MariaDB Data Directory in Linux
After installing the components of a LAMP stack on a CentOS/RHEL 7 server, there are a couple of things you may want to do. Some of them have to do with increasing the security...
Category: MySQL
How to Change Root Password of MySQL or MariaDB in Linux
If you’re installing MySQL or MariaDB in Linux for the first time, chances are you will be executing mysql_secure_installation script to secure your MySQL installation with basic settings. One of these settings is, database...
How to Reset MySQL or MariaDB Root Password in Linux
If you are setting up a MySQL or MariaDB database server for the first time, chances are you will be running mysql_secure_installation soon afterwards to implement basic security settings. One of these settings is...
Learn How to Use Several Functions of MySQL and MariaDB – Part 2
This is the second part of a 2-article series about the essentials of MariaDB / MySQL commands. Please refer to our previous article on this topic before proceeding. Learn MySQL/MariaDB Basics for Beginners –...
Learn MySQL / MariaDB for Beginners – Part 1
In this article we will show how to create a database (also known as a schema), tables (with data types), and explain how to perform Data Manipulation Language (DML) operations with data on a...
MySQLDumper: A PHP and Perl Based MySQL Database Backup Tool
MySQL is one of the most popular database in the world. This database can be installed on the Microsoft Windows platform besides of Linux platform. Why this database is so popular? It may caused...
4 Useful Commandline Tools to Monitor MySQL Performance in Linux
There are plenty of tools to monitor MySQL performance and troubleshoot a server, but they don’t always perfect match for a MySQL developer or administrator’s for their common needs, or may not work in...
Adminer – A Advanced Web Based Databases Administration Tool for Linux
We always interact with the databases to perform tasks in various way. We may connect directly and execute the tasks using SQL CLI mode or non-DBA user prefer to use GUI tools called phpMyAdmin...
10 MySQL Database Interview Questions for Beginners and Intermediates
In our last article, we’ve covered 15 Basic MySQL Questions, again we are here with another set interview questions for intermediate users. As we said earlier these questions can be asked in Job Interviews....
15 Basic MySQL Interview Questions for Database Administrators
Prior to This Article, three articles has already been published in ‘Linux Interview‘ Section and all of them were highly appreciated by our notable readers, however we were receiving feedback to make this interactive...
