Graphical tutorial on installing the green version of MySql5.6.36 under 64-bit systems

This article mainly introducesMySql 5.6.36 64-bit green versionInstallationPicture Friends who need it can refer to

There are many articles about MySQL installation on the Internet, but I encountered a problem during the installation on my laptop today, so I just recorded it

1. Download the zip compressed package of MySQL,

2. After downloading, extract it to the folder you pointed to. This is the path after I decompressed it.

##3. Configure environment

variables , which are the same as configuring Java environment variables.

4. Change the database configuration file . -Copy a copy of default.ini and rename it to my.ini

Change the configuration inside. Note that the file path inside must be enclosed in English double quotes.

<span style="font-size:14px;"># For advice on how to change settings please see 
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html 
# *** DO NOT EDIT THIS FILE. It&#39;s a template which will be copied to the 
# *** default location during install, and will be replaced if you 
# *** upgrade to a newer version of MySQL. 
[mysqld] 
# Remove leading # and set to the amount of RAM for the most important data 
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. 
# innodb_buffer_pool_size = 128M 
# Remove leading # to turn on a very important data integrity option: logging 
# changes to the binary log between backups. 
# log_bin 
# These are commonly set, remove the # and set as required. 
basedir ="D:\Program Files\mysql-5.6.36-winx64" 
datadir ="D:\Program Files\mysql-5.6.36-winx64\data" 
# port = ..... 
# server_id = ..... 
# Remove leading # to set options mainly useful for reporting servers. 
# The server defaults are faster for transactions and fast SELECTs. 
# Adjust sizes as needed, experiment to find the optimal values. 
# join_buffer_size = 128M 
# sort_buffer_size = 2M 
# read_rnd_buffer_size = 2M 
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
#服务端的编码方式 
character-set-server=utf8 
[client] 
#客户端编码方式，最好和服务端保存一致 
loose-default-character-set = utf8 
[WinMySQLadmin] 
Server = "D:\Program Files\mysql-5.6.36-winx64\bin\mysqld.exe" 
</span>

5. Install the mysql service. Switch the dos window to the MySQL bin directory and execute the command

mysqld -install

There is a problem with mine. I searched online and said that the Microsoft Visual C++ 2010 runtime library is missing

##.

Okay, go to the official website to install it and restart the service.

##Run services.msc to view the registered services, and then start the MySQL service

.

##Now our MySQL server has been installed.

6. Log in to the MySQL server and reset the password.

The default user name is. If the root password is empty, use the command mysql –u root –p and press Enter to enter the password and press Enter to log in. At this point, the mysql-5.6.36-winx64 green version is successfully installed.

Let’s change the default password, still in the bin command directory,

Use the mysql

admin.exe command to change the password

mysqladmin –u root –p passw

ord

123456//123456 is the new password. Press Enter to enter the password. This is the original password. If the original password is empty, just press Enter and the change will be successful.

<a href="http://www.php.cn/wiki/1360.html" target="_blank">Log in with a new password</a>

It is really inconvenient to operate under a black window. In actual work, the most commonly used visualization tool for mysql is navicat for mysql. This tool.

The above is the detailed content of Graphical tutorial on installing the green version of MySql5.6.36 under 64-bit systems. For more information, please follow other related articles on the PHP Chinese website!