MySQL

Query caching refers to the text returned to the client that is stored using the SELECT syntax to query. When the same request occurs again, the data is fetched from the query cache instead of being executed again. The query cache is a shared

One, prepare the shell script.View copy print? vi/home/zhangy/database_bak.sh #!/bin/sh # File:/home/zhangy/database_bak.sh # Database Info bakupmysql TANK 2009/11/04 db_user="root" #用户名 db_pass="********" # password

After the database is started and initial security is set up, we can log in to the database.Log in to Database[Email protected] ~]# mysql-pEnter Password: Enter the password for the settingWelcome to the MySQL Monitor. Commands End With; or \g.Your

C:\mysql-5.6.25-winx64\bin>mysqld InstallSC Delete mysql//delete SQL ServiceC:\mysql-5.6.25-winx64\bin>net start MySQLThe MySQL service is starting:The MySQL service has started successfully.C:\MYSQL-5.6.25-WINX64\BIN>MYSQL-UROOT-P//Connect to MySQL

To create a user:' username '@'host'password';Description: username– You will create the user name, host– specifies which host on which the user can log on, if localhost is available to local users, you can use the wildcard% if you want the user to

Today when attempting to install MySQL 5.6.20, the initial password has been created in ~.mysql_secret this file, and then try to log in with this password, always prompt error 1045 (28000): Access denied for user ' Root ' @ ' localhost ' (using

The main difference between the two types is that InnoDB supports transactional and foreign key and row-level locks. MyISAM is not supported. So MyISAM tend to be considered only suitable for use in small projects.I use MySQL as a user point of view,

1. Link DatabaseC:\>mysql-hlocalhost-uroot-p//Press ENTER, you will be prompted for the password, if the password is empty direct enterC:\>mysql--helpC:\>mysqladmin-uroot-p Password//Follow the prompts to change the password, the password is not

Here's the code to export the stored procedure1 # mysqldump-u database user name-p-n-t-d-r database name > file name Where-D represents--no-create-db,-N for--no-data,-T for--no-create-info, and-R for export function and procedure. So the code above

Uninstall the conflicting RPM package:Rpm-qa|grep mariadbRPM-E--nodeps mariadb-libs-5.5.41-2.el7_0.x86_64Installation:RMP-IVH mysql-community-common-5.7.10-1.el7.x86_64.rpmRPM-IVH mysql-community-libs-5.7.10-1.el7.x86_64.rpmRPM-IVH

Before the MySQL server to use the password to log on to the root account is not a problem, but today do not know because of the move, landing failed and there is this error code:~$ mysql-u Root-1698 (28000for'root' localhost 'Steps to resolve:Stop

Two Linux systems install the same version of the MySQL database.Configuration of two databases it must be different to enable both binary logs and Server-id,server-id.Then restart the MySQL database.Authorization to slave from the database

#!/bin/bash##set-XSql=/home/scriptsDbuser=rootdbpasswd=yzg1314520nowtime=$ (Date +%y%m%d%h%m)Serverlist= ' Cat/home/serverlist | awk ' {print $} 'Sql_tar_export (){CD $sql/$P/mysqlbakMYSQLDUMP-U$DBUSER-P$DBPASSWD $dbname-R test > $nowtime.

MySQL database optimization (bottom) high-availability architecture scheme for MySQL database 2011-03-09 08:53 fuqin wine 51CTOfont Size:T | T In the last MySQL database optimization, we followed the author to learn the optimization of

Make MySQL datasheet healthier with myisamchk 2011-03-15 09:15 The water is too deep itpubfont Size:T | T In order for the data tables in the MySQL database to be "healthier", they need to undergo regular medical examinations. Here the author

What are the main considerations for MySQL optimization? Before you do MySQL optimization, you can do a whole performance test of MySQL server, look at the server bottleneck problem where, mainly to do benchmark test, to test the server's disk

Follow these steps to upgrade mysql version 5.5.x to 5.6.x: 5.5.x5.6.x The general steps are as follows: Add the skip-grant-tables parameter to the configuration file, upgrade basedir to a new version, start mysql, run the command mysql_upgrade to

[MySql learning experience], mysql learning experience 1. Install MySql 1. Install the decompressed version : Http://dev.mysql.com/downloads/mysql/ Installation and configuration Tutorial:

Mysql garbled solution and mysql garbled Solution Symptom: the following error is reported when the data inserted to the database contains Chinese characters.The cause is: the default encoding of the computer is gbk, And the encoding method

[Original] mysql Error Buffer Stack What is an error buffer stack? For example, execute the following statement: mysql>INSERTINTOt_datetimeVALUES(2,'4','5');ERROR1292(22007):Incorrectdatetimevalue:'4'forcolumn'log_time'atrow1 Where is the error