Course Outline:Section 1th MySQL Source compilation installation (centos-6.6+mysql-5.6) 38 minutes2nd MySQL configuration for master-slave replication (centos-6.6+mysql-5.6) 58 minutessection 3rd mycat read-write separation on MySQL master-slave
MySQL cannot be remotely linked by default after installation:CMD View all port conditions: Netstat-anoTo view the specified port condition: netstat-aon|findstr "3306"Modify local account to%:Update user set host= '% ' where host= ' 127.0.0.1
First view MySQL related directory under Linux[Email protected]:~# whereis MySQLMysql:/usr/bin/mysql----MySQL Run path/etc/mysql/usr/lib/mysql-----MySQL Installation path/usr/bin/x11/mysql/usr/share/mysql/usr/share/man/man1/mysql.1.gzIn addition,
An introductionConstraints are the same as the width of the data type, which are optional parametersRole: To ensure the integrity and consistency of dataMainly divided into:PRIMARY Key (PK) identifies the field as the primary key of the table and
1. Turn on MySQL service2. Detect if the port is running3. Set a password or change the password for MySQL.4. Log in to the MySQL database.5. View the character set of the current database6. View the current database version7. View the currently
Official documents:Https://dev.mysql.com/doc/refman/5.7/en/explain-output.html#explain_rowsType: Connection type the system table has only a single row of const tables with a maximum of one row of matches, common for primary key or unique index
To manipulate commands in the Ubuntu system:Login: Mysql-uroot-pStart: Service MySQL StartSTOP: Service MySQL stopRestart: Service MySQL restartCreating database: Create database name charset = UTF8;Delete databases: drop database name;View all
install MySQL under Linux1 Check and uninstall the installed MySQLcommand:rpm-qa|grep-i MySQLcommand:rpm-e--nodeps ' Last command shows the native installed MySQL dependency 'If there are already installed, then each dependency that appears after
Grant all on * * to ' user1 ' identified by ' passwd 'Grant Select,update,insert on db1.* to ' user2 ' @ ' 192.168.133.1 ' identified by ' passwd ';Grant all on db1.* to ' user3 ' @ '% ' of ' identified by ' passwd ';Show grants;Show grants for
[Email protected] ~ for"systemctl status mysqld.service"" Journalctl-xe " for details.Use Systemctl status to view the status:[[Email protected] ~]# systemctl status MySQL mysqld.service-Lsb:start and Stop MySQL loaded:loaded
After installing MySQL with sudo apt-get install mysql-server mysql-common a command on Ubuntu, you are not prompted to enter a password during installation. Then use mysql -u root -p to log in, and then asked to enter the password, but no
First, create a userCommand:CREATE USER ' username '@'host'by'password';Description
Username: The user name you will create
Host: Specifies on which host the user can log on, if localhost is available to the local user, if you want the
You can use limit to limit the number of queries in MYSQL/MARIADB. Examples are as follows:1.limit after adding a parameter limit N:// Check the top two records in the query for all results and return Select from 2 ; +------+---------+------+| Id_o
Unzip a file into a directoryThis is the unpacked directory.Take the My.ini file in.Double hit Open My.iniFind these two lines to change to your own decompression path to saveRight-click this computer's propertiesLocate the Advanced system settings
1 MySQL User managementFor internet companies, we know that data is a non-renewable resource, and when important data is lost, it can be costly. The security of the database is very important, so for the background administrator's permissions to
Show variables like "char%"; You can see the database encoding, some defaults to Latin; (status; Can also be viewed, some different)--Add the following to the [Mysqld] tab:Default-character-set = UTF8Character_set_server = UTF8Note: If something
--The length of the stringSELECT Length (' abc '), Length (' My home ');SELECT char_length (' abc '), Char_length (' my Home ');--Merging stringsSELECT CONCAT (' A ', ' B ', ' C '), Concat_ws (', ', ' A ', ' B ', ' C '), CONCAT (null, ' a '), Concat_
--Pinyin returns the entire character string with all initial lettersBEGINDECLARE v_compare VARCHAR (255);DECLARE V_return VARCHAR (255);DECLARE I INT;SET I = 1;SET V_return = ';While I SET V_compare = SUBSTR (P_name, I, 1);IF (V_compare! = ")
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