Mysql installation-free version configuration and mysql installation-free version

Mysql installation-free version configuration and mysql installation-free version

Configuration

Decompress mysql-5.7.17-winx64.zip to D: \ database

Modify configurations

Create my. ini
The configuration is as follows:

[Client] # set the default character set default-character-set = utf8mb4 [mysql] default-character-set = utf8mb4 [mysqld] # installation directory basedir = D: \ database \ mysql-5.7.17-winx64 # data storage directory data directory is to be created separately, remember to be an empty folder datadir = D: \ database \ mysql-5.7.17-winx64 \ dataport = character = FALSEcharacter-set-server = utf8mb4collation-server = utf8mb4_unicode_ciinit_connect = 'set NAMES utf8mb4' # default storage engine default-storage-engine = INNODB # max_connections = 100 # maximum number of connections per memory table max_heap_table_size = 64 M # sort_buffer_size = 8 M # buffer size for join table operations, according to the actual business settings, the default 8Mjoin_buffer_size = 32 M # SQL query cache. If the submitted query is the same as a query in a number of times and exists in the query cache, the result query_cache_size = 64 M is returned directly.

Note:
1. the encoding here is ansi, otherwise the following error will be reported: error: Found option without preceding group in config file: D: \ Program Files \ mysql-5.6.25-winx64 \ my. ini at line: 1 Fatal error in defaults handling. program aborted

2. Configure skip-grant-tables
Http://blog.csdn.net/ling811/article/details/52651150

Configure Environment Variables

My computer-properties-environment variable settings
Add environment variable MYSQL_HOME = D: \ database \ mysql-5.7.17-winx64
Add % MYSQL_HOME % \ bin after path

Install services

Open the cmd window as an administrator
Execute mysqld-install
Run SC delete mysql on the Windows command line to delete the mysql service.
Continue to execute mysqld-initialize-insecure-user = mysql;-this step produces some files in the data directory.
Execute net start mysql to start the service

Appears:mysqld: Table 'mysql.plugin' doesn't exist
Solution: http://www.jb51.net/article/116604.htm
Stop mysql service: net stop mysql, and then restart mysql Service

Modify mysql password

Go to mysql and change the root password
The Default root Password is empty.
Run mysql-uroot-p
Press enter to enter the default password
Switch to database mysql
Use mysql
Change root Password

-Execute mysql5.6 to change the password.
UPDATE user SET password = PASSWORD ('000000') WHERE user = 'root ';
This method is available in versions earlier than MySQL 5.7, and does not have this column.

-Change Password in mysql5.7
Set password = password ('20140901 ');
Flush privileges;

Windows server 2008 configuration will appear
The application cannot start 0xc000007b. How can this problem be solved?
Solution: DirectX Repair Tool Latest Version: DirectX Repair V3.5 enhanced version NEW!
Http://blog.csdn.net/vbcom/article/details/7245186

Note: windows server 2008 is configured and installed with various problems, which can be Excerpted from the experts. The younger brother is the solution Porter ~ _~

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.