16th MySQL Basic operation

1. Use the MySQL command line:A. Connect MySQL: Open mysql command line clientInput password, enterB. Creating a database, displaying a database, deleting a database, working with a databaseMysql> CREATE DATABASE pet;ERROR 1007 (HY000): Can ' t

MySQL Master-slave replication implementation process

first, what is the master-slave replicationThe DDL and DML operations in the primary database are transferred through the binary log (BINLOG) to the slave database, and then the logs are re-executed (redo) so that the data from the database is

CentOS MySQL upgrade after password reset

1. configuration file add filter password option#vim/etc/my.cnf    Skip password Check2. Restart MySQL Service#/etc/init.d/mysqld restart3, #mysql-uroot-p (direct return)Mysql>update user Set Authntication_string=password (' PASSWORD ') where user= "

Centos 6.5 installation MySQL Database

First, view and uninstall the original MySQLrpm-qa | grep mysql //This command will check if the MySQL database is already installed on the operating system.rpm-e MySQL //Normal Delete moderpm-e--nodeps MySQL //brute force Delete mode, if you use

How to connect to a database after Mysql.sock is lost

Security code: There is no degree of loneliness is impossible to have inner peace.PhenomenonThe Mysql.sock was deleted, which prevented the database from being connected.[[Email protected] ~] #mysql-uroot-penter password:error 2002 (HY000): Can ' t

Install MySQL in Ubuntu

The usual, ctrl+alt+t exhale terminal,Inputsudo apt-get updateUpdate the source, or run the following code will be reported that a few packages can not be downloaded, you still have to come back to execute this code,Inputsudo apt-get install

Install MySQL with one click

Install Mysql with one click#!/bin/bash##### no1. Installation Preparation  ###. /etc/init.d/functionsyum -y install libaio*mkdir  -p /application/tar xvf /tmp/tools/mysql-5.5.32-linux2.6-x86_64.tar.gz -c /

MySQL parameter optimization

[Client]Port = 3306Socket =/tmp/mysql.sock[Mysqld]Port = 3306Socket =/tmp/mysql.sockBasedir =/usr/local/mysqlDataDir =/data/mysqlPid-file =/data/mysql/mysql.piduser = MySQLBind-address = 0.0.0.0Server-id = 1 #表示是本机的序号为1, which is generally the

MySQL database master-slave synchronous replication principle

MySQL replication (English for replication) is a multi-MySQL database master from the synchronous scheme, characterized by asynchronous replication, widely used in a variety of MySQL have higher performance, higher reliability requirements of the

MySQL Security Configuration Wizard mysql_secure_installation detailed

After installing Mysql-server, you will be prompted to run mysql_secure_installation. Running Mysql_secure_installation will perform several settings:A) set a password for the root userb) Delete Anonymous accountc) Remove the root user from remote

MySQL Reset root password

1.KILL off the MySQL process in the system;Killall-term mysqld2. Start MySQL with the following command to start without checking permissions;Mysqld--skip-grant-tables &3. Then log in to MySQL using the root user with a blank password;Mysql-u Root4.

How to install MySQL 5.7 on CentOS 7.3

mkdir -p /home/toolscd /home/toolsyum -y install numactl libaiowget  http://god.nongdingbang.net/downloads/mysql-5.7-el7.tgz && tar zxvf  Mysql-5.7-el7.tgzrpm -uvh *rpmmkdir -p /data/{mysql_data,mysql_log,mysql_slow,mysql_undo} chown -r mysql.mysql /

MySQL log vs. backup restore

First, error logWhen a database fails to work, the first time to view the log1, the server starts the shutdown process information2. Error messages during server operationLog storage path, which can be viewed by command:Log file naming format:

Some SQL statements for MySQL

SELECT hou.*,uname from Hos_house as HouINNER JOIN Sys_user as usrINNER JOIN Hos_type as HtyOn Hou.uid=usr.uidAnd Hty.htname= ' three rooms and one hall 'and Hou.htid=hty.htidand Hou.sid in(SELECT SID from Hos_street as street INNER joins

CentOS 7 Installation MySQL

First, install MySQL1. Download MySQL installation package https://dev.mysql.com/downloads/I downloaded the Mysql-5.6.36-1.linux_glibc2.5.x86_64.rpm-bundle.tar.2. Pass the installation package to any directory on Linux3. Unzip the installation

MySQL InnoDB Insert Intent Lock

There is an insert intent lock in the InnoDB. Specifically for insert, assuming that the gap has been locked by gap before insertion, insert will request an intent lock.So what is the purpose of this insert intent lock?1, in order to arouse waiting.

Operations such as subqueries in MySQL

1.delete and truncate difference?1.1 Delete slow, truncate fast1.20delete logging, so slow truncate does not log1.31 when all records are deleted, the primary key value Delete is not numbered from 1, and truncate is numbered from 1 onwards1.43

MySQL Build report TIMESTAMPN error:invalid default value for ' timestamp '

Environment: MySQL 5.7.16System: CentOS 6.8 64Baidu query to, because is the version of the problem caused.Solution:1. Open the/ETC/MY.CNF configuration fileAdd the following at the end: explicit_defaults_for_timestamp = True Sql_mode=strict_trans_

Reset the root password for mysql and set the root password for mysql.

Reset the root password for mysql and set the root password for mysql. 1. KILL the MySQL process in the system;Killall-TERM mysqld 2. Run the following command to start MySQL without checking its permissions;Mysqld -- skip-grant-tables & 3. Use

Mysql logbin Data Log Recovery database, mysqllogbin

Mysql logbin Data Log Recovery database, mysqllogbin ========================================================== ==================== BINLOG export SQL File========================================================== ==================== C: \ Program

Total Pages: 3233 1 .... 2212 2213 2214 2215 2216 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.