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 [...]

By |2020-06-25T12:40:22-07:00Modified: June 25, 2020August 6th, 2017|Categories: Databases|Tags: , , |0 Comments

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 [...]

By |2020-07-01T21:59:30-07:00Modified: July 1, 2020January 27th, 2015|Categories: Databases|Tags: , |2 Comments

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 [...]

By |2020-07-12T12:47:32-07:00Modified: July 12, 2020January 9th, 2015|Categories: Databases|Tags: , , , |0 Comments

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 [...]

By |2020-07-10T23:45:02-07:00Modified: July 10, 2020January 9th, 2015|Categories: Databases|Tags: , , , , , , , |1 Comment

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 [...]

By |2020-06-12T04:46:42-07:00Modified: June 12, 2020March 18th, 2007|Categories: Databases|Tags: , , , |8 Comments
Go to Top