MySQL

MySQL version: Mysql-5.6.24-solaris10-sparc-64bit.tarOperating system: Solaris 11g U10Operation User: Use non-root operation installation, a-way server IP address is 192.168.1.1 B IP address is 192.168.1.2 (should be changed to actual IP address)1.

The first method: more detailedThe following article mainly introduces the MySQL database to open the time of the remote connection operation process, in fact, the actual operation of the remote connection to the MySQL database is not difficult, the

If Table A's primary key is a field in table B, the field is called the Foreign key of Table B, table A is called the primary table, and table B is called from the table. Foreign keys are used to achieve referential integrity, and different foreign

Server environment:Main mysql:192.168.1.163From mysql:192.168.1.126vip:192.168.1.50First, MySQL configuration master-Slave synchronization1. Configure the primary MySQL serverVim/etc/my.confEstablish an account and authorize slaveLock the main

Install MySQLSeveral common installation packages for MySQL: rpm, source code, binary-free compilationCd/usr/local/srcwget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gzTar zxvf

Usually in the MySQL database backup and recovery, most of the use of CMD in the implementation of the MySQL command to implement. For example:Mysqldump-h127.0.0.1-uroot-ppass Test > D:/test.sql ---Back up test database to D driveMysql-h127.0.0

Views ViewA view is a virtual table whose contents are defined by a query. As with a real table, a view contains a series of column and row data with names. However, the view does not exist in the database as a stored set of data values. Row and

First, view the database encoding format? 1 mysql> show variables like‘character_set_database‘; Second, look at the data table encoding format? 1 mysql> show createtable; Iii.

Use test;CREATE TABLE ' employee ' (emp_no int unsigned,Emp_name varchar (30),Emp_sex varchar (3),Emp_age tinyint unsigned,Sal Double,History datetime);INSERT into employee values (1, ' Zhang San ', ' Male ', 18, 5000, ' 2012-04-23 '),(2, ' John Doe

What is a storage engineLibrary ===> folder created in MySQLTable ===> files created in the libraryIn real life, the files we use to store data should have different types: for example, TXT type for storing text, Excel for Save form, PNG for image,

Direct use of Navicat via IP connection will report various errors, for example: Error 1130:host ' 192.168.1.80 ' is not allowed to connect to this MySQL server.After personal verification, a solution is obtained, as follows:Authorization law:1.

1. Create database-related commands:First, download the MySQL-related package: Aptitude install Mysql-server/mysql-clientThe root user in MySQL is similar to the root user under Linux and has the highest privileges, which can be a serious hazard to

Explain shows how MySQL uses indexes to process SELECT statements and join tables. Can help select better indexes and write more optimized query statements.Parse an SQL statement first to see what

This paper introduces the tuning method of MySQL, including slow log query analysis and explain query analysis SQL execution plan1. mysql optimization1, slow log query analysisYou first need to make some settings for the slow log, as follows:SHOW

Simply say that you install MySQL experience pit point, novice should be met. Newly bought a computer, the first installation of the situation: download several different mysql on the Internet, the installation is executed in the last step, do not

First KindMySQL version: 5.7.171. First we want to shut down the MySQL service sudo/usr/local/mysql/support-files/mysql.server Stop2. We're going to start with Safe mode mysqlsudo/usr/ Local/mysql/bin/mysqld_safe--skip-grant-tables3. Log in to the

In our actual infiltration, obviously found an injection point, this thought was lost to Sqlmap can be, the results Sqlmap only show is really injection point, but the database is not get, 1, then we can use manual injection, to determine the filter

Create a printable Chinese Database and print a Chinese Database Generally, the encoding type of data in a database isLatinl,This does not support Chinese Characters The Chinese character encoding isUTF-8AndGbk To enable the tables in the

How can Mysql use commands to achieve hierarchical search help? Preface This article mainly introduced to you the Mysql use command classification to find help related content, this article sample branch version MariaDB-10.1.19 Based on msql, share

How to reset the MySQL Root Password and set mysqlroot Reset the Root password Method 1:Add the following to the [mysqld] field of my. ini:Skip-grant-tablesRestart the mysql service. mysql can log on to the database without a password.Then go to