Category: My SQL

Storage Engines Storage engines (underlying software component) are MySQL components, that can handle the SQL operations for different table types to store and manage information in a database. InnoDB is mostly used general-purpose storage engine and as of MySQL 5.5 and later it is the default engine. There are many storage engines available in MySQL…

Connectors and APIs MySQL Connectors provide connectivity to the MySQL server for client programs and APIs provide low-level access to the MySQL protocol and resources. You can connect and execute MySQL statements from another language or environment, including ODBC, Python, Perl, Ruby, PHP, Java (JDBC), and native C and embedded MySQL instances through connectors and…

MySQL Workbench is GUI based tool to work with MySQL Servers. You may use this for Server Administration, for creating Entity Relationship Diagrams and for SQL Development (run queries etc). This tutorial discusses how to perform basic MySQL Administration tasks using MySQL Workbench. Installing MySQL workbench To install MySQL Workbench on Linux (we used Ubuntu),…

installation on Linux and Windows In this section we are going to discuss how to install MySQL on windows and Linux machines. Download MySQLYou can download MySQL from http://dev.MySQL.com/downloads/. Install MySQL on Linux (RedHat and its variants) 1. After downloading the required RPM package, you have to run the appropriate package with root privilege. Syntax:…

Introduction MySQL is (as of July 2013) the world’s most widely used open-source relational database management system (RDBMS), enabling the cost-effective delivery of reliable, high-performance and scalable Web-based and embedded database applications. It is widely-used as the database component of LAMP (Linux, Apache, MySQL, Perl/PHP/Python) web application software stack. MySQL was developed by Michael Widenius and David Axmark in 1994. Presently…