MySQL

Day04First, manage the root user password1.1 Change Password1.2 Recover PasswordSecond, user authorization and REVOKE authority2.1 Licensing2.2 Revoke permissionsIII. installation of graphical management toolsFour-data backup and recovery-----full

Day06First, MySQL master-slave synchronizationSecond, the data read and write separationThird, MySQL optimization++++++++++++++++++++++++++++++++First, MySQL master-slave synchronization1.1 Introduction to Master-slave synchronization? Automatically

MHA (Master high availability) is a relatively mature solution currently available in MySQL, MHA when monitoring the failure of the master node, the slave node with the most recent data is promoted to become the new Master node, during which MHA

1: Remote database (D1) Data: Database User: Root, Database password: root, database IP intranet address 192.168.100.91, database port 3306localhost: IP 192.168.127.1Mode one: Use the Navicat client connection.2: First on the remote database D1 to

Most of the internet is MySQL terminal input in Chinese garbled, and then change the character set of MySQL server operation, but the lack of MySQL terminal cannot input Chinese, copy the SQL statement copied to MySQL terminal Chinese cannot display:

1. Enter mysql,grant all privileges on * * to ' root ' @ '% ' identified by ' with the GRANT option;identified by followed by a password that can be set to null. 2. FLUSH privileges; Update MySQL for security, by default the user is allowed to log

Leftist querySELECT * from a LEFT join B on a.id=b.id;Right Union querySELECT * from a RIGHT join B on a.id=b.id;inline querySelect A.name,b.class from A, b where c.id=b.id;ORDER BYSelect *from a order by Desc#desc; descending arrangement, ASC

Summary: Masterha_master_switch is integrated as a switch tool in the MHA package,Install: After compiling and installing MHA Manager, binary executable program Masterha_master_switch will be generated in/usr/local/bin/.Use:$masterha_master_switch --

Incremental updateInput {jdbc {jdbc_driver_library= "D:\tools\mysql\mysql-connector-java-5.1.45/mysql-connector-java-5.1.45-bin.jar"Jdbc_driver_class= "Com.mysql.jdbc.Driver"jdbc_connection_string=

Execute the following command sudo rm/usr/local/mysql sudo rm-rf/usr/local/mysql* sudo rm-rf/library/startupitems/mysqlcom sudo rm-rf/library/preferencepanes/my* RM-RF ~/library/preferencepanes/my* sudo

MySQL 5.6.5 The following version does not support multiple timestamp and is set to default Current_timestampThe alternative is to use the trigger create TABLE ' example ' (' id "INTEGER UNSIGNED not NULL auto_increment, ' created ' TIMESTAMP not

Each host needs to install KEEPALIVED,MYSQL, the installation process is not introduced here, do not understand the Baidu can be self-.The environment for this configuration isdb1:192.168.31.190 db2:192.168.31.184 MySQL vip:192.168.31.1891. Modify

The classmate Sue me to say that he in order to make the data query become faster, modify the data engine, so query, summed up a bit.After logging in to MySQL, look at the engine supported by the current database and the default database engine,

I. MySQL 5.6 Introduces the concept of Gtid, so what is the Gtid sacred? In fact, it is not complicated, it is a global transaction identifier. With Gtid, each transaction commit generates 1 unique identifiers in the Binlog, which consists of a UUID

I. Introduction to the MySQL storage process (technical text):A stored procedure is a programmable function that is created and saved in the database. It can consist of SQL statements and some special control structures. Stored procedures are useful

One, the choice of multi-table query connection:Believe that the connection, the left connection what we are more familiar with, of course, there are left outside the connection, the basic use of I do not post it out. This figure just lets us recall

A. Enter the following address in the browser　Two. Go to the following interface: Directly click on the location below, select Skip LoginClick to download directly after this.Three. Once the download is complete, double-click to open, pop up the

Install the Inception service and use Python 3 to audit MySQL. inceptionpython   Install the Inception service and use Python to audit MySQL   Bison is one of the packages that the Inception service depends on. However, some Linux versions have

Solution to Table MySQL. plugin doesn't exist prompt during mysql deployment 1: Modify the environment variable path, added value C: \ Program Files \ mysql-5.7.17-winX64 \ bin 2: Modify my-default.ini, rename TO my. ini, modify file content: #

MySQL-5.6.xx-winx64 installation-Free Edition configuration method, MySQL-5.6.xx-winx64 installation-free configuration method1. Download Mysql-5.6.xx-winx64 from the mysql official website.2. decompress the MySQL packageDecompress the downloaded