MySQL

Log in to MySQL, if you are connecting to a remote database, you need to specify hostname with-H.#mysql-H hostname-u root-p#mysql-uroot-p-s/data/3306/mysql.sock #本地登录Update permissions/privileges for the database.mysql> flush Privileges;View the

Mysqldump is commonly used in MySQL database logical backups.1. Various usage instructionsA. The simplest usage:Mysqldump-uroot-ppassword [database name] > [dump file]The above command backs up the specified database to a dump file (dump file), such

Error 1: When a database is migrated, various problems often arise, such as performance_schema, database Perfor This error, you can try to fix it with this command:Mysql_upgrade-u root-p mysql_upgrade-u root-p--forceError 2: The specified InnoDB

Use INFORMATION_SCHEMA;--Querying a database storage sizeSelect Concat (Round (sum (data_length/1024/1024), 2), ' MB ') as data from tables where table_schema= ' database Nane '; 85MB--Query a table storage sizeSelect Concat (Round (sum (data_length/

Reprinted from: http://www.jb51.net/article/55853.htmObjectiveAs in C + +, how many bytes are required to define an int type, and how many bytes are required to define the double type, MySQL has strict control over the data in each column of the

1: MySQL optimization is a comprehensive technology, mainly including:    A, the design of the standard (in accordance with 3NF)     B, add the appropriate index (index) (normal, primary key index, unique index unique, full-text index)     C,

/*** Created by Coder Meng.* User:coder Meng* Date:2016/8/29 10:27*/Header"Content-type:text/html;charset=utf-8");Include_once' config.php ';/* $sql = "SELECT * from article";$rs =mysql_query ($sql); * *$where =‘‘;$url =‘‘;$wherelist =Array

Show all databases: show databases; use a database: Usethe name of the database; Show all tables for one database show FullTables fromMblogswhereTable_type= 'base Table'; Show database encoding show charset create a formCreate TableMblogs. M_LINKSS (

The following error occurred [error] ERROR in Log_event::read_log_event ():   ' Event too big ' , Vim/etc/init.d/mysqld Start parameter Add--binlog-row-event-max-size=536870912

One, DCL statements (Data control statements)1, authorized remote access, for IP and user, dbGrant {Privilege List} on {dbname}.* to ' {user} ' @ ' {IP} ' identified by ' {pwd} ' with GRANT optionEx:grant all privilege on * * to ' root ' @ '% '

Native access rights:Mysql> GRANT All privileges on * * to ' username ' @ ' localhost ' identified by ' password ';Remote access permissions:Mysql> GRANT All privileges on * * to ' username ' @ '% ' identified by ' password ';FLUSH privileges;Add

Transfer from http://blog.csdn.net/theorytree/article/details/7335612The MySQL server's main () in/sql/main.cc, the actual entry point in/sql/mysqld.cc.We start reading directly from Mysqld_main ().First understand some of the more important macro

MySQL table four types of partitioning one, what is table partitioningIn layman's terms, a table partition is a large table, divided into several small tables according to the conditions. mysql5.1 started supporting data table partitioning. For

1, from a painting of the flowchart.650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/86/4B/wKiom1e7NCrwhi7oAADQH_X2UQ4191.png-wh_500x0-wm_3 -wmp_4-s_4219506885.png "title=" Qq20160823011928.png "alt=" Wkiom1e7ncrwhi7oaadqh_x2uq4191.png-wh_5

An exact numeric data type that uses integer data.bigintInteger data (all numbers) from -2^63 (-9223372036854775808) to 2^63-1 (9223372036854775807). The storage size is 8 bytes.IntInteger data (all numbers) from -2^31 (-2,147,483,648) to 2^31-1 (2,1

mysql-h127.0.0.1-uroot-p Password//command line connection MySQLshow databases; View all databasesUse database name; Select DatabaseShow tables; View all data SheetsDescribe data table name; View table StructureMysqldump-uroot-p Password Study

1, ready to install the program (official website download)Service side:MySQL-server-community-5.1.44-1.rhel4.i386.rpmClient:MySQL-client-community-5.1.44-1.rhel4.i386.rpm2, installation (printing information slightly)[[email protected]/]

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

There are two ways to allow MySQL remote access in Fedora:A, change the table.Mysql>use MySQL;Mysql>update User Set host = '% ' where user = ' root ';Mysql>select host, user from user;b, Authorization.For example, you want to use root 123456 from

Then talk about how to modify the transaction isolation level:1. Global modification, modify the Mysql.ini configuration file, at last add1 #可选参数有: read-uncommitted, read-committed, Repeatable-read, SERIALIZABLE.2 [mysqld]3 Transaction-isolation =