How to Change Auto Increment Value of MySQL / MariaDB Database
Almost all database tables have a unique column which serves as identifier and has a value that auto_increment [...]
How to Get Current Auto_Increment Sequence Number for MySQL / MariaDB Table
Most tables in database have a column with auto increment sequence number that serves as unique identifier for [...]
SQL Command to List & Show All Databases in MySQL & MariaDB
mysql is a simple and easy to use SQL shell with input line editing capabilities that supports interactive [...]
Display Full SQL Query in Show Processlist of MySQL
In MySQL database system, by default the SHOW PROCESSLIST query displays only first 100 characters of the running [...]
Disable Root Login in phpMyAdmin
phpMyAdmin is a very useful and powerful web-based GUI administration and management tool for MySQL and MariaDB database [...]
Upgrade MySQL to MariaDB 10 (Part 2 – Upgrade MariaDB/MySQL 5.5 to Version 10.0)
MariaDB is a relational database management system (rDBMS) that was forked from MySQL, the de-facto database for most [...]
Upgrade MySQL to MariaDB 10 (Part 1 – Install MariaDB 5.5)
MariaDB is a relational database management system (rDBMS) that was forked from MySQL, the de-facto database for most [...]
Virtualmin: You Do Not Have Access to This MySQL Database After Changing Password
After changing password of MySQL or MariaDB administration user, such as root, Virtualmin no longer has access to [...]
How to Read MySQL Binary Log Files (BinLog) with mysqlbinlog
MySQL database server generates binary log files for every transaction to the databases, provided administrator does not disable [...]
Check and Optimize MySQL Database Automatically with Crontab/Cron
MySQL is a very popular free yet powerful database system. But even in great databases, the tables may [...]