Shulou(Shulou.com)06/01 Report--

Overview of MySQL

MySQL is a relational database management system, and a database is a structured data collection. Originally developed by MySQL AB, Sweden, it now belongs to Oracle. MySQL is an associated database management system that stores data in different tables instead of all data in a large warehouse, which increases speed and flexibility.

MySQL characteristics

Written in C and C++, and tested with a variety of compilers to ensure the portability of the source code.

Support Windows, Mac OS, AIX, BSDI, LInux and other operating systems.

Provides API for a variety of programming languages. Such as C, C++, C #, PHP, JAVA, Python, Ruby and so on.

Support multithreading, make full use of CPU resources, support multi-users.

The optimized SQL query algorithm can effectively improve the query speed.

It can not only be used as a separate application in the client and server network environment, but also can be embedded in other software as a library.

Provides multilingual support. Such as GB2312, BIG5, UTF-8 and so on.

Provide a variety of database connections such as TCP/IP, ODB and JDBC.

Provides management tools for managing, checking, and optimizing database operations.

It can handle large databases with tens of millions of records.

All right, don't talk too much nonsense, let me start my Mysql learning journey now.

MySQL installation (Windows x64)

The first step is to download the MySQL database and choose the ZIP Archive version (simple, clean, installation-free) that suits the bits of your system to download.

The second step is to extract the ZIP Archive version that you just downloaded and find the place where you want to install it. Here is a C: disk as an example. After decompression, ok is simple, isn't it? You know the benefits of the ZIP Archive version, heh heh.

The third step, configure the default file, because the direct use of the default configuration, there will be a lot of problems, such as garbled text, so you need to modify the configuration file. First, under the directory C:\ mysql-x.x.xx-winx64 (take version 5.6.24 here as an example), create a new my.ini file (.ini is the configuration file for the Windows system), and if the configuration file is wrong, you will give an error message of 1067. Copy the following code to save in the new configuration file.

[mysqld] # set port 3306 port = 3306 # set mysql installation directory basedir=D:\ mysql\ mysql-5.6.17-winx64# set mysql database data storage directory datadir=D:\ mysql\ mysql-5.6.17-winx64\ data# allow the maximum number of connections the character set used by the max_connections=200# server defaults to 8-bit coded latin1 character set character-set-server=utf8# the default storage engine default-storage-engine=INNODB to use when creating new tables

Step 4, install the mysql service, start-- > cmd (enter in the search program or file input box), then press enter, right-click on the cmd.exe file that appears, select run as administrator (to ensure sufficient permissions), change the directory to the bin directory of mysql (such as enter: cd C:\ mysql-5.6.24-winx64\ bin enter), enter mysqld install enter, if the prompt is successful It indicates that the installation was successful. The next step is to start the mysql service. There are many ways to start the service. The first method is to right-click on the computer icon-- > Management-- > Services and applications-- > Services, find the mysql service, and click start. The second method is relatively fast and is commonly used by most people. Enter the net start mysql command in the cmd window you just ran, and then press enter to start the service.

The fifth step, start mysql, which is also an exciting step, hey, or in cmd will change the directory to the bin directory, enter mysql-uroot-p enter the password (the default is no password), you can mysqladmin through the command mysqladmin-uroot-p password to set the password, if you want to exit, enter exit enter (Note: directly close the cmd window can not exit, you must exit through the exit command).

Step 6, configure environment variables (optional), right-click the computer-- > Properties-- > Advanced system Settings-- > Environment variables-- > path-- > Edit, and add C:\ mysql-x.x.xx-winx64\ bin; before it (Note: it must end with a semicolon, and x.x.xx represents your version of mysql). The purpose of configuring the environment variable is that you don't have to change the directory to the bin directory every time you start mysql. After configuring the environment variables, let's run mysql,cmd-- > mysql-uroot-p-- > enter the password; at this point, you can create tables, look up tables, and so on.

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.