MySql installation and use graphic tutorials [recommended], mysql installation graphic tutorials

MySql installation and use graphic tutorials [recommended], mysql installation graphic tutorials

MySQL is a relational database management system developed by MySQL AB in Sweden and currently 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. The SQL language used by MySQL is the most common standard language for accessing databases. MySQL adopts the dual Authorization Policy (this term "Authorization Policy"). It is divided into community edition and commercial edition. because of its small size, fast speed, and low total cost of ownership, especially open source code, MySQL is generally used as the website database for the development of small and medium-sized websites. Due to its superior performance, the Community edition works with PHP and Apache to form a good development environment.

Because the MySql database is used in the graduation project today, you have to Install a MySQL database by yourself. However, because MySQL Install MSI only has 32 bits, you finally choose to use Windows (x86, 64-bit ), install and use the ZIP Archive version.

The following describes how to install MySQL for your reference only.

1. For good work, you must first sharpen the tool.So the first step is to go to http://dev.mysql.com/downloads/mysql/download windows (x86, 64-bit), ZIP Archive,

2. decompress the downloaded package to the path you want to install., For example, I decompress to D: \ MySql \ mysql-5.7.12-winx64 \ path, just decompress should be these folders:

3. This step begins the configuration.If your file suffix name is not displayed, we recommend that you set your own file suffix display, because we need to use: to set the file suffix display steps: in win7, double-click "computer" --> click "Organization" under the navigation bar --> select "folder and search selection items" --> click "View" --> hide "Known File Types deselect the "extension" check box.

4 .. ------>

5. Create a New my. ini configuration file, This configuration file will overwrite the my-default.ini file under the current folder, and the previous step sets the display file suffix to be prepared for this step, open this configuration file, add the following code to the file:

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 to port 3306 # set the mysql installation directory basedir = D: \ MySql \ mysql-5.7.12-winx64 # Set the mysql database data storage directory datadir = D: \ MySql \ mysql-5.7.12-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

• Save the files after they are added, and create an empty data folder in this path. The entire process should be completed in the following format:

1.The previous period has been completed, and the installation service is started later. Run cmd.exe with the administrator ID. Remember to run cmd.exe as an administrator and enter the installed bin directory. The most important and important command is here, which is necessary. Otherwise, the service cannot be started after the installation, enter the mysqld -- initialize-insecure -- user = mysql Command, and press Enter,

2.

3. Enter mysqld install to install the service. If the installation is successful, a prompt is displayed, indicating that the installation is successful. If the MySQL service is started, the installation is OK,

4.

5. configure the environment variable --> right-click on the computer "properties" --> "Advanced System settings" --> "environment variable" --> "path" --> copy the path of the bin directory to the path environment variable, it is best to copy it to the beginning and add a semicolon to the end.

6.

7.open mysql, cmd.exe, and enter the mysql-uroot-p command. By default, there is no password. Press enter to enter. If you have already set a password, you must enter it. If you have a password, you can use mysql-uroot-p or mysql-uroot-p to press enter to enter the password. The second type is recommended.

8.

The installation and use of mysql has been completed. Sorry for the poor writing. You are welcome to give more criticism and suggestions to learn and make progress together.