MySQL

Environment Description: Ubuntu 10.04.2 QTSDK (the one in the 1.5G installation package) mysql5.1 1. Install MySQL Linux under the full MySQL development needs to install the server side, if the installation of the client is nothing bad. Search

1: Open Binlog log record Modify the MySQL configuration file Mysql.ini, add under [mysqld] Node Copy Code code as follows: # Log-bin Log-bin = E:/log/logbin.log Do not include Chinese and white spaces in the path. Restart

Linux forgot MySQL password processing method:#/etc/init.d/mysql Stop# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &# mysql-u Root MySQLmysql> Update user Set Password=password (' NewPassword ') where user= ' root ';mysql> flush

See Zhang Yi Blog on the "Http/rest client article", how to install what the direct skip, the following directly into the test phase, test environment: virtual machine Copy Code code as follows: [Root@localhost ~]# Uname-a Linux

But there was a problem: First, running PHP is Apche users, such as the nobody, then it is generally not authorized access to the/usr/local/mysql/data directory Second, even if you can access, then how can you copy the files in

PHP's handling of Chinese strings has been plagued by novice programmers who have just come in contact with PHP development. The following is a brief analysis of the Chinese string length of PHP processing: PHP comes with functions such as strlen ()

I. Evolution: The varchar type of MySQL database has a maximum length limit of 255 in the version below 5.0.3, and its data range can be 0~255. In the MySQL5.0.3 and above versions, the length of the varchar data type is supported to 65535, which

Unsigned is not a negative number, use this type can increase the length of the data! For example, if the tinyint max is 127, then the tinyint unsigned maximum can reach 127 * 2 The unsigned property is only for integers, and the binary property is

A bit of a problem occurred today in the process of using the order by, and it was wrong to understand that it was previously understood. See the use of order by on the W3s Web site before, thinking that the selected data is sorted in ascending or

The default behavior of timestamp before MySQL 5.6.6: Timestamp column if the null attribute is not explicitly declared, the default is not NULL. (Other data types, if not declared as NOT NULL, allow null values.) Sets the timestamp column value to

We know the way to analyze the query performance of MySQL statements in addition to using the explain output execution plan, you can also let MySQL record queries that exceed a specified time, and we'll call the SQL statement query that exceeds the

Environment MySQL 5.1 + command line tools problem MySQL table field Set default value Solve Copy Code code as follows: --sql: CREATE TABLE Test ( i_a int not NULL DEFAULT 1, Ts_b Timestamp not NULL DEFAULT now (), C_c

When a unique column inserts a record containing duplicate values on a unique key, we can control how MySQL handles this: Skip inserts using the Ignore keyword or on the DUPLICATE key update clause, Break operations or update old records for new

Often the company's development environment will be arranged in the intranet, and then there will be a common server for everyone to develop, test, so often there will be SSH connection server, or local MySQL client connection server needs, I

An introduction The basic principle of replace into is introduced in the previous article. This chapter provides an example of the potential data quality risk associated with the replace into, and when a table involving a replace into operation

Here we give int char no width, and the system assigns it a width by default. m indicates the maximum display width. The maximum effective display width is 255. The display width is independent of the range of values that the storage size or type

The prompt command can display information about the current user, database, time, and so on at the MySQL prompt Copy Code code as follows: Mysql-uroot-p--prompt= "\\u@\\h:\\d \\r:\\m:\\s>" After the setting is successful:

A few days ago to help colleagues solve a case, in the master-slave replication environment, from the library on the MySQL version number is 5.5.5, encountered the following error: #其他非相关信息我都隐藏掉了 [(yejr@imysql.com)]> show slave status \g;

First, introduce a few key points about the InnoDB engine storage format:1, InnoDB can choose to use shared table space or independent table space, the proposed use of independent table space, easy to manage, maintain. Enable the

Original Address http://www.cnblogs.com/linjiqin/p/5270938.htmlConfigure MySQL to allow remote connection methodsBy default, MySQL only lets you log on locally, and if you want to turn on remote connections, you need to modify the/etc/mysql/my.conf