MySQL

1. Forget the root passwordEdit MySQL Master profile my.cnf in the [Mysqld] field to add parameters skip-grant, restart the database service, so that you can enter the database without authorization mysql-uroot, modify the corresponding user

Environment:Master:centos 6.3 192.168.1.4Slave:centos 6.3 192.168.1.5mysql:mysql-5.6.25MySQL using RPM Installation MethodInstallation Method Reference: http://www.cnblogs.com/xs104/p/4589041.htmlTo configure the primary database:After the

MySQL Sub-Library sub-table scheme1. Why Divide the table:When the data of a table reaches tens of millions of, the time you spend querying is much more, and if you have a joint query, I think I might die there. The purpose of the sub-table is to

The first step: Install dependent yum installed Perl-data-dumperStep Two: Initialize the internal information of the MySQL database./scripts/mysql_install_db--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data------------------Whether the

1. Create an administrative user for the MYSQLD database:To set the root user as an administrator, we should run the following command;123456In general, the Mysqladmin directory has been added to $path, if the command is not found, see if the

Linux Service Chapter VII: MySQL engine understanding, master-Slave principle and architecture configurationOne,MySQL engine understandMyISAM engineThe default table type, which is based on the traditional ISAM type, ISAM is an abbreviation for

Import and export MySQL database under LinuxHttp://www.cnblogs.com/jiunadianshi/archive/2011/04/20/2022334.html (this does not apply)------------------The actual adoption of success is Ok MySQL

1. Create a tableCREATE TABLE ' gas ' (' id ' INT (one) not null auto_increment, ' oil ' varchar) null DEFAULT null, ' district ' varchar (+) NULL Default NULL, ' price ' DOUBLE null default ' 0 ', PRIMARY KEY (' id ')) engine=innodbauto_increment=11

My system is Ubuntu, the default does not support MySQL remote link. The next steps change this.1, first cancel MySQL native bindingsEdit/ETC/MYSQL/MY.CNFComment "bind-address = 127.0.0.1"Sudo/etc/init.d/mysql Restart restart can be accessed

1 , add groups, and users# Groupadd MySQL# useradd-g MySQL MySQL2 , creating the installation directory# mkdir MySQL3 , upload MySQL installation package (I usually use Securefx)4 , unzip to the/mysql directory# Cd/mysql# chmod +x

MySQL replication is a great feature of MySQL, which copies data from one MySQL instance to another MySQL instance. The entire process is asynchronous, but due to its efficient performance design, the latency of replication is very small. MySQL

Install MySQL under Linux#需要的安装包 (in chronological order)libdbi-devel-0.8.1-2.1LIBDBI-0.8.1-2.1LIBDBI-drivers-0.8.1a-1.2.2Perl-dbi-1.52-2. El5perl-dbd-mysql-3.0007-2. El5mysql-5.0. the-4. El5_6.6MySQL-devel-5.0. the-4. El5_6.6MySQL-server-5.0. the-4.

MYSQL The index is divided into the following types: KEY or INDEX :A normal index is a generic index that differs from a unique index, where the column can contain the same value, so the rows in the index may contain exactly the same rows. These

f.1 mysqldumpThe working principleThe process of backing up data with the mysqldump command is actually the process of outputting or generating a backup file directly from the MySQL library in the form of a logical SQL statement.F.2

SELECT * FROM Hengtu_demandpush awhere (A.did,a.mid) in (select Did,mid from Hengtu_demandpush GROUP by Did,mid have count (*) > 1)OrSELECT * FROM Hengtu_demandpush GROUP by Did,mid have Count (*) >11, look for redundant records in the table,

MySQL configuration file/etc/my.cnfEditing a configuration file[Email protected] ~]# VIM/ETC/MY.CNF# The MySQL server[Mysqld]Port = 3306Socket =/tmp/mysql.sockSkip-lockingKey_buffer_size = 256MMax_allowed_packet = 1MTable_open_cache = 256Sort_buffer_

Work needs, the use of MySQL paging function, found on the internet a good paging stored procedures, the code to organize a bit!　　Stored Procedure CodeCREATE PROCEDURE' Sp_hj_splitpage ' (inch_pagecurrentint,/*Current Page*/

1. Download Source 12    wget http://dev.mysql.com/get/downloads/mysql-5.6/mysql-5.6.25.tar.gztar  xzvf mysql-5.6.25.tar.gz    2. Preparing 123456789    # before installation Add user group groupadd www# Add user

1 on-line environment sometimes considering the need to do an incremental backup database, so write a simple script2 Add automatic tasks do it every hour or less.#!/bin/sh#author RuM#date 2015-07-10Bakdir=/tmp/mysqlbakBakdir_full= $BAKDIR/fullbakdir_

Today saw the MySQL master-slave replication function, can not help but sigh the strong MySQL, has been troubled by their own problems have finally been resolved.Grant replication on is the command.Before school, learn Grant command, also learn to a