MySQL

Sometimes when you build a station because the database and the site in different IP, this time need to use the program MySQL remote connection, and MySQL because of security factors, the default time users set is not remote connection, only local

Copying recordsLower case-insensitive functionsPassword encryption function CREATE TABLE Employee> CREATE TABLE employee (ID int,name char (), AGI int,sex enum (' M ', ' F '), Department char (10));> INSERT into employee values (g, ' John ', ', ' m

Root account permissions are lost we can hardly do a lot of things, today this article to introduce you to the MySQL database root account permissions to solve the problem, I hope the article can help you. There are a lot of database operating

Today, using PHP to develop a Web site, meet a demand. Count Google traffic on the site's keywords to calculate the growth of a keyword this week for Google traffic last week. Goole flow statistics are obtained through the Log Analyzer program. The

When are we going to use the copy table? For example: I now operate on a table, but I am afraid of accidentally delete data, so in the same database to build a table structure, table data is the same table for backup. If use mysqldump compare

MySQL has a function is log down to run the slower SQL statement, the default is not this log, in order to open this function, to modify the my.cnf or in the MySQL boot when the add some parameters. If you modify inside the MY.CNF, add the following

There are three standard loops in the statements of the MySQL stored procedure: The while loop, the loop loop, and the repeat loop. There is also a non-standard way of cycling: GOTO, but this cycle is best not to use, it is easy to cause confusion

1, the MySQL database does not have an incremental backup mechanism, when the amount of data is too large backup is a big problem. Fortunately, the MySQL database provides a master-slave backup mechanism, which is to write all the data in the

In MySQL, there is no top keyword, but you can use limit to complete this function, the following examples for you to explain the details of its use, not friends can learn under In MySQL, there is no top keyword, in MySQL can use limit to complete

Author:skate Time:2013/04/11 MySQL's sql_mode reasonable setting Sql_mode is a very easy to ignore variable, the default value is null, in this setting can allow some illegal operations, such as allowing some illegal data insertion. This value

Workaround One: MySQL installation when the code, Look at the My.ini, there's no [MySQL] Default-character-set=utf8 [Client]Default-character-set=utf8 [Mysqld]Default-character-set=utf8 set up when creating a table: DROP TABLE IF EXISTS '

The use of select for update in MySQL must be for InnoDB, and in a transaction to work. The criteria for a select are different, with row-level or table-level locks. Because the InnoDB preset is Row-level lock, MySQL executes Row lock (only the

This article mainly introduces the PHP connection is not MySQL but the MySQL command line operation of the normal solution, the need for friends can refer to theFailure Status: PHP Web Connection MySQL failed, but at the command line through the

Some MySQL publications have made changes to the structure of the system tables in the MySQL database, adding new permissions or attributes. When you update to the new version of MySQL, you should also update the system tables to ensure that their

If you never set the root user password for MySQL, the server does not need a password to connect as root. However, it is recommended that you set a password for each account. If you have previously set the root user password, but have forgotten

This article mainly describes the way in which MySQL responds to a disk full error (such as "No remaining space on the device"), and how to respond to a quota error (such as write failure or "Reach User screen limit"). The content described in this

First, limit the concurrent processing of innodb. If innodb_thread_concurrency = 0 can be changed first to 16 or 64 to see machine pressure, if Very large, first changed to 16 to let the machine pressure down, and then gradually increase to adapt

Today, developers continue to develop and deploy applications that use the lamp (Linux?, Apache, MySQL, and Php/perl) architectures. However, server administrators often have little control over the application itself, because the application is

[Client] #passwd = your_passwd Port = 3306 Socket =/data/mysql/mysql.sock [Mysqld] #global settings Port = 3306 Socket =/data/mysql/mysql.sock Basedir=/usr/local/mysql Tmpdir=/data/mysql Datadir=/data/mysql

1. Overview There are two ways to import a MySQL database: 1 lead out the database SQL script, and then import; 2 directly copy the database directory and files. In the case of different operating systems or versions of MySQL, the method of