MySQL

There are two major strides in opening MySQL's remote login account:1. Determine that the firewall on the server does not block port 3306.MySQL default port is 3306, need to determine the firewall does not block 3306 port, otherwise remote is unable

Today on the computer installed mysql5.7.16 (compressed package), after initializing the data folder, do not remember the password, DOS box does not show, no way, in order to learn how to change the password, in the Internet to find a lot of ways to

Http://www.cnblogs.com/tae44/p/4717334.htmlExperimental system: CentOS 6.6_x86_64 (2.6.32-504.30.3.el6.x86_64)Lab Prerequisites: Firewall and SELinux are offThe experiment shows that there are 4 hosts in this experiment, such as the topology of IP

MySQL Architecture and storage engine1.1 Defining databases and instancesDatabase: A collection of physical operating system files or other forms of file types. The database file can make FRM,MYD,MYI,IBD the end of the file.Example: The MySQL

Original: MySQL physical file Architecture Simple collation descriptionThe source of this article: http://www.cnblogs.com/wy123/p/7102128.html(It is not the original works right to retain the source, I my book still far to reach, just to link to the

What's New with MySQL Replication in MySQL 8.0MySQL replication has been around for many years now, and its stability and reliability are steadily improving. This is an evolutionary process, because many of MySQL's important functions are dependent

Talk about installing MySQL on this server is really a big hole ah! I do not know how the whim of the purchase of a Baidu cloud server, and then think about it to do some of their small projects are running up. Hey... In fact, just want to show off,

Three page, three kinds of list, LRU control tuning One, InnoDB buffer pool of three kinds of pages1.Free page: Pages that have never been used2,Clean page: Clear page, data page data and disk consistent3.Dirtypage: Dirty pagesSQL Execution

  This article goes from   How to export and import MySQL data (data migration)   This is one of the methods, very simple  1. Export database Data    mysqldump-uroot-p dp_db > dumpout.sql    where root is the account name          dp_db is the

The following three points are to be noted for using transactions:1. In MySQL, transactions are supported only by databases or tables that use the INNODB database engine.2, transaction processing can be used to maintain the integrity of the database,

SSL encryption method for MySQL 5.7MySQL 5.7.6 or later(1) Create a certificate to turn on SSL authentication--Installing OpenSSLYum Install-y OpenSSLOpenSSL versionOpenSSL 1.0.1e-fips 2013--Installation Certificate/usr/local/mysql/bin/mysql_ssl_rsa_

In the process of actually logging in to Redmine, we encountered the following errorError 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no) Error 1045 (28000): Access denied for us Er ' redmine ' @ ' localhost '

MySQL several performance testing tools to useRecently due to compare MySQL and its branches mariadb, Percona performance, understand a few of these tools, including: Mysqlslap Sysbench Tpcc-mysql, do a collation, memo, share1, MysqlslapInstallation:

The source of this article: http://www.cnblogs.com/wy123/p/6956464.htmlThis article only simulates using mysqldump and Log-bin binary logs for simple testing, only as a personal learning note, there may be a large gap from the actual application,

Recent projects have used the function of querying the data record of the month, the initial idea is to construct a good time period in the logic business query, when writing SQL statements feel very troublesome. So I went to search the Internet to

Note: Refer to the official website documentationMySQL decompression version of the installation configuration is broadly divided into the following 6 steps: Extract The main archive to the desired install directoryOptional: Also extract

"SQL Server":SQL Server considers null to be minimal.In ascending order : Null values are ranked first in the default.To arrange the back, then: the order by case if Col is null then 1 else 0 end, coldescending : null values default to the last.To

English Original: http://blog.frd.mn/install-nginx-php-fpm-mysql-and-phpmyadmin-on-os-x-mavericks-using-homebrew/Refer to post author: http://blog.liuweifeng.net/author/liuweifeng/First of all, to avoid all kinds of magical errors, please install

For MySql in Mac system, download MySQL5.7 detailed installation process, mysqlmysql5.7 1. Enter the following address in the browser: 　 2. Go to the following page: click the following position and select skip logon. Click this button to download

Analysis of MySQL group by group aggregation and subdivision aggregation, mysqlgroup Original article. For more information, see http://www.cnblogs.com/weix-l/p/75220.8.html; If any error occurs, please comment it out. Thank you! 1. Aggregate