MySQL

ObjectiveAfter the installation of MySQL, there must be some tuning of MySQL's various parameter options. Although the MySQL system is highly scalable, it can run efficiently in a very sufficient hardware resource environment, and can operate well

Log-slave-updates cascade replication with--log-binMaster-connect-retry Master Library out-of-union retry timeRead-only Read OnlyReplicate-do-dbReplicate-do-tableReplicate-ignore-dbReplicate-ignore-tableReplicate-wild-do-tableSlave-skip-errors

First, the experimental environmentCentOs 6.6[Email protected] ~]# Uname-rsLinux 2.6.32-504.el6.i686[Email protected] ~]#Second, the experimental steps1. Download the appropriate version from the Internet, this article uses mysql-5.5.48-linux2.6-i686

The difference between the regular and the like MySQL's regular expression simply makes a subset of the SQL language, which can match basic characters, strings.For example: SELECT * from wp_posts where post_name REGEXP ' Hello ' to retrieve all

Using mysql++ to read the MySQL database, the character set in the data table is UTF8, but the Chinese string cannot be displayed properly when reading. Here is the test program:#include #includeusing namespaceMYSQLPP;using namespacestd;intMain ()

Table is a good way to distribute the pressure of the database.Table, the most straightforward meaning, is to divide a table structure into multiple tables, and then, can be in the same library, can also be placed in different libraries.Of course,

My installation environment for centos6.4 MySQL-related packages by www.mysql.comdev.mysql.com DownloadInstall MySQL in RPM package:[Email protected] ~]# wget http://dev.mysql.com/get/downloads/mysql-5.6/mysql-5.6.30-1.el6.x86_64.rpm-bundle.tar[

My installation environment for centos6.4 MySQL-related packages by www.mysql.comdev.mysql.com DownloadInstall MySQL in RPM package:[Email protected] ~]# wget http://dev.mysql.com/get/downloads/mysql-5.6/mysql-5.6.30-1.el6.x86_64.rpm-bundle.tar[

Reference: http://www.111cn.net/database/mysql/46288.htmIdea: one. Create a user, set the account passwordTwo. Give the user permissions to multiple libraries, respectively.mysql> use mysql;database changedmysql> create user ' developer ' @ ' 192.168

MySQL common operation (1) Change the MySQL database root password # to the root user of MySQL set password mysqladmin -uroot password  ' YourPassword ' # Log in to local mysqlmysql -uroot -p (2) Connect to remote database #remote_host_ip: remote or

Mysql-u root-p;Log in to Databaseshow databases;Presentation DatabaseShow tables;Display tableDESC messages;View the structure of the messages tableDrop database lovestory;Delete Lovestory DatabaseCREATE TABLE messages (ID int primary KEY

Linux installation MySQL tutorial a large, I will not say, and then how to install this 5.7 version of Windows, and some pits have stepped on!One: Enter mysql:http://www.mysql.com/downloads/, click communityTwo: Select the next version of

MySQL replication is a very important feature of MySQL, which is mainly used for data copy operation between the primary server and the slave server. MySQL replication refers to the process of copying data from one MySQL master server (master) to

Now there is an interesting situation, when the user login success, to display the user's last login information, time and IP, and so on. However, in the User login information table, the user's logon process is not recorded, only the account

in recent days has been doing a student status management system based on thinkphp RBAC, MySQL is a lot, although now MySQL excellent graphics software has been quite a lot, can significantly improve the speed of the operation of the database, Their

When you start MySQL, you may encounter a variety of problems, but you will not find the error log at this time, just display on the screen:Starting MySQL. error! Manager of Pid-file quit without updating file.So let's take a look at how to solve

?? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? .?? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?1.auto_increment??2. Main healthAuto_increment must be used

Mysql batch repair and mysql repair #! /Bin/bashhost_name = 127.0.0.1user _ name = user_pwd = database = need_optmize_table = falsetables = $ (/usr/local/webserver/mysql/bin/mysql-h $ host_name-u $ user_name- p $ user_pwd $ database-A-Bse "show

MySQL backup principles and mysql backup details Backup is the last line of defense for data security. For any data loss scenario, although backup may not be able to restore of the data (depending on the backup cycle), it can at least minimize the

Several Methods for SQL optimization and SQL Optimization Database three paradigm A general understanding of the three paradigms is of great benefit to database design. In database design, in order to better apply the three paradigms, the three