First knowledge of MySQL

MySQL Advantage

MySQL is a free software. Anyone can download the software from the official MySQL website. MySQL is a true multi-user, multi-threaded SQL database server. It is implemented in the client server architecture and is comprised of a server daemon mysqld and a number of different client programs and libraries. It can handle large amounts of data quickly, efficiently and securely, and MySQL is very simple to use compared to Oracle databases. MySQL's main goal is fast, easy and easy to use.

Features of MySQL

MySQL is a true multi-user, multi-threaded SQL database server. SQL (Structured Query language) is the most popular and standardized database language in the world.

• Written in C and C + +, and used a variety of compilers to test, to ensure the portability of the source code.
• Supports various operating systems such as AIX, FreeBSD, HP-UX, Linux, Mac, OS, Novell Netware, OpenBSD, OS/2, Wrap, Solaris, Windows, and more.
• Provides APIs for multiple programming languages. These programming languages include C, C + +, Python, Java, Perl, PHP, Eiffel, Ruby, and Tcl.
• Support multithreading, make full use of CPU resources.
• Optimized SQL query algorithm to improve query speed effectively.
• Can be used as a separate application in the Client Server network network environment, but also can be embedded in other software as a library to provide multi-language support, common encoding such as Chinese gb2312, BIG5, Japanese shift_jis and so on are used as the data table name and data column name.
• Provide TCP/IP, ODBC, JDBC and many other database connection paths.
• Provides management tools for checking, managing, and optimizing database operations.
• Can handle tens of millions of large databases

The latest version is MySQL5.5, which provides a set of dedicated features in today's modern, multi-functional processing hardware and software, and middleware architectures emerging environments.

Greatly improves MySQL performance, scalability, usability.

MySQL5.5 combines the benefits of MySQL database and InnoDB storage engine to deliver high-performance data management solutions.

• InnoDB as the default database storage engine.
• Improves system performance and scalability under Windows systems.
• Improve performance and scalability to take full advantage of the computing power of modern, multi-core architectures across platforms.
• Improve usability.
• Improve ease of management and efficiency.
• Increase availability
• Improved performance for detection and diagnosis

Currently the most popular site is structured by lamp (linux+apache+mysql+php). These four software are open source software (FLOSS), so use this way can not spend a penny to build a stable free website system.

MySQL's management software

Command line management (MySQL and mysqladmin), graphical management tools: Mysqladministrator, MySQL Query browser, and MySQL Workbench.

phpMyAdmin is written by PHP to create and manage MySQL repositories from the Web interface.

Phpmybackuppro, written by PHP, can create and manage a MySQL database through a web interface that can create pseudo-cronjobs that can be used to automatically back up MySQL databases at a certain time or cycle.

Other GUI management tools such as Mysql-front, NAVICAT, etc.

MySQL Download

: https://dev.mysql.com/downloads/windows/installer/

MySQL server start-up connection, disconnect, and stop

1. Stop the MySQL server by starting the system server

My Computer--right-click Management Services, and then find the MySQL service (start, restart, stop, resume, pause) in the list of services.

2. Start and stop the MySQL server from the command prompt

Start-to-run, enter the "cmd" command to enter the DOS window

\>net start MySQL

cause : Not a system administrator

Solution: Law One

Create a shortcut to the desktop

　　

　　

　　Act Two : run Cmd.exe directly with the administrator

Problem solving go to the chase

　　Start and stop of the doc server

　　Start the service

　　

　　Stop Service

　　

3. Connect to MySQL server

mysql-uroot-h127.0.0.1-p123456

User name (-u): Root server address (-h) 127.0.0.1 password (-p): 123456

　　

If the prompt is not an internal or external command, it is not a program that can run, or a batch file, in the system

4. Disconnect the MySQL connection

Quit or exit

　　

First knowledge of MySQL