MySQL

Encountered Chinese garbled problem, first check the database configuration with the status command, as follows:The information for the database configuration is displayed.You can also use show create DATABASE XXX to display the encoding settings at

Sometimes we want to reinstall MySQL after uninstalling MySQL, this time prompt ' already has the MySQL service exists, is running ' and so on, because we did not uninstall MySQL before uninstall cleanly, this time will be removed from the registry;

1 Attack analysisClevercode's OPS colleague told me that when he looked at MySQL's error log, he found a lot of errors, so someone was attacking an address. A large number of this error occurs because MySQL does not support negative numbers at limit.

$python Import Mysqldbtraceback (most recent): " " in importerror:no module named MySQLdbwget http://jaist.dl.sourceforge.net/project/mysql-python/mysql-python-test/1.2.4b4/MySQL-python-1.2. 4b4.tar.gztar zxvf MySQL-python-1.2. 4b4.tar.gzpyhton

1. Single InstanceNow stop the database/etc/init.d/mysqld stopUse the following command to log inMysqld_safe--skip-grant-tables--user=mysql &You can now log in using MySQLMysql-urootAnd then you can change the password.Update Mysql.user set Password=

1. Single Instance ScenarioNow stop the database/etc/init.d/mysqld stopStart the database with the following commandMysqld_safe --skip-grant-tables --user=mysql &You can now log in using the MySQL commandMysql-urootAnd then you can change the

Login command: Mysql-uroot-prootSelect User,host,password from Mysql.user;                                                                                                  2, Mysql>grant all privileges on * * to ' root ' @ '% ' with GRANT

Instance:Write a shell script to back up MySQL data 16:30 daily and compress the package (the package file is named according to the date of the day) and put it on/root/data#cd/root#vim mysqlbackup.sh#!/bin/bashtime= ' date +%y-%m-%d '

1. Note: Before synchronizing, be sure to authorize the operation to the from server grant all slave on * * to [E- Mail protected] identified by ' Pass ' view Binlog show Master Stat us Clear Binlogreset Master;2, General master server to add,

MySQL's maximum number of connections by default is 100, this value for a lot of concurrent connection of the database application is not enough, when the connection request is greater than the default number of connections, there will be unable to

MySQL replication can be easily used to do the application of the read extension, can also help MySQL to achieve a certain degree of HA program. MySQL implements replication by transmitting binary logs to the repository, which is explained by the

There are two ways to manipulate a database using PHP Using the Mysql_xxxx () method In this way, you need to remove the Extension=php_mysql.dll from the php.ini first. Using PDO To use this test, you need to

High Case sensitivity and performance of mysql queries Mysql queries are case-insensitive by default, for example: 1 2 3 4 5 6 7 select * from table_name where a like 'a %'   Select * from table_name where a like 'a %'   Select

Solve the Problem of MySQL Chinese garbled characters. mysql Chinese garbled characters In case of Chinese garbled characters, run the status command to check the database configuration as follows: The information about the database

A preliminary introduction to set operations in MySQL What is a set operation? Generally, the join operation is regarded as a horizontal operation between tables because the virtual table generated by this operation contains columns in two tables.

A Brief Introduction to the transaction mechanism in MySQL Start with a question Recently, the Bank has suffered a lot of troubles. Many depositors put their money in the bank, but the bank still does not care about it, saying it is the

MYSQL width indicator 1. In the old version of MySQL 3.22, the single table size of MySQL is 4 GB. At that time, the MySQL storage engine was also the ISAM storage engine. However, when the MyISAM storage engine appears, that is, starting from MySQL

Mysql cascade operation (Instance) MySQL only supports the InnoDB Storage engine for Foreign keys. When creating foreign keys, the parent table must have corresponding indexes, when a sub-Table creates a foreign key, the corresponding index is

MySQL Data Type MySQL numeric data types can be roughly divided into two categories: one is an integer, and the other is a floating point or decimal. Many different subtypes are available for each of these classes. Each subtype supports data of

Understanding of MySQL database DELAY_KEY_WRITE MySQL database parameter DELAY_KEY_WRITE: DELAY_KEY_WRITE refers to the update operation of the table to the disk without updating the index to the disk before the table is closed, and the changes to