How to Transfer All MySQL Databases From Old to New Server
Transferring or Migrating a MySQL/MariaDB database between servers usually takes only a few easy steps, but data transfer can take
MySQL Tips
How to Change Default MySQL/MariaDB Port in Linux
In this guide we’ll learn how to change the default port that MySQL/MariaDB database binds in CentOS 7 and Debian-based
How to Check MySQL Database Size in Linux
In this article, I will show you how to check the size of MySQL/MariaDB databases and tables via the MySQL
12 MySQL/MariaDB Security Best Practices for Linux
MySQL is the world’s most popular open source database system and MariaDB (a fork of MySQL) is the world’s fastest
How to Connect to MySQL Without Root Password on Terminal
Normally while installing MySQL/MariaDB database server on Linux, it’s recommended to set a MySQL root user password to secure it,
How to Test PHP MySQL Database Connection Using Script
MySQL is a popular database management system while PHP is a server-side scripting language suitable for web development; together with
MyCLI – A MySQL/MariaDB Client with Auto-completion and Syntax-highlighting
MyCLI is an easy-to-use command line (CLI) interface for the popular database management systems: MySQL, MariaDB, and Percona with auto-completion
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