How To Create, Check And Change Identity Column In Microsoft SQL Server
Microsoft SQL Server has built-in an identity column (fields) which used for generating key values. It may refer [...]
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 [...]
Error $2501 & $210D While Attempting to Initialize Borland Database Engine (BDE)
When using applications that utilize Borland Database Engine (BDE), one of the following error messages may occurred: An [...]
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 [...]
