Tutorial on downloading, installing, configuring and using MySQL under Windows

Overview of MySQL

MySQL is a relational database management system. A database is a structured collection of data. Originally developed by Swedish MySQL AB, it is now owned by Oracle. MySQL is a relational database management system that stores data in different tables instead of putting all data in one large warehouse, which increases speed and flexibility.

MySQL Features

Written in C and C++ and tested with multiple compilers to ensure source code portability.
Supports multiple operating systems including Windows, Mac OS, AIX, BSDI, LInux, etc.
APIs are provided for multiple programming languages. Such as C, C++, C#, PHP, JAVA, Python, Ruby, etc.
Support multi-threading, make full use of CPU resources, and support multiple users.
Optimized SQL query algorithm effectively improves query speed.
It can be used as a separate application in the client and server network environment, and can also be embedded in other software as a library.
Provides multi-language support. Such as GB2312, BIG5, UTF-8, etc.
Provides multiple database connection methods such as TCP/IP, ODB and JDBC.
Provides management tools for managing, inspecting, and optimizing database operations.
Can handle large databases with tens of millions of records.

Okay, without further ado, let me start my MySQL learning journey now.

MySQL Installation (Windows x64)

The first step is to download the MySQL database and select the ZIP Archive version (simple, clean, and installation-free) that is suitable for your system bit size.

The second step is to unzip the ZIP Archive version you just downloaded and find the location where you want to install it. Here we take the C: drive as an example. Once you have unzipped it, everything is done. It’s very simple, right? Now you know the benefits of the ZIP Archive version, hehe.

The third step is to configure the default file. If the default configuration is used directly, many problems will occur, such as garbled text, so the configuration file needs to be modified. First, create a my.ini file (.ini is a configuration file for the Windows system) in the directory C:\mysql-xxxx-winx64 (version 5.6.24 is used as an example here). If the configuration file is incorrect, an error message 1067 will be given. Copy the following code into the newly created configuration file and save it.

[mysqld]
#Set port 3306 port = 3306 
# Set the installation directory of mysql basedir=D:\mysql\mysql-5.6.17-winx64
# Set the storage directory of mysql database data datadir=D:\mysql\mysql-5.6.17-winx64\data
# Maximum number of connections allowed max_connections=200
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB

The fourth step is to 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 that you have sufficient permissions), switch the directory to the MySQL bin directory (for example, enter: cd C:\mysql-5.6.24-winx64\bin and press Enter), enter mysqld install and 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 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 to start. The second method is faster and is also the method most people use. Simply enter the net start mysql command in the cmd window that was just run, and then press Enter to start the service.

The fifth step is to start mysql. This is also an exciting step. Hehe, switch the directory to the bin directory in cmd, enter mysql -uroot -p and press Enter, enter the password (there is no password by default), and you can set the password through the command mysqladmin -u root -p password. If you want to exit, enter exit and press Enter (Note: you cannot exit by directly closing the cmd window, 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-xxxx-winx64\bin; in the front (Note: it must end with a semicolon, xxxx represents your MySQL version). The purpose of configuring environment variables is to avoid switching the directory to the bin directory every time you start MySQL. After configuring the environment variables, let's run mysql, cmd-->mysql -uroot -p --> press Enter to enter the password; now you can create tables, query tables, and perform other operations.

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.