From: http://shoopman.org/post/15.html
Because you need to share the EA project, and temporarily find that EA only supports ODBC to connect to the database, you need to solve the problem of connecting to MySQL through ODBC.
By default, Windows
1. Create a centos MySQL user group
[Root @ localhost ~] # Grep MySQL/etc/group
# QuerySystemMySQL user group. If no user group exists, add it.
[Root @ localhost ~] # Groupadd MySQL
# Add a user group named MySQL
2. Create a centos MySQL user
[
18.2.3 host '...' is blocked ErrorIf you get an error like this:
Host 'hostname' is blocked because of specified connection errors.
Unblock with 'mysqladmin flush-hosts'
This means that mysqld has obtained a large number of connection requests
Ii. MainCodeAnalysis
$ Pagesize = 10; // set the number of records displayed on each page$ Conn = mysql_connect ("localhost", "root", ""); // connect to the database$ Rs = mysql_query ("select count (*) from tb_product", $ conn); // get the total
1. indexes are introduced to the database. The most frequently performed operation on a database is data query. In general, the database needs to search the entire table for data during the query operation. When a table contains a large amount of
1. Download the installation package mysql-5.1.52-osx10.6-x86.dmgfrom http://dev.mysql.com/downloads/mysql/
2. Double-click the installation package. One of the four files is the description document.
3, first click Install
Installation:
Apt-Get install mysql_server
Add User:
Mysql> grant all privileges on *. * To 'freebird' @ '%' identified by '000000' with grant option;'Freebird' User Name'123' Password'%' Indicates that the connection can be established from
Enter it in English
8. Operate instances
// Mysql_linux_num2// Basic MySQL operations// Zhu Changzhi// 2007-3-2# Include # Include "/usr/local/MySQL/include/my_global.h"# Include "/usr/local/MySQL/include/MySQL. H"Typedef struct _ 3d_point{Float x,
If the optimization of a single MySQL is still under pressure, we must consider the high-availability architecture of MySQL (many people also love to say it is a MySQL cluster, currently, feasible solutions include:
I. MySQL ClusterAdvantage: high
MySQL-master1: 192.168.72.128 MySQL-master2: 192.168.72.129 OS Version: centos 5.4MySQL version: 5.5.9 (the master and slave servers with master-slave replication have the same MySQL version or the master version is later than the slave version) 1.
Problem description:
In the program, the data queried from the slave database does not change after the master database is updated. It is suspected that the synchronization delay of the Master/Slave database is caused. Check the master-slave
Nginx is a layer-7 architecture that supports HTTP and does not support TCP. Therefore, Server Load balancer cannot be implemented on behalf of MySQL. However, LVS is not familiar with this. The company's server Load balancer is nginx, so I decided
Sort according to the information on the Internet.
MySQL address: http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-4.1.21.tar.gz/from/http://mirror.vmmatrix.net/mysql/
Yi. Install MySQL 4.1.21# Groupadd MySQL# Useradd-G MySQL# Tar-zxvf mysql-4.1.2
1. Basic syntax of the trigger:
Create trigger {before | after} {insert | update | Delete} on {table name} for each
Row
First, we understand that the trigger belongs to a table. The operation is caused by the insertion, deletion, and
In general, there are two possible causes for Garbled text. The first reason is the incorrect encoding (charset) setting, which leads to the incorrect encoding resolution by the browser, resulting in the "tianshu", which is full of screens ",
Author: skateTime: 2013/03/25
Install and use tpcc-MySQL
Download ToolkitTpcc-MySQL is a product derived from tpcc. It is used to test the system performance of OLTP (online transaction processing, TPCC-MYSQL is open source TPC-C testing software.
Author: skateTime: 2013/05/13
MySQL replication Environment check script
This script is deployed on the slave side. You can monitor the mysqld health, replication Environment Health, and replication latency of slave by text message or
Flex uses Web service to operate MySQL
The problems encountered in the project are solved step by step, and the learning notes are gradually summarized. Today, the whole project is a complete solution. In fact, there are still many problems that
in front of date-time text. Corresponding to class name 'sun' & 'moon'-->
MySQL backup and recovery policy (iii) 12:11:54 big label: knowledge/exploration MySQL backup and recovery MySQL backup policy MySQL recovery policy mysqldailybackup. Sh note:
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service