This article is based on CentOS 64-bit 1. Download MySQL first (mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz) Download http://dev.mysql.com/downloads/from official website Select the appropriate Linux version 2. Copy the
MySQL single-machine multi-instance read-write separation can be achieved through third-party software, one of which is called simple read-write separation software is today brought to everyone's amoeba software.The amoeba software used for this
MySQL official website Download http://dev.mysql.com/downloads/mysql/Note that installing MYSQL-5.5.17-OSX10.6-X86_64.DMG is easy to installSet the system security permissions and click
SELECT from Sys_userResults:The Create_user_uin_tree in the table identifies who created the record.When creating a new user, the following SQL is available based on the UIn of the currently logged on user and the newly created user uin:Select
mysql commands the user to connect to the database. mysql command format: mysql-h host address-u user name -P user Password 1) connect to MySQL on this computer first open the DOS window, then enter the directory Mysql\bin, and then
1. find information for all students[Sql]select * FROM studentRows affected : 0Time : 0.000s2. Identify all the people who have passed the test[Sql]select * from student where Studentno in (select Studentno from result where Studentresult > 60)Rows
1. Error code:1175 You is using Safe update mode and you tried to update a table without a WHERE thatFast and Efficient use: SET sql_safe_updates = 0; don't look at it!When you use MySQL Workbench to perform a database management update today, a
In Linux, if we want to use a relational database, basically is MySQL, and the previous version of 7 CentOSThe system is the default integrated with MySQL. However, for the current CENTOS7 system, MySQL database is not supported, it defaultsInternal
Create a databaseCreate DATABASE discuz default character set UTF8 collate utf8_general_ci;Create userCreate user ' discuz ' @ ' localhost ' identified by ' discuz ';To change a user's access to a databaseGrant all on discuz.* to ' discuz ' @ '
Source: http://jingyan.baidu.com/article/8cdccae946133f315513cd6a.htmlRed part for me to addMySQL version 5.7 and above is different from the previous configuration, here to share with you experience.Tools/Materials
MySQL 5.7 and later zip
MySQL Connection query:Mysql connection queries support multiple table joinsYou can repeat multiple connections to the same table (aliases are important when you concatenate the same table multiple times)Example 1:Here are 2 sheetsTeams tableMatch
Error Description:Add user insert into Mysql.user (Host,user,password) VALUES ("localhost", "Test", Password ("1234"));Report the following error 1364 (HY000): Field ' ssl_cipher ' doesn ' t has a default value errormysql5.1 The above version, I was
MySQL three major column typesNumeric typeIntegral type: Tinyint1 of bytes 8 Digit bit Storage Range 0---2^8-(0--255)0000 0000 =01111 1111 =2^8-1=255The computer in order to indicate a number is negative, will be the highest bit ( left ) of the 0/1,
MySQL new features-mysql_config_editor source code analysisMysql has launched the encryption tool mysql_config_editor since mysql5.6. Previously, we put the account and password in plain text into my. cnf, so that you can log on to the database
A typical example of mysql connection Query,
Mysql connection query:
MysqlConnection query supports multi-Table connection
The same table can be connected multiple times (aliases are important when connecting the same table multiple times)
Example 1:
Introduction to clustered indexes of MySQL indexes,
In MySQL, what are the meanings and differences between clustered indexes and non-clustered indexes?
In MySQL, InnoDB Engine tables are (tered index organize tables, while MyISAM engine tables are
A brief tutorial on Sorting MySQL query results by value,
How can I sort MySQL query results? This is a question raised by many people. The following describes how to sort MySQL query results by a certain value. If you are interested, take a
The latest database for provinces, municipalities, and counties nationwide and databases for provinces and counties nationwide
The latest database for provinces, municipalities, and counties nationwide can be directly imported into the database.
MySQL replication and mysql Replication
Overview
This article mainly introduces the building process of mysql master-slave and some concepts involved in the middle, and hopes to provide the most comprehensive overview of the knowledge of mysql
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