Many friends have installed MySQL but do not know how to use it. In this article we will learn some common MySQL commands by connecting MySQL, modifying passwords, and adding users.
first, connect MySQL。
Format:
Mysql-h Host Address
-U user Name
-P
Problem analysis
In the Shutdown database command found that MySQL can not be closed, the hint Warning: World-writable config file '/etc/my.cnf' is ignored , probably means that the permissions of the global writable, any user could write. MySQL
Recall MySQL 5.5 installation configuration method, organize the MySQL 5.5 installation configuration tutorial notes, share to everyone.
MySQL Download address: http://dev.mysql.com/downloads/installer/
1, the first entry is the installation of
1. Use MySQL's own database synchronization function (the following reference from the online article, wrote a very detailed)
MySQL provides database replication functionality after version 3.23.15. The function of two database synchronization,
MySQL's default encoding is Latin1, does not support Chinese, to support the noon need to change the database's default encoding to GBK or UTF8.
1, need to log in as root user can view the database encoding (as root user login command: >mysql-u
Mac under the MySQL database Chinese garbled solution:
When we use the framework for database storage operations, we often encounter the problem of garbled Chinese.
For example, when using the SSH framework in Java, we need to configure the
Detailed instructions on how to access the MySQL Guide with an ODBC interface
MySQL's ODBC interface implementation is through the installation of MYODBC driver, this driver is cross-platform. If used under UNIX systems such as Linux, you need to
This tutorial by the It square Information Network www.ithov.com original release, reprint please indicate the source
The relevant software used in this installation is as follows:
Operating system: Windows 2003 Enterprise Edition
MySQL through the trigger to achieve the synchronization of two tables, need to understand the friend can look.
There are two tables A and b that require inserting a record into a and inserting a record into B, inserting a record into B and
About MySQL collation of the need for memory and proficiency in the content
1./* View Operation * *---------------------------------------------------------------------------------------------------- ---1. /* View Operation * *
Show
Database optimization has a lot to say, according to the amount of data can be divided into two stages: stand-alone database and sub-Library, the former can support 500W or 10G of data, more than this value will need to consider the Sub-Library
First, MySQL get the current field maximum ID
SQL statement:
Select Max (id) from yourtable;
Second, obtain the MySQL table self-increase (auto_increment) value
Auto_incrementis a property in a table that can be obtained by taking the
However, please note that the following optimizations are not complete. MySQL has implemented many optimizations, but I don't have time to test them all.
Some of the optimizations for MySQL are listed below:
To remove unnecessary parentheses:
((A
A simple bash script was written in the afternoon to test the program, enter a test case file, output the use cases and results that did not pass the test, and then save the results to the database. How do I directly access a database in a bash
Information error information is as follows:
Attempt to establish a database named Test7i24 password 123456: The command was executed successfully. Command successfully executed. An error occurred in the operation, and the relevant information is:
MySQL escape character "\"
Mfc_basic
MySQL recognizes the following escape characters:
The
An ASCII 0 (NUL) character.
\ n
A new line character.
\ t
A locator character. System character separation
\ r
A carriage return character.
\b
A backspace.
\'
The workaround is as follows:
1, first remove the MySQL service
Control Panel-> management tools-> Service, stop MySQL service first
Start-> run-> enter CMD->SC delete MySQL
Service deletion
2. Modify My.iniIf it is not created (the following
Environment: Windwos (1511) 64bit, MySQL 5.7.14
First, download MySQL
1. Open the MySQL website in the browser http://www.mysql.com/
2. Go to the top of the page "Downloads"
3. Open "Community (GPL) Downloads" at the bottom of the page
4.
First, the blog prefaceSince the contact learning MySQL for some time, the basic knowledge of MySQL still have a certain understanding. In this way to learn, every time whether reading books or on-line data, for the MySQL data type of time and date
Marking:Linux needs to first configure the network Yum source, to determine that Yum can install the software package online to facilitate the installation of some dependent packages during the test. Configure the 163 netease hints Network Yum
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