mysql-5.5.24 Installation Steps

Source: Internet
Author: User

1. Double-click Mysql-5.5.24-win32.msi to start the installation, next (next)

2. Select "I accept the terms in the Licence agreement" (agree to accept the agreement), then click Next

3. Select Custom

4. You can change the installation path (BROWSE) according to your personal circumstances before selecting next

5. Select Install

6. Start the installation, wait for the popup prompt step

7. Select Next

8. Select Next

9. Select Finish and tick the checkbox in front of "Launch the MySQL ...."

10. Select Next

11. Tick "Standard Configuration" and click Next

12. Select a single option and click Next

13. Tick "Modify Security Settings" and create password, login with password when installation is complete, click

Next (Next)

14. Click Execute

14. Install complete, click Finish

15. Right click on "My Computer" and select "Manage"

16. Double-click "Services and Applications", select "Services" and find "MySQL"

17.MySQl properties, can change its startup type, "Startup Type" changed to "manual", in the case of no self-booting

18. Finally, modify the configuration file My.ini

Find My.ini This file in the MySQL installation directory, which is a major configuration file for MySQL.

Note Make sure that the file under the folder can display the suffix name.

(Installation path: C:\Program Files (x86) \mysql\mysql Server 5.5)

19. Open it with a text editor and modify:

(1) Locate this line and modify the character set to GBK (or UTF8)

Default-character-set=latin1

Switch

Default-character-set=gbk

(2) Locate this line and modify the character set to GBK (or UTF8)

Character-set-server=latine1

Switch

Character-set-server=gbk

(3) Add a line at the end

Lower_case_table_names = 0

The default MySQL is case-insensitive under Windows, where it is configured to be case-sensitive.

Save The above changes and then restart the MySQL service to make the configuration effective!!

mysql-5.5.24 Installation Steps

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.