MySQL

Sometimes forget the root password of MySQL, how to do?At this time, we can modify the MY.CNF, add the way to start without checking permissions, then modify the root, and finally restart the MySQL database.(1) Service MySQL stop[[Email protected]

Load data data in MySQLmysql> load Data infile '/home/a.txt ' into table table_a;ERROR (HY000): Can ' t get stat of '/home/a.txt ' (errcode:13)We use the perror command to print out specific error messages>perror 13OS error code 13:permission

OverviewIn order to improve concurrent MySQL to join the multi-version concurrency control, it saves the old version record in the shared table space, the transaction is not committed before the corresponding row record or lock restrictions, when

Transferred from: http://blog.csdn.net/heiyeshuwu/article/details/49130567(Note: This article was written in 2011) MySQL Monitoring Tuning MySQL server hardware and OS operating system MySQL Configuration MySQL Schema

MySQL Database installation Complete the default administrator's login password is empty, so you can not enter the password to log in directly to the database, which is not secure, the following article briefly describes how to set the Administrator

ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)As noted above, the Mysql.sock file is missing.Workaround:Ln-s/tmp/mysql.sock/var/lib/mysql/mysql.sockKThere may be some homecoming error in the/

One: The method of killing MySQL connection:Kill thread_id: Kills the current process, disconnectsKill query thread_id: Only Kill a connection to the current SQL, and keep the connection open.Several ways to kill MySQL connections in bulk:1>

1.Download Connector/python:mysql-connector-python-2.1.3-py2.7-win32 mysql:mysql-installer-community-5.5.48.0 python:python-2.7.10 2. Install the Python,mysql

Article attribution: http://feiyan.info/16.html, I would like to summarize, but found this June summary of very detailed. Moved right over here.With regard to the benefits of MySQL indexing, if the correct design and use of the indexed MySQL is a

SOURCE Package Download:Compile and install:To set the configuration file:To add a startup script:To add a boot entry:When finished,/etc/init.d/mysqld start error is as follows:Starting MySQL. The server quit without updating PID file

A Brief introductionKeepalived+lvs+mysql Primary master replication is a much more frequently used MySQL high-availability scheme, in which LVS provides read load Balancing, keepalived the virtual VIP drift to achieve self-failover, while MySQL is

1. Requirements DescriptionBecause MySQL uses master-slave AB replication in the bottom of OpenStack, in order to monitor the master-slave state information of the database, the master-slave state of MySQL needs to be monitored to ensure that the

The learning of SET statements:Practice of defining User variables using SelectChange the following statement to the form of select:Set @VAR = (select sum (amount) from penalties);My changes:Select @VAR: = (select sum (amount) from penalties);I can

Mysql-proxy: For short, MySQL read-write separation; The main purpose is to improve the speed of Web site access.First build MySQL master and slave, reference: http://syklinux.blog.51cto.com/9631548/1737317Download Mysql-proxy:Cd/usr/local/srcwget

bigint 20-digit 8-byteInteger data (all numbers) from -2^63 (-9223372036854775808) to 2^63-1 (9223372036854775807). The storage size is 8 bytes.9223372036854775808P.S. bigint already has length, in MySQL build table length, just used to display the

In most scenarios we are using MySQL master-slave replication to achieve database redundancy, here is the multi-level replication to deal with, multi-level replication can quickly and easily deal with the database failure, the database has a, B, C

1. Download the ODBC database driver (Mysql-connector-odbc-5.3.4-win32.msi or mysql-connector-odbc-5.3.4-winx64.msi) that installs MySQL:/http dev.mysql.com/downloads/connector/odbc/2. Create a new empty text file on the desktop mysql.txt, rename it

OverviewVariables are often used in stored procedures, and the use of variables is an important point of knowledge, especially when defining conditions.MySQL Version: 5.6variable definition and assignment#创建数据库DROP DATABASE IF EXISTS dpro; CREATE

The example in this article describes how MySQL sets trigger permissions and is useful for permissions errors. The specific analysis is as follows:MySQL Import data tip does not have SUPER privilege permission handling, as follows:ERROR 1419 (HY000):

Mysql Command (database backup and recovery), mysql Database Backup Local: 1. Enter the bin folder in the MySQL Directory: e: Press ENTER; E: \> cd mysql \ bin? Enter 2. Export Database: mysqldump-u username-p Database Name> exported file