MySQL

Success ScenariosMysqld_safe--user=mysql--skip-grant-tables--skip-networking &[[email protected] ~]# mysql-u root MySQLmysql> Update user Set Authentication_string=password (' Passw0rd ') where user= ' root ';[Email protected] ~]# mysql-u

Xtrabackup: Provided by Percona, instead of ibbackup Backup tool. Used to back up its xtradb engine data, XTRADB itself is InnoDB enhanced full compatibility InnoDB, only MyISAM Win Bei, more advanced features support InnoDB.Xtrabackup advanced

MySQL Error code table1005: Failed to create table1006: Failed to create database1007: Database already exists, database creation failed1008: Database does not exist, delete database failed1009: Unable to delete database file causes database failure

background : Recently there is a MySQL database synchronization requirements, I use the MySQL master-slave synchronization method to achieve. Take a look at the steps below. Environment and topologyOperating system: Centos6.6 X64MySQL version: 5.1.73

1, System Management 1.1 connection MySQLformat : mysql-h host address-u user name-P user PasswordExample :Example 1: Connect to MySQL on this computer.First open the DOS window, and then enter the directory Mysqlbin, and then type the command

There are two major strides in opening MySQL's remote login account:1. Determine that the firewall on the server does not block port 3306.MySQL default port is 3306, need to determine the firewall does not block 3306 port, otherwise remote is unable

A very useful mysql boot parameter ——--Skip-grant-tables. As the name implies, when you start MySQL, do not start the grant-tables, authorization table. What's the use of it? Of course it is useful to forget the administrator password.Add Skip-grant-

MySQL High Availability Scenario MHA Introduction Overview MHA is a Japanese MySQL Daniel written in Perl a set of MySQL failover scheme to ensure the high availability of the database system. In the time of downtime (typically 10-30 seconds),

Locate the MySQL configuration file, search for "bind-address", and find this line:bind-address = 127.0.0.1 in front add a #, comment out this line, save, restart MySQL.Remote access is available, and Telnet can discover that the port is also

Explain shows how MySQL uses indexes to process SELECT statements and join tables. Can help select better indexes and write more optimized query statements.Parse an SQL statement first to see what

MySQL Memory structureInnoDB Primary index is clustered index, index and data common table space, for InnoDB, data is index, index is data. The biggest difference between the InnoDB cache mechanism and the MyISAM cache mechanism is that INNODB is

1) Main Health1, the Operation table constraints(1) Non-null constraints(2) Field default value(3) Unique constraint(4) Main health constraint(5) Add the main health (emphasis)(6) Automatic increase2) Index1. Create a normal index (emphasis)2.

I. Numeric type Integer type Bytes Range (signed) Range (unsigned) Use TINYINT 1 bytes (-128,127) (0,255) Small integer value SMALLINT 2 bytes (-32 768,32 767

#!/bin/bash#by martin.liutoday= ' Date +%y%m%d ' backuppath=/usr/local/mysql_backupbackuplog=bak_$ today.logbackupfile= $Today. tar.gzdbuser=rootdbpassword= ' 123456 ' dbhost=localhostmkdir-p $BackupPath/$ Todayinnobackupex--user= $DBUser--password=

Let's start by understanding the concept of MySQL indexing:An index is a special file that contains reference pointers to all the records in the data table. More generally, the database index is like a directory in front of a book, can speed up the

The modified users are listed as root.first, the root of the original myql password;Method One:Outside the MySQL system, use the Mysqladmin#mysqladmin-u root-p Password "test123"Enter Password: "Enter the original password"Method Two:By logging into

When using MongoDB, some fields need to be self-increment, and are denoted by two decimal letters (using A-T corresponds to 0-19), do a _auto_increment field to save, but should start from 0 or 1?Consistent with MySQL for easy maintenance. So try it.

Many places in the analysis of char and varchar data types are chosen in principle, often ignoring the storage engine. In fact, we should determine how to choose the appropriate data type based on the selected storage engine.Char vs. varchar

Install mysql5.7.13.zip (windows) and mysql5.7.13zip Follow the installation method I used to install MySQL 5.6 (MySQL free installation Version Download and configuration) to install MySQL 5.7: The mysql service cannot be started and no error is

Two ways for MySQL to delete a database: mysqlUse mysqladmin to delete a database When you log on to the mysql server as a common user, you may need specific permissions to create or delete a MySQL database. Therefore, we use the root user to log on.