MySQL

MySQL multi-instance installation configurationI. Basic CONCEPTSMySQL multi-instance is to open a number of different service ports on a single machine (such as: 3306,3307,3308 ...), running multiple MySQL service processes, these service processes

User account and Rights management:User account: ' username ' @ ' host 'Host: When this user accesses the current MySQL server, which hosts are allowed to remotely create the connection;Representations: IP, network address, host name, wildcard (%

1) Log in to the MySQL database.Mysql–uroot–poldboy123Mysql2) View the currently logged on user.Selectuser ();3) Create the database Oldboy and view the complete statement of the built library . Create Database Oldboy;show databases;Show CREATE

Proofing rules: The order of comparisons between characters under the current encoding. (CS case sensitive, CI case insensitive, bin binary code comparison)1. View current proofing rules show collation;Each character set supports an indefinite

The Python full stack path series MySQL SQL injectionSQL注入is a code injection technique that used to attack data-driven applications such as injecting malicious SQL code into specific fields for the implementation of a drag-and-drop

PrincipleHttp://www.tuicool.com/articles/N7fueaBulk ScriptMysql-uroot-p ' xx '-e "select User,host from Mysql.user;" >/root/user.txtsed-i ' 1d ' user.txt#sed-i ' s/[[]*/@/g ' user.txtsed-i ' s/\s\+/@/g ' User.txtcat alter.sh #!/bin/bas Hfor i in '

MySQL Community Edition: http://dev.mysql.com/downloads/mysql/Because my system version is 64, download the x64 version here. After downloading, unzip to D:\Dev\Mysql (that is, the custom unzip directory for Mysql. ）My habit is to first register the

Create a stored procedure with no parametersCREATE PROCEDURE Procedure name () procedure Body SELECT VERSION ();Call the stored procedureName of the first call procedure (); (Used with parameters)Name of the second call procedure (used without

ALTER TABLE logtest CONVERT to CHARACTER SET UTF8 COLLATE utf8_general_ci;To modify the database character set:The code is as follows:ALTER DATABASE db_name DEFAULT CHARACTER SET character_name [COLLATE ...];Change the default character set of the

MySQL has three levels of Lock: page level, table level, row level.The MyISAM and memory storage engines use a table-level lock (table-levellocking);The BDB storage engine uses a page lock (page-levellocking), but also supports table-level locks;The

User management mysql>use MySQL; view mysql> select Host,user,password from user ; creating mysql> Create user  zx_ Root   identified by ' xxxxx ';  //identified by will use plaintext password encryption as a hash value to store modifications

1. InstallationI am using CentOS 7, the default Yum installation, but the default Yum installation version is a bit low, you can choose to upgrade as needed, I choose to upgrade and install first.Update YumUpdate Yum Package yum-y updateConfiguring

Custom functionsUser-defined functions are a way to extend MySQL, using the same functionality as built-in functionsFunctions can return any type of value, and they can also receive parameters of these typesThe function body consists of a valid SQL

First, the vertical segmentation of dataConcept: Vertical segmentation of data can also be referred to as vertical segmentation. Spread the different tables across different database hosts.An application system, the overall function is certainly

Connection query: A connection that records multiple tables (which can be more than 2 sheets) (data stitching according to a specified condition);The end result: the number of records is likely to change and the number of fields will increase (at

To modify the root user's password:/* Login mysql*/Mysql-uroot-p123/* Switch Database */Use MySQL/* Modify the root user's password */Update user set Password=password (' 1234 ') where user= ' root ';———————————————————————— a broken line ———————————

Ubuntu 16.04 Default installation php7.0 environment, but PHP7 current compatibility is not very good, if you install php5 need to clear PHP7 installed package, otherwise will error.First step: Remove the default and installed PHP packagessudo

Some time ago a test environment of the MySQL database root password can not be found, an unimportant library, the installer was negligent ... Restore the password manually. Write down a note.1. Enter my.cnf and add Skip-grant-tables in the [mysqld]

Database optimization is a PHP interview almost will be asked about things, but also our work should pay attention to the things, of course, if the small site does not optimize, site access to a large number of natural will burst the bottleneck of

MySQL5.5 installation tutorial, mysql5.5 tutorial 1. Download mysql5.5 from the official website : Http://dev.mysql.com/downloads/mysql/5.5.html#downloads   2. Install mysql5.5 Note: disable anti-virus software before installation. (1) Open the