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 [...]
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 [...]
Convert PostgreSQL Template0 & Template1 Encoding to UTF8 (SQL_ASCII Incompatible)
After installing Odoo 8 (also known as OpenERP), and other web apps which runs on PortgreSQL databases, you'll [...]
Optimize SQL Server 2000 / 2005 / 2008 in Large RAM System by Locking Pages in Memory and AWE
Microsoft SQL Server is a data-intensive and disk I/O (read and write) intensive database management systems. For SQL [...]
Error Has Occurred While Establishing A Connection To SQL Server 2005 / 2008 / 2012 / 2014 Which Does Not Allow Remote Connections
When connecting to an instance of Microsoft SQL Server 2005 or Microsoft SQL Server 2008, Microsoft SQL Server [...]
Oracle PL/SQL ORA-00947 Not Enough Values Error
In Oracle database, the following error message may appear when an incorrect SQL statement is used, in SQL [...]