1.RPM Package Installation MethodRPM Package installation is very simple, here is the EL6 platform under the mysql-5.6.34 version for example, first, the above Sohu image address to download to the following four MySQL-related software installation
1. Create MySQL user, MySQL group.# useradd-s/bin/nologin-m MySQLSee if the creation was successful.# ID MySQL2. The MySQL-speaking binary package is extracted to the/usr/local/directory.# cd/usr/local/# TAR-ZXVF
★ Add Series ★----copying tables (with data)----CREATE TABLE table name Select *from Cousin name----Copy tables without data----Create TABLE table name like cousin name----Insert data from an existing table into a new table (in the same
1,mysql wakes up the database, mysql-uroot-p112212, creates a database: Create databases mldn CHARACTER SET UTF8; can also be written in lowercase: Create database Wang Charact Er set utf8;3, view all databases: Show databases;5, using MLDN
1. Create userCreate a username that is Lefunyun password is X5A4FU8I0LKM21YPYUZP accountCREATE USER [email protected] identified by ' X5A4FU8I0LKM21YPYUZP ';2. Give account AuthorizationGrant the account all permissions to the Lefuyun library,
1. Backup# Export Database: Mysqldump-u username-P database name > exported file nameMysqldump-–add-drop-table-uusername-ppassword databasename > Backupfile.sqlNote: 1, enter the password, enter the password of the database user name2. If you export
Install and start the MySQL database under Linux and WindowsPython installs the MYSQLDB package, it is recommended to use PIP installationHere's how to use PIP:Yum Install Python-pip (priority installation Python-pip to use PIP)Pip is similar to Yum
Machine standardization: Server hardware configuration (CPU, hard disk, memory, RAID) to be consistentDirectory standardization: MySQL installation directory, storage data directory, log files, etc., on multiple machines to be unified
In practice, it is sometimes necessary to import large-capacity SQL files to MySQL, usually in the following three ways:(1) through phpMyAdmin, not recommended, there is memory and other restrictions;(2) running SQL through Navicat Premium tool, not
Forgot password1, MySQL5.7 in the installation directory of My-default.ini (My computer installed two MySQL database, and 5.7 shared 3306 port, MySQL5.6 in My.ini file) Add the statement: Skip-grant-tables2, restart the service canYou can create a
Note: This article uses the mysql5.5 version as an example. The students who have done database development should not be unfamiliar with view. I have access to the most views of the application scenario has two: 1) for permission issues, in order
Today to determine whether MySQL is empty directly write a field example Image_url!=null Results The database does not report errors and does not return relative data.Forget about it again. It's a special record today.Because null means nothing, not
Problem:When the MySQL table was created, it was found that the unification was turned into lowercase after completion, whether it was uppercase or lowercase.Reason:MySQL is case-insensitive under Windows, and table names are automatically converted
They are stored in different ways and data are retrieved differently.Data retrieval efficiency is: char > VarChar > TextSpace occupancy, it is necessary to specifically analyze the specific situation.
1.char: It is convenient to store the fixed-
What is MySQL read-write performance and what are the performance-related configuration parameters?
when Mysql load is high, how do I find out what SQL is causing it?
how to target a specific SQL to do optimizations?
The SQL
First, the basic operation of the database1 CREATE DATABASE Mybookstore; 2 DROP DATABASE Mybookstore; second, the basic operation of the table 1. Create a table Insert into table name (field name 1, field name 2) VALUES (value 1,
Summary of the process for installing a mysql database on a CentOS-6.9-x86_64-minimal,
1. Create a mysql user and a mysql group.
# Useradd-s/bin/nologin-M mysql
Check whether the creation is successful.
# Id mysql
2. Extract the mysql binary package
Database System introduction, database IntroductionWhat is a database system?
DataBase System = Database (DB) + Database Management System (DBMS) + DataBase Application (DBA ))
Database: a set of logically related data that can be shared and data
Detailed analysis of mysql database transactions and mysql Database Analysis
Let's explain the background before writing!
I have been doing development for a long time, but I have not learned much about it. Now I want to analyze my
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service