MySql 5.6.36 64-Bit green edition installation graphic tutorial, mysql5.6.36

MySql 5.6.36 64-Bit green edition installation graphic tutorial, mysql5.6.36

There are a lot of articles on installing MySQL on the Internet, but I encountered a problem in installing MySQL on my laptop today. Here is the only record.

1, download MySQL zip compressed package, https://dev.mysql.com/downloads/mysql/ in the official website according to the needs of the version of Windows 32-bit and 64-bit.

2. Download the package and decompress it to the folder you specified. This is the decompressed path.

3. Configure environment variables, which is the same as the environment variables configured in Java.

4. Change the database configuration file. Rename the my-default.ini copy under the root directory to my. ini

Change the configuration. Note that the file path must contain double quotation marks.

<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'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 = 128 M # 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 = 128 M # sort_buffer_size = 2 M # bytes = 2 M SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES # character-set-server = utf8 [client] # client encoding method, it is best to save the same 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

I encountered a problem. I found it online and said that the Microsoft Visual C ++ 2010 Runtime Library is missing.

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

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

By now, the MySQL server has been installed.

6. log on to the MySQL server and reset the password.

Because the default username is "root" and the password is empty, run mysql-u root-p and press enter to enter the password and press enter to log on. The mysql-5.6.36-winx64 Green Edition is installed successfully.

Change the password. In the bincommand directory, use the mysqladmin.exe command to change the password.

mysqladmin –u root –p password 123456//123456It is a new password. Press enter to enter the password. The original password is blank and press enter to change the password.

Log on with the new password

The operation in the black window is really inconvenient. In actual work, the mysql visualization tool is navicat for mysql at most.

The above is a graphic installation tutorial for MySql 5.6.36 64-Bit green edition. I hope it will help you. If you have any questions, please leave a message and I will reply to you in time. Thank you very much for your support for the help House website!