mysql 5.7.11 winx64.zip installation and configuration method graphic tutorial
|
Install and configure the MySql database system. 1. Download http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.11-winx64.zip 2. Unzip the zip file D:\Program Files\mysql-5.7.11-winx64 3. Configure environment variables 3.1 Add path path, D:\Program Files\mysql-5.7.11-winx64\bin 3.2. Modify the mysql-default.ini configuration file, Original # These are commonly set, remove the # and set as required. # basedir = ..... # datadir = ..... # port = ..... # server_id = ..... Change to # These are commonly set, remove the # and set as required. basedir = D:\Program Files\mysql-5.7.11-winx64 datadir = D:\Program Files\mysql-5.7.11-winx64\Data port = 3306 # server_id = ..... 4. Enter the command prompt cmd as an administrator Enter the bin directory of mysql, Microsoft Windows [Version 6.3.9600] (c) 2013 Microsoft Corporation. All rights reserved. C:\Users\Administrator>cd D: D:\ C:\Users\Administrator>cd D:\Program Files\mysql-5.7.11-winx64\bin C:\Users\Administrator>d: D:\Program Files\mysql-5.7.11-winx64\bin> Execute the mysqld.exe --initialize command. D:\Program Files\mysql-5.7.11-winx64\bin>mysqld.exe --initialize D:\Program Files\mysql-5.7.11-winx64\bin> Created the data directory
5. Execute the mysqld -install command D:\Program Files\mysql-5.7.11-winx64\bin>mysqld -install Service successfully installed. //Service successfully installed 6. Execute mysqld.exe -nt --skip-grant-tables Note: The window is unresponsive Microsoft Windows [Version 6.3.9600] (c) 2013 Microsoft Corporation. All rights reserved. C:\Users\Administrator>cd D: D:\ C:\Users\Administrator>cd D:\Program Files\mysql-5.7.11-winx64\bin C:\Users\Administrator>d: D:\Program Files\mysql-5.7.11-winx64\bin>mysqld.exe --initialize D:\Program Files\mysql-5.7.11-winx64\bin>mysqld -install Service successfully installed. //Service successfully installed. D:\Program Files\mysql-5.7.11-winx64\bin>mysqld.exe -nt --skip-grant-tables 7. Reopen the DOS window and execute mysql -u root Enter the MySQL command line and execute the command use mysql; update user set authtication_string=Password('123456') where user="root"; set password=Password('123456'); Press Ctrl+C to copy the code
Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.
C:\Users\Administrator>mysqld.exe -nt --skip-grant-tables
C:\Users\Administrator>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.11 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, 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> use mysql
Database changed
mysql> update user set authtication_string=Password('123456') where user="root"
-> set password=Password('123456')
->
Press Ctrl+C to copy the code 8. Terminate the mysqld process in the Task Manager and start the mysql service. The installation is complete. Wonderful topic sharing: Installation tutorials for different versions of MySQL Installation tutorials for MySQL 5.7 versions Installation tutorials for MySQL 5.6 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. You may also be interested in:
|
<<: IIS 7.5 uses URL Rewrite module to achieve web page redirection
>>: js implements a simple countdown
![Detailed explanation of the basic usage of MySQL triggers [create, view, delete, etc.]](/upload/images/67cad55e47ecc.webp)
Recommend
MySQL optimization tips: analysis of duplicate removal implementation methods [millions of data]
This article uses an example to illustrate how to...
Nginx builds rtmp live server implementation code
1. Create a new rtmp directory in the nginx sourc...
The correspondence between Tomcat and JDK versions and the features of each Tomcat version
Apache Tomcat is an open source software that imp...
Detailed explanation of common template commands in docker-compose.yml files
Note: When writing the docker-compose.yml file, a...
Centos6.5 glibc upgrade process introduction
Table of contents Scenario Requirements glibc ver...
CentOS 7.x docker uses overlay2 storage method
Edit /etc/docker/daemon.json and add the followin...
Use of MySQL triggers
Triggers can cause other SQL code to run before o...
How to implement Hover drop-down menu with CSS
As usual, today I will talk about a very practica...
CSS3 transition to achieve underline example code
This article introduces the sample code of CSS3 t...
Detailed explanation of how to pass password to ssh/scp command in bash script
Install SSHPASS For most recent operating systems...
React implementation example using Amap (react-amap)
The PC version of React was refactored to use Ama...
Use tomcat to deploy SpringBoot war package in centos environment
Prepare war package 1. Prepare the existing Sprin...
Solution to MySQL being unable to start due to excessive memory configuration
Problem Description MySQL reports an error when s...
Detailed explanation of how to query fields containing '%' in MySQL like (ESCAPE usage)
In the SQL like statement, for example SELECT * F...
Mysql 5.7.18 Using MySQL proxies_priv to implement similar user group management
Use MySQL proxies_priv (simulated role) to implem...