MySQL

Note: This article is for mac!! only ProblemAfter installing MySQL successfully, want to get a database to try, but error. Not an error code, but a piece of code:Authentication plugin ‘caching_sha2_password‘ cannot be loaded: dlopen(/usr/local/mysql/

Fe_group User NameFe database name123456 Password1. Create a new userLogin mysql@>mysql-u root-p@> Password//create user mysql> insert into Mysql.user (Host,user,password) VALUES (' localhost ', ' Fe_group ', password (' 123456 '));//Refresh the

Create a new test table, three fields, Id,title,uid, ID is the self-increment primary key, UID is the unique index;Insert two piece of data insert into test (TITLE,UID) values ( ' 123465" 1001 "insert into test (TITLE,UID) values ( ' 123465" 1002

MHA is currently a relatively mature solution for MySQL high availability, developed by the Japanese Dena company Youshimaton, and is an excellent set of highly available software for failover and master-slave upgrading in MySQL high-availability

Original function: Update Categories SET display_order= 3,title = ' New Title 1 ' where id=1; Update Categories SET display_order= 4,title = ' New Title 2 ' where id=2; Update Categories SET display_order= 5,title = ' New

Tag: Mode file ORC mod mode IV TE must state1. Requirements:(1) must be 5.7.6 versions of MySQL(2) Gtid status is off2. Opening steps:(1): SET GLOBAL enforce_gtid_consistency = ' WARN ';(2): SET GLOBAL enforce_gtid_consistency = ' on ';(3): SET

Execution path of the query SQL statements Query cache Parser Parse tree Pretreatment Find the best query path Query optimization SQL statements Execution plan API call Storage Engine Call data, return

Create an NFS storage directory[Email protected] ~]# MKDIR/DATA/K8S/MYSQLPV1Create PV[email protected] ~]# cat

Linux to turn on MySQL remote connection setup steps.MySQL default root user only local access, cannot remotely connect to manage MySQL database, then how to open MySQL remote connection under Linux?The setup steps are as follows:1. Log in to MySQL2.

When you read this article, it is estimated that the problem is also a headache;Import and export as a text file, found always error, a lot of solutions, the following is the simplest and thorough method, record.First, locate the My.ini file in the

The recent online project reported a MySQL deadlock (deallock) error, although the business is not any impact, because of their own database lock this piece of knowledge is not much, before also did not how to encounter on the line. This time just

MySQL restricts the size of packets accepted by the server according to the configuration file.Sometimes large inserts and updates are limited by the Max_allowed_packet parameter, resulting in failure.View current configurationShow VARIABLES like

Learning Goals Data backup Data recovery Database migration Import and Export Data backupA system crash or server hardware corruption can cause the database to be lost, so data backup is important in a production

Master-Slave Introduction MySQL master-slave is also called replication, AB replication. Simply said that A and b two machines from the back, on a to write the data, the other B will follow the writing data, the two data in real-time

working principle:How the query cache works can be broadly summarized as: caching the result set and SQL statements for the select operation or preprocessing query (Note: 5.1.17 start support), a new SELECT statement or a preprocessing query

1) Scene catch the slow query statement show full processlist;2) configuration parameters:Slow_query_log_file = On slow query open switchlong_query_time = 2 record SQL statement greater than 2 secondsLog_queries_not_using_indexes = on does not use

CentOS 7 installation MySql1. Download MySQL repo source$ wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm2. Install the MYSQL-COMMUNITY-RELEASE-EL7-5.NOARCH.RPM package$ sudo rpm -ivh mysql-community-release-el7-5.noarch.rpmAfter

Output HOST1/2 system logs, log to the MySQL server database, and publish loganalyzer structural relationships such as:Preparatory work: Vmware CentOS 7 Minimum System installation image Loganalyzer Source Package Download

The use of Tomcat's JDBC Pooltomcat jdbc pool requires only 2 jar packages, Tomcat-jdbc.jar and Tomcat-juli.jar respectively, the two jar packages can be found in Tomcat7, Tomcat-jdbc.jar in the Tomcat directory, Tomcat-juli.jar in the bin directory.

Create a temporary tableCreate Temporary Tablesalessummary (Product_NameVARCHAR( -) not NULL, Total_salesDECIMAL( A,2) not NULL DEFAULT 0.00, Avg_unit_priceDECIMAL(7.2) not NULL DEFAULT 0.00, Total_units_soldINTUNSIGNED not NULL DEFAULT 0);Inserting