Install mysql Green Edition, environment variable configuration-noinstall_mysql _ start service --- shinepans, mysql Green Edition start

Source: Internet
Author: User

Install mysql Green Edition, environment variable configuration-noinstall_mysql _ start service --- shinepans, mysql Green Edition start
1. Download a version of mysql without installation.


See the following for reference: http://url.cn/YXTsSU can be directly downloaded. This version is 5.0 stable version. noinstall


2. decompress the downloaded file to a certain place. For example, I can decompress it here:



2.1 configure environment variables:


2.1.1 add in path: D: \ GreenSoft \ mysql-5.0.22-win32 \ bin; this is my decompression path, replace it with yours.


2.1.2 new MYSQL_HOME. Value: D: \ GreenSoft \ mysql-5.0.22-win32 value corresponding to the decompression location.


3. Find the ini configuration file under the root directory of the extracted file. If there are multiple ini configuration files, delete the other files and select one at will.


[Client] password = 123 // The password port = 3306 // The port socket =/tmp/mysql used here. sock [mysqld] port = 3306 socket =/tmp/mysql. sockskip-lockingkey_buffer = 16Mmax_allowed_packet = 1Mtable_cache = 64sort_buffer_size = 512Knet_buffer_length = 8Kread_buffer_size = bytes = 8 M // These buffer memories are set to the default. log-bin = mysql-binserver-id = 1 [mysqldump] quickmax_allowed_packet = 16 M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL # safe-updates [isamchk] key_buffer = protocol = 20Mread_buffer = 2Mwrite_buffer = 2 M [Protocol] key_buffer = protocol = 20Mread_buffer = 2Mwrite_buffer = 2 M [mysqlhotcopy] interactive-timeoutbasedir = D: \ GreenSoft \ mysql-5.0.22-win32 // Note: here you need to change your decompression address, format and my similar datadir = D: \ GreenSoft \ mysql-5.0.22-win32 \ data // Note ::: here, we need to change the decompressed address for you. The format is similar

Change the content to the above.



4. Open the terminal and enter mysqld install MySQL -- defaults-file = "The. ini file path you just changed (including the ini file to be written )"


4.1 then the mysql service is established.


5. net start mysql enable the service. It is recommended to set it to manual start (not commonly used) after it is enabled)


Net stop mysql close Service


An easy-to-happen error: if the service already exists, remove it and use the remove command, for example, mysqld-remove.


6. mysql has been installed. The next article will introduce the use of mysql workbench.
Zookeeper

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.