MySQL

installation of MySQL  A, download mysql        http://dev.mysql.com/downloads/mysql/II, installation         $tar-XZVF mysql-5.1.45-osx10.6-x86_64.tar.gz        $sudo  mv mysql-5.1.45-osx10.6-x86 _64 /usr/local/mysql        $CD  /usr/local       

Error message MySQL server version for the right syntaxPossible causes 1. The name of the database, the name of the table, the name of the field, cannot appear the MySQL keyword.For example, 1) desc or ASC2) group2. The name of the database, the

One, Structured Query language SQL 1.SQL Advantages:A. Not a specific database vendor language, all DBMS supports SQLB. Simple and easy to learn, case insensitiveC. SQL is a powerful language that uses its elements flexibly to manipulate complex and

Build table: (NOT NULL, auto_increment, unique, primary key)Create Database Balfish;Use Balfish;CREATE TABLE Mytable1 (ID int NOT NULL,Name varchar (20),Grade int);INSERT into mytable1 values (' 1 ', ' Yang ', 97);INSERT into mytable1 values (' 2 ',

1. Create database IF not EXISTS yourdbname DEFAULT CHARSET UTF8 COLLATE utf8_general_ci;Create DATABASE Yourdb DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;2. Switch database use DatabaseName;3. Deleting a databaseThe drop command is used to

Recently using Navicat for MySQL access to the remote MySQL database, an error occurred, showing "1130-host ' xxx.xxx.xxx.xxx ' is not allowed to connect to this MySQL server". The solution is as follows:Method/Step 1Reading the wrong window

[Client]port= 3306Socket=/home/MySQL/MySQL/tmp/MySQL.Sock[mysqld]!include/home/MySQL/MySQL/etc/mysqld.cnf#contains the configuration file, the user name, the password file stored separatelyPort=

Operating system version: CentOS release 6.5 (Final) 2.6.32-431.el6.x86_64 #1Memory: 32GCpu:intel (R) Xeon (r) CPU e5-2450 v2 @ 2.50GHz (logic 32 Core)Disk: PCIE-SSD (model later)File system type: EXT4MySQL database version: Server Version:5.6.22-72.

1:apache IntroductionApache is the world's top-ranked Web server software, which can run on almost all widely used computer platforms due to its widespread use across platforms and security, is one of the most popular Web server-side software.

the data structures commonly used in indexes are B + trees . The structure is as followsFor example, is a B + tree, the definition of B + tree can be seen in the B + tree, here is only a few points, the light blue block we call a disk block, you can

MySQL noun explanation/meaning mvcc (multiversion concurrency control) The MySQL InnoDB storage engine, which implements the Concurrency Control Protocol--MVCC (Multi-version Concurrency Control) based on multiple versions (note: Compared

A data type is a basic rule that defines what data can be stored in a column and how that data is actually stored. MySQL's common data types include: string Data type : The most commonly used data type, there are two basic types of strings:

Because of the drbd+mysql+heartbeat done before. Feel high available to do is not thorough enough. Just understand the next amoeba. Document Address:http://docs.hexnova.com/amoeba/index.html Download:

MySQL master-slave configurationReplication master-Slave, keep two database data consistentMaster A data changes, generate logs, sent to from b,b According to the log to make corresponding changes, so that the data and A consistent. keeping A,B

MySQL Study--mysql schema_information DatabaseThe INFORMATION_SCHEMA database is generated after MySQL version 5.0, a virtual database that does not physically exist.The INFORMATION_SCHEMA database is similar to the data dictionary, providing a way

First, look at the high-availability scenarios for common MySQL:Description of the pair:1) heartbeat through the serial line or Ethernet network cable directly connected to the end of the service to do health checks, and is responsible for the

Sub-table strategy1, according to the characteristics of the time table, different days, the time may be uneven, some more, some less, and may appear too large data volume situation2, according to the hash Modulus sub-table (or primary key to mold)

Method 1: Use the Set password commandMysql-u Rootmysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');Method 2: Use Mysqladminmysqladmin-u root Password "Newpass"If Root has already set a password, use the following

MySQL is not accessible via remote machine by default, remote access can be turned on by the following configurationOn the MySQL server side:Execute mysql command into MySQL command mode,SQL code mysql> use mysql;    MySQL > 

Hive integrates MySQL as meta dataBy default, the hive metadata is saved in the embedded Derby database, allowing only one session connection and only for simple testing. In order to support multi-user multi-session, we need a separate meta-database,