MySQL

OneHow to choose the right character setFor MySQL database, the character set is important, because the database stores most of the data is a variety of text, the character set on the database storage, processing performance will be affected.The

1. Download: Http://dev.mysql.com/downloads/mysql/5.6.html#downloadsDownload version: I choose here 5.6.33, General edition, Linux under 64-bitYou can also directly copy the 64-bit, download by command: wget http://dev.mysql.com/get/Downloads/MySQL-5

When the MYSQL8 is just installed, the error when using the native connectionAuthentication plugin ' Caching_sha2_password ' ...First make sure the service is turned on and then go to MySQL's localhost database with the cmd

1, first confirm the error Binlog and last event.2, then go to the main machine to see the error content and the location of the error, if the end of the error, you can directly from the new Binlog synchronization.#/mysql/logs#.

Rights Management:User:System level: The user is a user name ===> user name: passwordWhat can I do?1. Login System2. Management System objectsMysql:is no longer a simple user name and passwordUser name @ ' host range ' host range is called

Introduction to LAMP Architecture Lamp architecture is one of the most mature application models of enterprise website, which refers to a complete set of system and related software, which can provide dynamic Web site service and its application

Redhat Installing the JDK1. use securecrt to upload the package, you need to register with the Redhat website when using yum install Lrzsz , generally commercial version, registration can be installed lrzsz installation 2. Enter the usr/local

1. Download the MySQL installation fileMySQL official website: https://www.mysql.com/Select the appropriate installation version according to the modelChoose MySQL Installer installation here: Mysql-installer-community-5.7.21.0.msi2. mysql Installer

The standard query statements are as followsSelect Column name 1, column name 2, column name 3 from table nameThe statement returns all rows of the corresponding column in the tableIf you want to retrieve all the columns in a table, you can

MySQL Error 1045 (28000): Wrong resolutionListen to the Voice | Browse:54286 | Updated: 2018-02-23 14:34 | Tags:mysql 1 2 3 4 5 6 7 Step through ReadingERROR 1045 (28000):

Today, after the native installation of MySQL8, the local project connection is always prompted access denied for user ' root ' @ ' localhost ' (using Password:yes), online search for a long time, said the default remote connection is not open, A

Storage EngineView:Table like ' Bigcourse ';Results:+-----------+--------+---------+------------+------+----------------+-------------+-----------------+--------- -----+-----------+----------------+---------------------+---------------------+-------

Seven types of log filesThere are seven types of log files in MySQL, namely: Redo log (redo log) Rollback log (undo log) Binary log (Binlog) Error log (errorlog) Slow query logs (slow query log) General query log

If you are using MySQL or mariadb, do not use the "UTF8" encoding and use "UTF8MB4" instead.Here (HTTPS://MATHIASBYNENS.BE/NOTES/MYSQL-UTF8MB4#UTF8-TO-UTF8MB4) provides a guide for transferring the character encoding of an existing database from

1. Delete the original mariadb, or install the error.rpm-qa| grep mariadbRPM-E--nodeps Mariadb-libs2. In https://dev.mysql.com/downloads/mysql/Select for red Hat Enterprise Linux 7/oracle Linux 7, select the OS version as all.Download the Mysql-5.7.2

First, install CentOS 6# wget http://repo.mysql.com/mysql57-community-release-el6.rpm && RPM-IVH mysql57-community-release-el6.rpm # yum Install-y mysql-community-serverNote: http://repo.mysql.com This site is the site where the RPM source is placed

1. Check if MySQL is installedRpm-qa | grep MySQL2. First delete, download Mysqlwget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz3. UnzipTAR-ZXVF mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz4. Copy the

MySQL incremental backup and recovery skill targets Understanding the concept of MySQL incremental backup Understanding MySQL Incremental backup and recovery methods 1: The concept of incremental backup full backup each time you

I. Process functions--Create a table to describeCREATE TABLESalary (UserIDINT, salaryDECIMAL(9,2));INSERT intoSalaryVALUES(1, +),(2, -), (3, the),(4,4000),(5, the), (1,NULL);SELECT * fromSalary1. if (value,t,f) more than 2000 of the use of high,

#!/bin/BashEcho-E ['Date+"%y-%m-%d%h:%m:%s"'] Start#system Time Time=`Date+"%y-%m-%d"' #host iphost="127.0.0.1"#database Backup Useruser="Root"#database Passwordpasswd="yourpasswd"#Create a backup directorymkdir-p/backup/db/"$time"#list Database