0, download and extract the zip version of MySQL
1, add environment variable path D:\mysql-5.7\bin;
2, add the Data folder in the D:\mysql-5.7\
3, modify the My-default.ini configuration file
Basedir = D:\mysql-5.7
DataDir = D:\mysql-5.7\data
MySQL Database Usage Summary
This article mainly records some MySQL daily use of the commands for future inquiries.
1. Change root password
Mysqladmin-uroot password ' yourpassword '
2. Remote login MySQL Server
Mysql-uroot-p-hip-p3306
3.
Http://dev.mysql.com/doc/refman/5.6/en/converting-tables-to-innodb.html
Identify all table information, display as MyISAM for MyISAM engine
SELECT table_name, ENGINE from INFORMATION_SCHEMA. TABLES where Table_schema = ' dbname ';
The second step
A notable feature of MySQL is its pluggable storage engine, so there are two types of MySQL files, one that is related to the MySQL database itself, and one that is related to the storage engine. This article mainly describes the files associated
#错误原因: The innodb_log_file_size was modified in the My.cnf file,
#导致ib_logfile文件的大小与之前存在的文件大小不匹配;
#解决方法: Delete ib_logfile and restart the database when the database is cleanly shut down
120221 06:47:03 mysqld_safe mysqld from PID File/home/mysql/
First of all, let's elaborate on the following points:
Figure: When a user accesses virtual machine 2, you can access the Discuz forum, which is mounted via NFS, where the data is stored in virtual machine 1, to ensure that when the content of
#!/usr/bin/env python #coding =utf8 #author: Itnihao #mail: itnihao@qq.com #source: Http://code.taoba o.org/p/python2/src/trunk/#version: 1.0 ' function: MySQL backup. Use Mysqldump to backup the libraries in mysql 1.user,pass,host,path,del
1. Server-level lock waitsthe thread ID of the wait lock can be seen through show processlist, but there is no way to know exactly which thread holds the lockcan be mysqladmin by debug The associated thread waiting for the lock and who holds the
1. Export the entire databaseMysqldump-u User name-p password database name > exported file nameC:\users\jack> mysqldump-uroot-pmysql Account > E:\account.sql2. Export a table, including table structure and dataMysqldump-u User name-p password
Sort by multiple criteria in MySQL: (separated by commas between each condition)First, based on the length of the class_name string in ascending order, and then descending according to the start time:[PHP] view plain copy
SELECT * from
In a real-world production environment, data is critical. The key to saving a company is how to implement secure redundancy of data and quickly recover data in the event of an accident or disaster. Then, backing up data on a regular basis is a basic
1, configuration: From centOS6.5 system, MySQL database2. Commands for exporting. sql files:Mysqldump-uroot-h116.228.90.147-p18006-p Aimo >/home/aimo.sql3. Explanation:I, Mysqldump is the utility that MySQL uses to go to the storage database. It
Comparison of the two modes:Statement Advantageslong history, mature technology;The resulting binlog file is small;The binlog contains all the database modification information, which can be used to audit the database security and so on.Binlog can
Data on Hadoop server, need to import MySQL can operate directly on HadoopTo know the MySQL account password hostSteps:Enter the shellInput: Mysql-u ' name '-P ' password '-h ' host_number ' (--DEFAULT-CHARACTER-SET=UTF8) does not need quotes in
1. How to prevent SQL injection
Check the variable type, and if it is shaping, use the Intval method to convert to int
The string type uses the Addslashes function to filter special characters (it adds a backslash escape before the
"Phenomenon & Background"This service is an intermediary service that provides routing rules calculation and SQL filtering for database sub-tables. That is, upstream will send the request to the service, the service according to the Sub-database
Today talk about how MySQL master-slave replication can do!Preparatory work:1. Two virtual machines: I'm using CENTOS5.5,IP addresses, respectively, 192.168.1.101 and 192.168.1.105;101 master server, 105 do from the server (both have installed the
Binlog2sql usage summary, binlog2sql Summary
Binlog2sql is an open-source tool for parsing binlog. It has been tried in the test environment and is not bad.
It has the following functions
1. Extract SQL
2. Generate a rollback SQL statement
For
For Windows (x86, 64bit), upgrade MySQL 5.7.17 to an installation-free version. For more information, see mysql5.7.17.
MySQL must be upgraded to version 5.5.3 or later to support Laravel 5.4's default utf8mb64 character encoding. Therefore, I
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