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

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

/*** 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 ' @ '% '

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

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

For general index and composite Index issues:Index-separated index and composite index: Single-column index, that is, an index contains only single columns, a table can have multiple single-column indexes, but this is not a composite index;MySQL

PremiseVersion mysql-5.5Platform centos6.xAdd userUseradd-m-s/sbin/nologin MySQLInstall the required packagesYum-y Install compat-libstdc++-33.x86_64 libaio.x86_64InstallationTar xzvf mysql-5.5.43-linux2.6-x86_64.tar.gzMv-f mysql-5.5.43-linux2.6-x86_

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 =

When doing the data synchronization check, we need to compare the MySQL fetch data with hbase data, and find that even if MySQL data changes, the following code is similar to the value returned by the previous data. The extracted code might look

Mysql master-slave replication practicesAsynchronous master-slave Replication  Master-slave deployment steps: Backup and Restoration Use mysqldump or xtrabackup Restore the existing basic data of the master database to the slave