MySQL Learning notes (i)

MySQL System Features System Features

1, the use of C and C + + written, and use a variety of compilers to test, to ensure the portability of the source code.

2. Support for AIX, FreeBSD, HP-UX, Linux, Mac OS, Novellnetware, OpenBSD, Os/2 Wrap, Solaris, Windows and many other operating systems.

3. Provides APIs for a variety of programming languages. These programming languages include C, C + +, Python, Java, Perl, PHP, Eiffel, and Ruby. NET, Tcl and so on.

4, support multi-threading, make full use of CPU resources.

5, optimized SQL query algorithm, effectively improve the query speed.

6, can be used as a separate application in the Client server network environment, but also as a library and embedded in other software.

7, provide multi-language support, common encoding such as Chinese GB 2312, BIG5, Japanese shift_jis, etc. can be used as data table name and data column name.

8, provide TCP/IP, ODBC and JDBC and many other database connection channels.

9. Provide management tools for managing, inspecting and optimizing database operations.

10, support large-scale database. You can handle large databases that have thousands records.

11. Support multiple storage engines.

12, MySQL is open source, so you do not have to pay an additional fee.

13. MySQL uses the standard SQL data language form.

14, MySQL has a good support for PHP, PHP is currently the most popular Web development language.

15, MySQL can be customized, using the GPL protocol, you can modify the source code to develop their own MySQL system.

16. Online ddl/change function, data architecture supports dynamic application and developer flexibility (5.6 new)

17, replication global transaction identity, can support self-healing cluster (5.6 new)

18, replication no crash slave, can improve availability (5.6 new)

19, replication multi-threaded slave, can improve performance (5.6 new)

20, 3 times times faster performance (5.7 new)

21. New Optimizer (5.7 new)

22. Native JSON support (5.7 new)

23. Multi-source replication (5.7 new)

24. Spatial expansion of GIS (5.7 new)

1.1. Set up MySQL remote access

- - - -P

Host name (IP address) where the Hostname:mysql server resides
Port number of the PORT:MSYQL server (3306)
Username: User Name
P: User Password

2.2 Modify MySQL user password

1. Mysqladmin command

The format is as follows (where user is the username and password is the new password):

- USER -p password Password

After this command, you will be prompted to enter your original password, and you can modify it after entering it correctly.
For example, to set the root user's password to 123456, the

- - 123456

2. UPDATE User Statement

This must be done first by logging in to MySQL with the root account and then executing:

MySQL Learning note (i)