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 [...]
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 [...]
MariaDB: Webmin MySQL Startup Script /etc/rc.d/init.d/mysqld Was Not Found
MariaDB, the enhanced in-place upgrade of MySQL database management system, is getting more popular each passing day. We [...]
How to Backup and Restore (Export and Import) MySQL Databases Tutorial
phpMyAdmin can be used to export or backup MySQL or MariaDB databases easily. However, if the database size [...]
Duplicate, Copy or Backup Tables in MySQL, MariaDB, Oracle, PostgreSQL, DB2 and SQLite with Create Table As SQL
In Oracle, PostgreSQL, DB2, MySQL, MariaDB and SQLite database system, there is a nice command feature called Create [...]