MySQL

One. Installation1.yum install mariadb-server-y//Online installation database2.systemctl start Mariadb.service//Start database service3.systemctl Enable Mariadb.service//Set boot upTwo. Access settings: Turn off the firewallSystemctl Stop

Install MySQL under Windows, and note whether your Windows is 32-bit or 64-bit.MySQL official website: https://dev.mysql.com/downloads/mysql/After downloading, unzip and put in the location you need, for example: D:\MySQL\mysql-8.0.11-winx64Next,

MySQL Address: https://dev.mysql.com/downloads/repo/yum/Detect if MySQL is installedRpm-qa | grep MySQLUninstall MySQLRPM-E MySQLRPM-E--nodeps MySQLInstallationwget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpmRPM-IVH

steps to operate MySQL :1. Import MySQL Module2. Create a connection3. Creating Cursors4, perform Select/update/delete/insert and other operations (except select other operations need commit)5. Close the cursor, close the connectionImport

To export a database:1, Windows cmd Open command line2, CD to the bin directory of the installation directory of MySQL, if the bin directory is added to the environment variable does not need to switch to the bin directory3. Export database:

Mysqldump Minimum permission description required for backup:1, for table,mysqldump minimum must have SELECT permission2, if you want to produce a consistent backup, mysqldump to have lock tables permissions3, for View,mysqldump to have show view

MySQL Performance test tool-sysbenchSysbench IntroductionSysbench is a cross-platform benchmarking tool that supports multiple threads, supports multiple databases, and includes several types of tests, including the following:CPU PerformanceDisk IO

To small white to see, the Big God skipped!!1.1First to the MySQL official website www.mysql.com please add link description download, must go to the official website.I am here to download the 5.7.22 version of the installation, the WIN10 system for

Recently found a customer development company to deploy the production MySQL database innodb_buffer_pool_size is the default value, physical memory is 32G, the results are obvious, the performance problem is very large.It is advisable to set the 50%~

EF core Operation MySQL is currently officially available in the latest version: 8.0.1The packages that need to be installed are:Mysql.dataMySql.Data.EntityFrameworkCoreMySql.Data.EntityFrameworkCore.DesignOther installation packages do not install,

1. Create a new SH script (you can first build a txt text and then change to SH file).The code is as follows:#!/bin/bash#set up MySQL backup directoryfolder=/**/**CD$folder Day=`Date+%y%m%d ' RM-rf$daymkdir $dayCD$day#Database ServerIp=ip

One, the key configuration 1. Location of the configuration fileMySQL configuration file/ETC/MY.CNF or/ETC/MY.CNF.D/SERVER.CNFA few key documents:. pid file, which records the process ID. sock file, which is the socket interface used for internal

1. Create a userCREATE user username @ ' IP address ' identified by ' password ';CREATE user username @ '% ' identified by ' password ';ps:% indicates that all ID addresses can connect to the database, and the IP address indicates that only this IP

Tag: Key equals bin name 127.0.0.1 database name Mail primOne, log in to the MySQL database server from the command line1. Log in with MySQL using the default 3306 port/usr/local/mysql/bin/mysql-u root-p2. Manage multiple MySQL on different ports

MySQL partitioned partitions are two ways to solve the poor MySQL performance caused by large data volumes.What is MySQL sub-tableFrom a superficial point of view, the MySQL sub-table is to divide a table into multiple tables, and the data and

Click the link to join the group "Php/web Learning class": Https://jq.qq.com/?_wv=1027&k=5645xiwWelcome to join us and discuss learning together.Here we have to complete the scheduled task, relatively simpleEffect: Every x seconds some user points

The first step: building a frameworkNew enter this pageNew name, first time can default, then nextStep Three: Select dependenciesFourth step: Create a new project name and store the project path (you can create a new folder to store)Click Finish,

ALTER TABLE project_listCHANGE COLUMN descriptionofproj proj_desc VARCHAR(100),CHANGE COLUMN contractoronjob con_name VARCHAR(30);MODIFY: Use it to modify only the type of the column without interfering with its name, assuming you want to change the

A trigger is a database object that is related to a table, and a trigger can only be a permanent table created and not a temporary table.1.1 Creating a Trigger-- Syntax: CREATE TRIGGER trigger_name trigger_time trigger_event on for Each ROW

1, VirtualBox to Ubuntu system settings, "Network" select "Bridge network card"2. Install MySQL serversudo su; Apt-get Intall Mysql-server3. Grant permission to remote access:Grant all privileges on * * to ' root ' @ '% ' identified by ' 123456 '