MySQL

Server IP Address planning (10.x analog public address, 192.x private network address, 172.x private network address)NFS：192.168.30.33WEB1:192.168.30.17WEB2:192.168.30.27LVS:192.168.30.7 VIP:10.0.0.100DNS:172.20.42.27Mysql:192.168.30.30Route:192.168.

First step: Link the database Mysqli_connect (); Parameter 1: Address of the linked database Parameter 2: User name of the database Parameter 3: the database Mask Parameter 4: Optional parameter, default database to

There are a few things to keep in mind when establishing a primary foreign key for MySQL data tables:The storage engine for the two tables that need to establish a primary foreign key relationship must be innodb.Foreign key columns and reference

1. Download: Http://dev.mysql.com/downloads/mysql/5.6.html#downloadsDownload version: I choose here 5.6.33, General edition, Linux under 64-bitYou can also directly copy the 64-bit, download by command: wget http://dev.mysql.com/get/Downloads/MySQL-5

MySQL InnoDB Engine table copies physical files for single-table or specified table replication, you can think of many ways to test 2 of them today: Modify the InnoDB engine's table to the MyISAM engine, and then copy the physical file

Requirements: Back up the MySQL database and upload the data backed up files to the FTP serverFTP Server IP Address: 192.168.6.9FTP Server account/password: test/test1231. Root user creates backup script path:$ mkdir /opt/databak$ cd /opt/databak2.

Unzip the MySQL 5.7 binary package to the specified directory[Email protected] ~]# tar zxvf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz-c/usr/local/Create a MySQL soft link[[Email protected] ~]

Database Tools--navicat Premium Usage TipsNovember 29, 2016 10:37:25Hits: 8739Navicat Premium General Features explainedNavicat Premium General Features explained1. Shortcut keys1.1. F8 quick return to current object list1.2. Ctrl + q to open the

SHOW VARIABLES like '%lower_case_table_names% ';SELECT VERSION ();In the project, the table name is capitalized in the Quartz timer task, but the table name established in the database is lowercase, causing the report to not exist when Springboot is

1. Database Login operation:Database Login- - - -PLocal login:Mysql-u root-p2. Database Management operations:View all databases:show databases;Create a new database and set the database encoding to UTF8:Create database db character set UTF8;Modify

Transfer from Weibo: http://www.cnblogs.com/centor/p/6142775.htmlTools: EclipseMySQL5.6MySQL Connection driver: Mysql-connector-java-5.1.27.jar (link: https://pan.baidu.com/s/1MmFZ9Hve6rV0tlryM3raeA password: q74m)Load driver:1. Create the Lib

Seven types of log filesThere are seven types of log files in MySQL, namely: Redo log (redo log) Rollback log (undo log) Binary log (Binlog) Error log (errorlog) Slow query logs (slow query log) General query log

0x00 Load_file () Conditions: 1. 要有file_priv权限2. 知道文件绝对路径3. 能使用union4. 对web目录有读权限 注：若过滤了单引号，则可以将函数中的字符进行hex编码 General steps Read the/ETC/INIT.D, here's the config file path. ?id=1‘ union select 1,2,load_file(‘/

Recently, in the blog, before the establishment of a blog, thinking about a very important question: Ms-sql and MySQL database which is more practical?Perhaps a lot of people do not understand why I want to think about this problem, because most

MySQL [email protected]-PEnter Password:ERROR 1862 (HY000): Your password has expired. To log the must change it using a client that supports expired passwords.ModifyVim/etc/my.cnfdatadir=/home/mysql/dataport = 3306user =

Recently learned Python web crawler, so I wrote a simple program to practice practiced hand (hehe. ）。 I use the environment is python3.6 and mysql8.0, crawl target site for Baidu hotspot (http://top.baidu.com/). I only grabbed real-time hotspot

To modify the configuration:Vim/etc/my.cnf[Mysqld]Basedir=/home/mysqlDatadir=/home/mysql/dataPort = 3306user = MySQLCharacter_set_server=utf8 Skip-grant-tables [Client]Default-character-set=utf8Service mysqld StartStarting MySQL. [OK][[

工欲善其事, its prerequisite! The operation of the database also requires good tools, learning process has been using NAVICAT to operate, feeling very useful.Always use mouse punctuation is also more trouble, so search summary of the use of shortcut keys,

[Client] [mysql]prompt= (\\[email protected]\\h) [\\d]>\\_   [mysqld]####### #basic settings####### #server-id = 11port = 3306user = Mysqlbind_address=192.168.1.254autocommit = 0character_set_server= Utf8skip_name_resolve = 1max_connections = 800max_

I. Process functions--Create a table to describeCREATE TABLESalary (UserIDINT, salaryDECIMAL(9,2));INSERT intoSalaryVALUES(1, +),(2, -), (3, the),(4,4000),(5, the), (1,NULL);SELECT * fromSalary1. if (value,t,f) more than 2000 of the use of high,