64-bit win7 mysql decompress version, personal records

Lz downloaded a mysql5.7 file from mysql.org on the official website today. After decompression, it found that the setup installation file could not be found. After checking the internet, you will know that this is not the installation version, but the decompress version. You need to manually configure it. I wanted to re-download an installation version to save time, but as a result, I wanted to take the O & M direction, so I could just get in touch with how to configure mysql. Here

Lz today in the official website http://mysql.org downloaded a mysql5.7, the results of decompression found that the setup installation file is not found. After checking the internet, you will know that this is not the installation version, but the decompress version. You need to manually configure it. I wanted to re-download an installation version to save time, but as a result, I wanted to take the O & M direction, so I could just get in touch with how to configure mysql. Here

Lz today in the official website http://mysql.org downloaded a mysql5.7, the results of decompression found that the setup installation file is not found. After checking the internet, you will know that this is not the installation version, but the decompress version. You need to manually configure it.

I wanted to re-download an installation version to save time, but as a result, I wanted to take the O & M direction, so I could just get in touch with how to configure mysql.

Here, we should seriously despise some people who directly copy others' blogs. If they have not tried to copy the blog, they will copy it directly. As a result, most of the articles found are copied, there is no great reference value, which wastes valuable time.

At least after the experiment is feasible, or where it is not feasible, post the solution and share it so that we can continue to improve ~~

Let's not talk nonsense. Next:

1. Add system variables and add your bin location in path. For details, right-click computer-properties-advanced system settings-environment variables-system variables and add the bin path under mysql to the path. My path is "d: \ software \ mysql-5.7.3-m13-winx64 \ bin ;"

2. Create a New notepad named "my-small.ini"

3. Edit the content as follows:

Save the file to c: \ windows.

Paste this file for your convenience:

# The following options will be passed to all mysql clients
[Client]
Default-character-set = utf8
# Passward= 12344321
Port = 3306
Socket =/tmp/mysql. sock

# Here follows entries for some specific programs

# The mysql server
[Mysqld]
Explicit_defaults_for_timestamp = true
Default-character-set = utf8
Skip-grant-tables
Basedir = d: \ software \ mysql-5.7.3-m13-winx64
Datadir = d: \ software \ mysql-5.7.3-m13-winx64 \ data
Default-storage-engine = MyISAM
Port = 3306
Socket =/tmp/mysql. sock
# Skip-locking
Key_buffer = 384 M
Max_allowed_packet = 1 M
Table_cache = 512
Sort_buffer_size = 2 M
Read_buffer_size = 2 M
Read_rnd_buffer_size = 8 M
Myisam_sort_buffer_size = 64 M
Thread_cache_size = 8

4. Run cmd-mysql

Possible problems:

1, "no database selected": create \ select database before use; create database db_name; ", use:" use db_name"

2, ERROR 1044 (42000): Access denied for user ''@ 'localhost' to database 'te1'. solution:

First exit mysql: mysql> exit;

Log on to: c: \ users \ lanzao> mysql-h localhost-u root

Then you can create and use a database.

It is completely the situation and solution encountered during personal installation, and the practice is feasible. The Principles have not been thoroughly understood. If you are interested, please visit the Internet on your own.