mysql download, install and configure 5.7.20 / 5.7.21 for your reference. The specific contents are as follows 1. Download mysql, download address Select the operating system and version. I am using 64-bit win10. After clicking Download, you will be redirected to the Oracle login page and asked to log in before downloading: Log in to download: 2. Unzip after downloading: 3. Create the my.ini file in the mysql directory, as shown above. The file content is as follows. Change basedir and datadir to the corresponding addresses: [mysql] # Set the default character set of the mysql client to default-character-set=utf8 [mysqld] #Set port 3306 port = 3306 # Set the installation directory of mysql basedir=D:/tools/ent/db/mysql-5.7.20-winx64 # Set the storage directory of mysql database data datadir=D:/tools/ent/db/mysql-5.7.20-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 4. Enter the bin directory with cmd and execute mysqld --initialize-insecure \mysql-5.7.20-winx64\bin>mysqld --initialize-insecure 5. Then execute mysqld -install mysql-5.7.20-winx64\bin>mysqld -install The prompt "Service successfully installed" indicates that the installation is successful. 6. Start the service D:\tools\ent\db\mysql-5.7.20-winx64\bin>net start mysql 7. Stop service D:\tools\ent\db\mysql-5.7.20-winx64\bin>net stop mysql 8. Log in to MySQL D:\tools\ent\db\mysql-5.7.20-winx64\bin>mysql -uroot -p Enter password: ****** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.7.20 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | |api| |ibase4j| | jpress | |mysql | | performance_schema | |srmhome| |sys| | wordpress | +--------------------+ 9 rows in set (0.00 sec) mysql> Finish! 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. You may also be interested in:
|
<<: How to configure user role permissions in Jenkins
>>: Detailed explanation of how to find the location of the nginx configuration file
But recently I found that using this method will c...
System environment: Ubuntu 16.04LTS This article ...
1. Style object The style object represents a sin...
For commercial databases, database upgrade is a h...
Table of contents 1. Filter unique values 2. Shor...
Usually, we first define the Dockerfile file, and...
Introduction Recently I found that there is an AR...
Everyone is familiar with the meta tag in desktop...
Here are 30 best practices for HTML beginners. 1....
1. To optimize the query, try to avoid full table...
Linux installation JDK1.8 steps 1. Check whether ...
Function: data display, table application scenari...
<br />Original text: http://andymao.com/andy...
Table of contents TOKEN Timer Refresher 2. Intern...
Original derivative command: bin/sqoop import -co...