This script allows me to accidentally find a web attacker to use tcpdump to capture MySQL traffic and filter SQL statement input.
The script is not very long, but it works very well.
#! /Bin/bash # This script used montor MySQL
First find The DSN location
Chinese version: Control Panel-> Administrative Tools-> data source (ODBC)
English version: control pannel-> Administrative Tools-> data source (ODBC)
Click Add on userdsn, find MySQL ODBC driver, and fill in the
To describe the tablespace, MySQL's tablespace management is far from perfect. In other words, MySQL has no real tablespace management at all. MySQL's InnoDB contains two tablespace file modes: the default shared tablespace and the independent
I installed PHP 5 on Windows a few days ago.
Blank when MySQL connection is found
Gg and found that there is no display_errors on
After an error is displayed, call to undefined function mysql_connect ()
Literally, the MySQL DLL cannot be found.
My actual operations on windows are as follows: 1. Close the running MySQL and end mysqld-nt directly through the task manager. 2. Open the DOS window and go to the MySQL \ bin directory. 3. InputMysqld-NT -- skip-grant-tablesPress enter. If no
Example:
Existing tables tab1 and tab2
The trigger must have the following functions
When you insert a record to tab1, tab2 also inserts the same record.
Mysql> delimiter // mysql> Create trigger t_afterinsert_on_tab1-> after insert on tab1->
1. access method after successful MySQL Installation
/The first method is to enter:
Click Start ---> AllProgram---> MySQL --> MySQL server5.0 ---> MySQL command line Client click
Enter Password: Root press ENTER
You can enter the MySQL
1. Use phpMyAdmin, which is the simplest. Modify the user table of the MySQL database, but do not forget to use the password function.2. Use mysqladmin, mysqladmin-u root-P password mypasswd3. mysql> replace into mysql. User (host, user, password)
Alter table: add, modify, and delete table columns, constraints, and other table definitions.
View column: DESC table name;
Alter table t_book Rename to BBB;
Add column: alter table table name Add column name varchar (30 );
Delete column:
Part1: Change MySQL Default character set to utf8 in my. CNF
Http://stackoverflow.com/questions/3513773/change-mysql-default-character-set-to-utf8-in-my-cnf
[Mysqld]Init_connect = 'set collation_connection = utf8_unicode_ci'Init_connect = 'set names
Use the show STATUS CommandMySQL will give a long listOfficial Instructions in http://www.mysql.com/doc/e...Meaning:Number of times the aborted_clients client has been disconnected illegallyAborted_connects connection failure countThe number of
When data is extracted from the production environment to the warehouse, Chinese characters in the target database are garbled. My environment is from MySQL to MySQL. There are no heterogeneous databases at the moment, and the architecture is
MySQL database errors caused by power failure or abnormal shutdown are very common problems. There are two methods: one is to use the check table and repair table SQL statements of MySQL, and the other is to use multiple myisamchk and isamchk Data
I. Windows Backup commands:
1. Create a directory named backup under drive C and save the following code as backup. bat.
@ Echo set ipset IPaddress = 127.0.0.1 @ echo of the MySQL database set the MySQL database name set db_name1 = lxyy_db @ echo
Add a user first (but also use the root user)
Format: grant permission on database name. Table name user @ login host identified by "User Password ";Grant select, update, insert, delete on *. * To zhxia @ '%' identified by '123 ';
Or all
Installation and configuration diagram of mysql5.1
1. Install mysql5.1
Open the downloaded installation file and the following page is displayed:
Start the MySQL Installation Wizard and click "Next" to continue
Select the installation type, which
I. By defaultMySQL runs in autocommit mode. This means that after you execute a statement for updating (modifying) The table, MySQL immediately stores the update to the disk. The default level is non-repeated read. II:It may cause implicit statement
Http://blog.163.com/zhangjie_0303/blog/static/990827062011626101417417/
Create a memory table in MySQLHow to Create a memory table?Creating a memory table is very simple. You only need to specify engine = memory:Create Table 'tablename' ('columnname'
SQL statements that can be used in Stored Procedures mainly include the following types: 1. No return result statements, such as insert, update, drop, and delete.
2. The SELECT statement returns a single-row variable and can be passed to the local
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