Environment: MySQL Sever 5.1 + MySQL command line tool
First look at an example (the primary key is self-growing):
mysql> INSERT INTO BankAccount (name,balance) VALUES (' 123 ', 1000); Query OK, 1 row affected (0.06 sec) mysql> INSERT into
Environment
RedHat Linux 9 + vwware 8.0 + SSH 3.2.9 + Putty 0.62 + MySQL 3.2
Problem
MySQL Change Root password
Solve
mysqladmin-u user-p Password
password
User is username, password is new password
The command prompts you to enter the
One. Common MySQL command-line commands1. Start MySQL service net start MySQLStop MySQL service net stop MySQL2. Netstat–na | findstr 3306 View the port being monitored, findstr is used to find out if there is a port in the back3. Log in to the
There is a vulnerability when using replicate_do_db and replicate_ignore_db, and errors occur when you update across libraries.If you set replicate_do_db=test on Master (Master) server (set in my.conf)Use MySQL;Update Test.table1 Set ...Then the
Unzip the downloaded MySQL into the specified directory (e.g. D:\mysql)Installation ServicesAt the command line, enterD:\mysql\bin\mysqld-installnet start MySQLUninstall ServiceAt the command line, enternet stop MySQLD:\mysql\bin\mysqld-removeUnder
Connection query: A connection that records multiple tables (which can be more than 2 sheets) (data stitching according to a specified condition);The end result: the number of records is likely to change and the number of fields will increase (at
Here are some of the more important suggestions:1. Choose the right storage engineTake MySQL for example. Contains two storage engines MyISAM and InnoDB, each with its own pros and cons.MyISAM is suitable for applications that require a large number
CHAR is similar to a varchar type and is used to store strings, but they are saved and retrieved in different ways.Char is a fixed-length character type, and varchar is a variable-length character type.Mysql> CREATE TABLE VC (v VARCHAR (4), C CHAR (4
MySQL Login and logoutLogin MySQL: "Enter mysql-u account-p password which is loginMySQL exit: mysql > exit;Below is the example reference:Log in to MySQL: "Input mysql-uroot-p-p3306-h127.0.0.1"Indicates Superuser root, password is entered later,
First, table the benefits of indexing. On large datasets, the time consuming to query results without indexes is much greater than querying on the index. An index is like a directory of a book.An index is a special kind of file (an index on a InnoDB
Build the server. How do I import a database? Let's just get a user.Database name (already exists): TableCreate a new MySQL user and specify the database to allow remote accessMySQL User: TestMySQL User password: test666CREATE USER
1. Download the installation package "mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz" # Install dependent yum-y Install Perl perl-devel autoconf2. Move the downloaded installation package to/usr/local/. (Must, I originally installed in the home
1. Startnet start (stop) MySQLMysql-h Localhost-u Root-p2, the operation of the databaseCreate database name;show databases;Use database name; --Select database usingdrop database name; --Delete Database3, the operation of the data table1). CREATE
Binlog Introduction
Binlog, the binary log, which records all changes on the database.
At the end of the SQL statement that changes the database, a record is written at the end of the Binlog, and the statement parser is notified, and
MySQL binary log is often said to be the Bin-log, is the MySQL implementation of the changes produced by the binary logging file, its main role is two:* Data reply* Master-slave database. For the slave side to perform additions and deletions to
[[email protected] mysql]#/etc/init.d/mysqld startStarting MySQL. error! The server quit without updating PID file (/tmp/mysql.pid).[Email protected] mysql]# tail-f Data/host2.errInnoDB:Error:log file./ib_logfile0 is of different size 0 4194304
MySQL5.5 installation tutorial, mysql5.5 tutorial
1. Download mysql5.5 from the official website
:
Http://dev.mysql.com/downloads/mysql/5.5.html#downloads
2. Install mysql5.5
Note: disable anti-virus software before installation.
(1) Open the
How to upgrade Mysql5.6 to 5.7 Under Win, mysql5.65.7
Preface
MySQL can be upgraded in two ways: in-situ upgrade and logical upgrade. There is no essential difference between the two upgrade methods. There are some differences in the processing of
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