MySQL

Pre-compilationYum install gcc gcc-c++ perl ncurses-develFrom mysql5.5 onwards, MySQL source installation started using CMake, set the source code compilation configuration script. -dcmake_install_prefix=dir_name Setting up the

Int (m) This m represents the width of the displayFunction: In the front-end to display an integer type of data, the database set the corresponding data type int (4), but the data written less than 4 bits, then the left padding space (if Zerofill is

Mysql Environment Query1. View all EnginesA) show engines or go inside the Information_schama to see the engines table .2, view current userA) Select user () can view the currentb) Show full processlist view current operations3. View Environment

Today added a database automatic backup module, MySQL data backup method has many, can be a single database backup, can be multiple database backup, or a table can be backed up, you can only back up the databaseThe structure does not back up the

Export the SQL script for a database in a MySQL database-that is, the structure and data of the database are imported into an SQL script, which can then be recovered by the SQL script.Mysqldump-u MySQL (user name: mysql)-pmysql (password: mysql)

Index and manage IndexesA database object in the schemaFunction: Used in the database to speed up the query of the tableCreate: Automatically create indexes on primary key and unique keyReduces disk I/O by quickly locating data by using fast path

Date_format (Date,format)Formats the date value according to the format string.The following specifiers is used in the format string. As of MySQL 3.23, the "%" character is required before format specifier characters. In earlier versions of MySQL, "%

Backup# mysqldump -uroot-plam2linux discuz >/data/discuz.sql #备份discuz库, ending in *.sql# Vim/data/discuz.sql #进入文件查看信息If we delete the files in the Discuz library,# RM-RF (filename)Recovery# MySQL -uroot-plam2linux discuz Not only can you

Zip up the MySQL compact root folderNote the contents of the INI configuration fileBasedir = D:\mysql-5.6.17-winx64DataDir = D:\mysql-5.6.17-winx64Port = 3306server_id = MSSQLDefault-character-set=utf8Cmdcd MySQL Bin foldermysqld Install MySQLnet

1. Account numberConnection data: mysql-h host-u root-p PasswordChange Password: mysqladmin-u root-p old_password Password New_passwordAdd Users: Create user ' user1 ' @ '% ' identified by ' password 'User authorization: Grant

1) Double-click the MySQL installation file Mysql-essential-5.0.82-win32.msi. Go to the Welcome page.Click Nextbutton. Go to the Installation Type page. 2) The first item on the installation Type page is a typical installation, and the second item

1. Create a database:Data definition language (DDL);Create DATABASE db_name[databases option]Note: Database naming rules: Capitalization depends on the current operating system, see name, recommended underlineCharacter of the identifier:Use any

1. Install MySQL Database2. Three files required after MySQL installation mysql.h libmysql.lib libmysql.dll.#include #include/*#include */#includeintMain () {MYSQL*con = Mysql_init (MySQL *)0); Mysql_res*Res; Mysql_row ROW; Chartmp[ -];

In general, there are several ways to modify user passwords in MySQL:1. Modify your password to be available:Set Password=password (' 123456 ');2. Modify other user's password to be available:Set password for ' username ' @ ' host ' =password (' 1234

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 database data migration from one server to another requires that the database be exported and then imported from another server. There are many ways to do this, and the MySQL companion tool has this feature. phpMyAdmin can do it, but this is

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

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