MySQL

MySQL field encryption and decryption 1. Encryption: Aes_encrypt (' admin ', ' key ') decryption: aes_decrypt (password, ' key ') 2. Bi-directional encryption is encrypted by a key, which is only known when the key is decrypted. People to

System and Software versions: CentOS Release 5.5 x86_64 Vsftpd-2.0.5-28.el5 Mysql-server-5.0.95-3.el5 PAM_MYSQL-0.7RC1.TAR.GZ Compilation Installation Previously written vsftpd+tls+mysql solution, always unable to log into the FTP server

Confirm that the have_dynamic_loading is open on master and slave Master MASTER (none) 10:54:58>show variables like ' have_dynamic_loading '; +----------------------+-------+ | variable_name | Value | +----------------------+-------+ |

Problem Scenario: Sometimes the binary files on the disk are deleted because of disk corruption or human error, causing the show binary logs record in MySQL to not match the binaries in the actual physical disk #binlogdiff. SH #!/bin/sh #ocpyang

Today, when writing MySQL function, add comments to the content, found that the compilation error; Find the manual to find, "--" note there is a small need to pay attention to: "--" and annotated content to add space between; This thought is a

Last night in the group and some netizens talked to the topic of MySQL multiple instances, the first contact with more than MySQL instances or more than 1 years ago, that will I have just entered the operation of the industry, has done a number of

The creation of libraries, tables, and query statements in MySQL is very helpful for us to use the database in the future, this article is a summary of these basic statements, I hope it will help you 1. Create and delete databases Creating a

Environment: System: CentOS Linux release 6.0. x86_64 Software: mysql.5.1.x Master IP 192.168.200.1 Slave IP 192.168.200.2 MySQL installation please refer to MySQL Single instance installation The role of MySQL master-slave synchronization (1)

Description Operating system: CentOS 6.3 32-bit Prepare the article: First, configure IP, DNS, gateways, and ensure that the remote connection tool can connect to the server Second, configure the firewall, open 80 ports, 3306 ports

Because the character set cannot be defined when a parameter is defined in a stored procedure, when a stored procedure is invoked, the global variable character_set_server is read by default, and the value of the global variable is read only at

General Repair mysql> Repair table Cab_data; +---------------------+--------+----------+-------------------------------------------------------------------- ----+ | Table | Op | Msg_type | Msg_text

$sql = "show create table category";$res = mysql_query($sql) or die(mysql_error());while($obj=mysql_fetch_object($res))...{　　print_r($obj);　　echo "";} Output stdClass Object ( [table] => category [CREATE TABLE] => create TABLE ' category ' ( '

EngineTo view the MySQL default engine:Show variables like '%storage_engine% ';To view the table engine:Show table status from database name;Modify the Table engineALTER TABLE name ENGINE=INNODB;Define the engine directly at creation timeCREATE

1, the master-slave server for the following actions :1.1 , version consistent1.2. Initialize the table and start MySQL in the background1.3, change the root password2 , modify master server master:#vi/etc/my.cnf[Mysqld]Log-bin=mysql-bin//[ must]

One: Exists under phpMyAdmin find the table export and then importSecond: Use the Binlog function to recover when there is no backupEnter into the/etc/my.cnf file first.Add a sentence to the file: Log-bin=mysql-binThen restart

The money problem can only be installed on MySQL.Download MySQL 5.5 (all other versions are available just here in mysql5.5 for example) install package (: http://dev.mysql.com/downloads/mysql/), run Setup, select Typical installation method

MySQL database backup is the most important thing for every data administrator, and it can help us at a critical time. We recommend that you back up the database, table data, table space, triggers, functions, views of what the separate backup, so

1#!/bin/bash##  use for backup mysql slave data#                                         written  by hch###################################################### #CFGFILE =/etc/my.cnf                             # #BINFILE =$ (gawk -f ' [ \t]*=[ \t]* '

#增加数据到xsb表1. Inserting data into the tableInsert into XSB (XH,XM,NL,XB)VALUES (' 004 ', ' Xiao Wang ', 18, ' Male ');If you want to insert data from all the fields in a table, you can omit the writing of the field names, but the data entry must

In MySQL's limit usage, there is a discussion on the Internet:"//In order to retrieve all record rows from one offset to the end of the recordset, you can specify a second parameter of-1:Mysql> SELECT * from table LIMIT 95,-1; Retrieves the record