Download, install, configure, and use MySQL in Windows

Download, install, configure, and use MySQL in Windows

MySQL Overview

MySQL is a relational database management system, and a database is a structured data set. It was initially developed by MySQL AB in Sweden and now belongs to Oracle. MySQL is an associated database management system that stores data in different tables rather than in a large warehouse. This increases the speed and flexibility.

MySQL features

It is written in C and C ++ and tested using multiple compilers to ensure source code portability.
Supports Windows, Mac OS, AIX, BSDI, LInux, and other operating systems.
Provides APIs for multiple programming languages. Such as C, C ++, C #, PHP, JAVA, Python, and Ruby.
Supports multithreading, making full use of CPU resources, and supporting multiple users.
The optimized SQL query algorithm effectively improves the query speed.
It can be used as a separate application in the client or server network environment, and can also be embedded into other software as a library.
Supports multiple languages. Such as GB2312, BIG5, UTF-8 and so on.
Provides TCP/IP, ODB, JDBC, and other database connection methods.
Provides management tools for managing, checking, and optimizing database operations.
It can process large databases with tens of millions of records.

Well, I don't need to talk much about it. Let me start my Mysql learning journey now.

Install MySQL (Windows x64)

Step 1To download the MySQL database, select a ZIP Archive version (simple, clean, and installation-free) that is suitable for downloading your system.

Step 2Decompress the downloaded ZIP Archive version and find the place you want to install. Here, a C: disk is used as an example. After decompression, it will be OK. Is it easy? I know the benefits of ZIP Archive.

Step 3The default configuration file. If you use the default configuration directly, many problems may occur, such as text garbled characters. Therefore, you need to modify the configuration file. Create a new my. INI file (. ini is the configuration file of Windows. If the configuration file is incorrect, A 1067 error message is displayed. Copy the following code to the new configuration file and save it.

[Mysqld] # Set port 3306 port = 3306 # Set mysql installation directory basedir = D: \ mysql \ mysql-5.6.17-winx64 # Set the mysql database data storage directory datadir = D: \ mysql \ mysql-5.6.17-winx64 \ data # maximum number of connections allowed max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character set character-set-server = utf8 # default storage engine default-storage-engine = INNODB

Step 4, Mysql service installation, start --> login (enter a keyword in the search program or file input box, then go back, right-click the current cmd.exe file, select Run as Administrator (to ensure sufficient permissions), switch the directory to the mysql bin directory (such as input: cd C: \ mysql-5.6.24-winx64 \ bin press Enter), enter mysqld install press enter, if the prompt is successful, it means the installation is successful. The next step is to start the mysql service. There are many methods to start the service. The first method is to right-click the computer icon and choose manage> services and applications> services, find the mysql service and click Start. The second method is quick, which is also commonly used by most people. directly enter the net start mysql command in the cmd window just run, and press enter to start the service.

Step 5It is also an exciting step to start mysql. Hey hey, switch the directory to the bin directory in cmd and enter mysql-uroot-p and press Enter, enter the password (no password by default). You can run the mysqladmin-u root-p password command to set the password. If you want to exit, enter exit and press enter (note: close the cmd window directly. You must exit with the exit command ).

Step 6, Configure environment variables (optional), right-click the computer --> properties --> advanced system settings --> environment variables --> path --> edit, add C: \ mysql-x.x.xx-winx64 \ bin in front; (Note: it must end with a semicolon, x. x. xx represents your mysql version ). You do not need to switch the directory to the bin directory every time you start mysql. After the environment variables are configured, let's run mysql, cmd --> mysql-uroot-p --> press enter to enter the password. Then you can create a table and look up the table.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.