MySql Tutorial

Database security needs the allowing or disallowing user actions on the database and the objects within it. When a user will create a database application, the security policy is the first step. An application security …

Here, in this section you will study about different general security issues in MySQL. Security Guidelines Always keep in mind the following security guidelines before working with MySQL. Do not permit or allow anyone to access the …

Here, in this section you will study about different Access Privilege Systems. Privileges Provided by MySQL Here, MySQL provides privileges that apply in different contexts and at different levels of operation: Administrative privileges allow users …

Here , in this section you will learn about User Account management in different ways. UserNames and Passwords MySQL stores accounts in the user table of the mysql database. An account is defined in terms …

A transaction is a logical unit of work that contains one or more SQL statements. Transactions are atomic units of work that can be committed or rolled back. When a transaction makes multiple changes to …

To understand the concepts of a transaction take an example of CSIT banking database. Suppose a user transfers money from his/her savings account to his current account the statement will be divided into four blocks: …

ACID stands for Atomicity, Consistency, Isolation and Durability. It is a set of properties that guarantee that database transactions are processed reliably. In MySQL, InnoDB storage engine supports ACID-compliant features. Atomicity: The atomicity aspect of the …

MySQL in version 5.6 supports local transactions means within a given client session through statements such as SET autocommit, START TRANSACTION, COMMIT, and ROLLBACK. Syntax of START TRANSACTION, COMMIT, and ROLLBACK: START TRANSACTION transaction_characteristic [, …

In MySQL some statements cannot be rolled back. DDL statements such as CREATE or DROP databases, CREATE, ALTER or DROP tables or stored routines. You should design a transaction without these statements. The statements listed …

InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ROLLBACK. The SAVEPOINT statement sets a named transaction savepoint with a name of identifier. If the current transaction has a …

MySQL allows client sessions to acquire table locks explicitly for the purpose of cooperating with other sessions for access to tables, or to prevent other sessions from modifying tables during periods when a session requires …

SET [GLOBAL | SESSION] TRANSACTION transaction_characteristic [, transaction_characteristic] … transaction_characteristic: ISOLATION LEVEL level | READ WRITE | READ ONLY level: REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE Let us describe you the …