An article to explain by example about Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY

A quick start guide to MySQL database administration.

Here we are mainly in the introduction of ways to reset or recover MySQL Root Password in a Linux and Windows Server.

Premise: a ssh login permission owned Working steps: Download putty, set its ssh login option After logining, go onto home directory * (accessed via ftp) Execute “mysqldump” command to perform database backup, while “mysqlrestore” command would help you to restore database.

In a MySQL database, there may be several tables that are interrelated. We here continue to use the previous examples of the staff including some basic information such as the name, gender, date of birth, place of birth. We then create a table that is used to describe a staff who has published some articles, including author names, article title, publication date.

Basic article on using the MySQL 5.6 InnoDB to memcached feature

In this paper, we will introduce a function of the joint Merge train in SQL SERVER2005 by using an XML technology. DECLARE @ idoc int DECLARE @ doc xml SET @ doc = ‘

1. Start and Stop MySQL Services net stop mysql net start mysql 2.Login into MySQL MySQL- uusername – ppassword Entering the command of MySQL-uroot-p, entering your password, then you can enter into in MySQL. The prompt of MySQL is: mysql > Notice: if you are going to connect to another machine, you need to add a parameter -h machine IP

MySQL Cluster Setup and Replication between NDB and Non NDB Engines

MySQL is fully networked cross-platform relational database system, and is a client / server architecture of distributed database management system. MySQL is fully networked cross-platform relational database system, and is a client / server architecture of distributed database management system. It has the strong function, easy to use, easy management, running speed, security, reliability, etc., the user can use to access MySQL database in many language programs, especially in combination with the php is gold, the use of a wide range.

Very detailed article about setting up and configuring semisynchronous replication with MySQL 5.5

In the course of using the SQL Server database, we often encounter the case of very large logs, in the face of such problems, we give you about the two methods to resolve.

Detailed description of the steps required to update to the new InnoDB table format (and how to regain used disk space)

Much has been written about tools to inspect Linux systems, and much has been written about Solaris’s Big Important Tools such as DTrace. But I don’t recall seeing much in the MySQL blogs about basic tools to find one’s way around a Solaris system and discover the system, get fundamental performance, configuration, and status information, and so on. Here’s a quick list of some key tools.

There are many ways you can replicate MySQL data, whether it be a simple two-node cluster, chain or master/master. This article explains the two types of data replication (Statement-Based Replication and Row-Based Replication) available in MySQL.

Very insightful article about the potential pitfalls of using virtual IP addresses for clustering and HA

How to generate nice looking charts using Google charts and SQL.

A nice collection of resources for various data sets to create tables for testing and benchmarking purposes

Escaping “Lesson Learned” dealing with MySQL Databases & Case Sensitiviy: I feel MySQL should not allow upper cases. What do you think?

reports