Databases

»»»Databases

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 Error occurred while attempting to initialize the Borland Database Engine (error $2501) An Error occurred while attempting to initialize [...]

By | 2017-06-08T00:19:28+00:00 June 8th, 2017|Categories: Databases|Tags: |0 Comments

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 and noninteractive use. The hard part of using mysql is that the administrator needs to remember the SQL command [...]

By | 2016-12-09T08:38:23+00:00 December 9th, 2016|Categories: Databases|Tags: , |0 Comments

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 SQL query or SQL statement in the Info column. The limited and trimmed length of SQL statement may prevent [...]

By | 2016-12-09T08:38:43+00:00 December 9th, 2016|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 popular open-source web platform and apps. MariaDB is intended as the enhanced drop-in replacement for MySQL, so that developers [...]

By | 2016-12-09T08:39:12+00:00 December 9th, 2016|Categories: Databases|Tags: , |1 Comment

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 popular open-source web platform and apps. MariaDB is intended as the enhanced drop-in replacement for MySQL, so that developers [...]

By | 2016-12-09T08:39:12+00:00 December 9th, 2016|Categories: Databases|Tags: , |0 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 the database of the virtual servers. When attempting to manage database of a virtual server via "Edit Databases," Virtualmin [...]

By | 2016-12-09T08:39:14+00:00 December 9th, 2016|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 decide to upgrade from MySQL, which comes preinstalled in CentOS, to MariaDB 5.5, and subsequently to MariaDB 10, the [...]

By | 2016-12-09T08:39:14+00:00 December 9th, 2016|Categories: Databases|Tags: , , , , , , , |0 Comments

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 be asked to create a new database for your company. However, when creating the database, Odoo returns the following [...]

By | 2016-12-09T08:39:14+00:00 December 9th, 2016|Categories: Databases|Tags: |1 Comment

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 2012 or Microsoft SQL Server 2014 database, including SQL Server Express, Standard, Web, Workgroup, Business Intelligence, Developer and Enterprise [...]

Pin It on Pinterest