Modify the mysql port (Windows Installation-free version)

Source: Internet
Author: User

Modify mysql port (Windows without installation) My MySQL is unzipped without installation version, to modify the MySQL port, the method is very simple: unzip MySQL, there is a my-default.ini under the MySQL root directory, open it and the above comment clearly says "# *** do not edit this file ..... copy and paste the file and rename it to my. ini, put it in the root directory, and then there is a # port = ...... remove the comment and modify the port you want, such as port = 3337 cmd and run mysqlmysqld -- console. If you see the last few lines: 08:12:28 3200 [Note] Server hostname (bind-address ): '*'; port: 33372013-04-15 08:12:31 3200 [Note] IPv6 is not available.2013-04-15 08:12:31 3200 [Note]-'0. 0.0.0 'resolves to '0. 0.0.0 '; 08:12:31 3200 [Note] Server socket created on IP: '0. 0.0.0 '. 08:12:31 3200 [Note] Event schedld: Loaded 0 events2013-04-15 08:12:31 3200 [Note] mysqld: ready for connections. version: '5. 6.10 'socket: ''port: 3337 MySQL Community Server (GPL) and test it through remote access. This proves that the decompressed mysql (1) Ctrl + c (2) has been disabled) enter mysqladmin-u root shutdown under cmd

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.