mysql5.6.x non-online installation version (decompression version) installation process

First, uninstall the previous old version (I 5.5 version)

1. Turn off MySQL service

Run cmd as an administrator and execute the following command:
net stop MySQL

or right-click My Computer, in management--services--stop MySQL

2. Uninstall MySQL Application

Mysqld-remove [Service Name]
The service name can be found in the right click on my Computer, in admin--services--right clicking on MySQL View properties:

3. Delete MySQL files
The following will delete the local MySQL file, the path can be found through the path of the executable file under the service name.

4. Delete Registry information

Start-up run-to-regedit look at the registration table in these few places delete no

Hkey_local_machine\system\controlset001\services\eventlog\application\mysql Directory Removal HKEY_LOCAL_MACHINE\SYSTEM\ Controlset002\services\eventlog\application\mysql Directory Removal hkey_local_machine\system\currentcontrolset\services\ Eventlog\application\mysql Directory Removal

The ControlSet001 in the registry, CONTROLSET002 is not necessarily 001 and 002, may be ControlSet005, 006 and so on, delete the time can be deleted.

Complete the above four steps to successfully uninstall the MySQL decompression version of the environment.

Second, install MySQL5.6 decompression version

1. Download the MySQL installation package

can go to the official website Download Zip package, http://www.mysql.com/downloads/mysql/click Open link

I'm installing mysql-5.6.35-winx64.


2. Unzip to the local directory

E:\mysql-5.6.35-winx64


3. Add system Environment Variables

Add system environment variables to make it easier in the Command control window.


New: Mysql_home ==> E:\mysql-5.6.35-winx64
Append:path==>;%mysql_home%\bin


4. Modify the configuration file for mysql-5.6.35-winx64: My-default.ini
Append
-------
basedir=e:\mysql-5.6.35-winx64
in [mysqld] Datadir=e:\mysql-5.6.35-winx64\data
Character-set-server = UTF8
-------

5. Install the MySQL5.6 application


Save the My-default.ini configuration,

Then open the command line (Start menu ==> run ==>cmd)
Input: mysqld--console and enter will see something like this:
-------
C:\windows\system32> Mysqld--console
120410 14:25:22 [Note] Plugin ' federated ' is disabled.
120410 14:25:22 innodb:the InnoDB memory heap is disabled
120410 14:25:22 innodb:mutexes and rw_locks use Windows int erlocked functions
120410 14:25:22 innodb:compressed tables use zlib 1.2.3
120410 14:25:22 innodb:initializing buf Fer pool, size = 128.0M
120410 14:25:22 innodb:completed initialization of buffer pool
120410 14:25:22 Innodb:high EST supported file format is Barracuda.
120410 14:25:22 innodb:waiting for the background threads to start
120410 14:25:23 innodb:1.1.8 started; log sequ ence number 1595675
120410 14:25:23 [note] Event scheduler:loaded 0 Events
120410 14:25:23 [note] Mysqld:ready for Connections.
Version: ' 5.5.22 ' socket: ' port:3306 mysql Community Server (GPL)
-------
==> proof that the MySQL service is started

6. Set the password to log in to the MySQL root account
Open a new command line, enter Mysql-uroot carriage return
-------
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 1
Server version:5.5.22 MySQL Community Server (GPL)


Copyright (c), +, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners. Www.2cto.com


Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.
-------
==〉 See the above similar description of the success of the login, at this time the root account is no password
To perform a command change password:


Use MySQL;
Update user Set Password=password ("Fill in the password you want to set here") where user= ' root ';


Exit the MySQL operation after execution, then close the MySQL service and restart the MySQL service


Then use your root account to log in

mysqladmin-u Root Password your password


This will allow you to log in normally.

Original address

http://blog.csdn.net/y562363753/article/details/68065086

mysql5.6.x non-online installation version (decompression version) installation process