"Original" no Brain operation: Windows 5.5 + MySQL installation use and free installation

This article describes the installation and use of MySQL 5.5 in a Windows 10 environment and is free of installation

Resources Download:

MySQL installation file: http://download.csdn.net/detail/lf19820717/9892711

MySQL free install file: http://download.csdn.net/detail/lf19820717/9892716

------------------------------------------------------------------------------------------------

1. Installation and use of MySQL 5.5

MySQL installation file directly Click Install, but there is a relatively large probability of 2502 errors and 2503 errors

Solution:

1) directory found: C:\Windows\temp

2) Right-click on the directory-----> Properties-----> Security

3) in the pop-up window, click "Advanced"

4) in the pop-up window, click "Add"

5) in the pop-up window, click "Select Body"

6) in the popup window, enter every, click "Check Name", will find "Everyone"

7) After clicking OK, set everyone's basic permissions to "Full Control"

8) Click OK, you can see the more "Everyone" information

9) After clicking on the app, pop up the security warning and select "Yes"

10) Then use the MySQL installation file, there will be no 2502 errors and 2503 errors

Note: There is a pit here, even if you set the installation path elsewhere, MySQL will still be installed in the C:\Program files path, of course, it does not affect the use of

------------------------------------------------------------------------------------------------

2, MySQL 5.5 Installation-free use

1) Unzip the MySQL installation-free files, such as in D:\Java\mysql location

2) Copy the My-small.ini file under the directory named My.ini

3) Modify the contents of the My.ini

Locate the [Client] node, append: Default-character-set = UTF8

Locate the [MYSQLD] node and append:

Basedir = "D:\\java\\mysql"
DataDir = "D:\\java\\mysql\\data"
Character_set_server = UTF8
Collation-server = Utf8_general_ci

New [Winmysqladmin] node, adding: Server = D:\Java\mysql\bin\mysqld.exe

4) Append to the system variable name path of the environment variable: D:\Java\mysql\bin;

5) in the D:\Java\mysql\bin directory, execute the command (you can shift+ the right mouse button to find "Open command Window Here", or in the command-line window mode to enter the directory): Mysqld-install

This command is used to register the MySQL service with the Windows service, if "service successfully installed" appears after the operation. Description Service has been successfully installed

The service can be found through the control Panel to see if the service is known as MySQL, or win+r input services.msc directly into the service window to view

Corresponding uninstall service, can execute command: input: mysqld-remove, prompt MySQL service uninstall

Similarly, the MySQL service can either open the service with graphical interface operation or shut down the service, or start the service via net start MySQL under the Command Line window, net stop MySQL shutdown service

6) win+r input cmd into the Command line window, enter: Mysql-uroot-p return, at this time MySQL default no password, if the display "Welcome to the MySQL monitor." Instructions for successfully logging in to MySQL

7) View the character set of the database and enter it in the Command line window: SHOW VARIABLES like "character%"; If a series of values such as "Character_set_server" and "Character_set_client" are displayed, the character set setting succeeds UTF8

8) Change the login password to SA, enter in the command Line window: set password for [email protected] = password (' sa '); Log in after exiting, you need to enter: MYSQL-UROOT-PSA to successfully login

--------------------------------------------------------------------------------------------------------------- --------------------------------------------------------

3, the use of MySQL client

After repeated comparison, personal recommendation SQLyog This client, simple and easy to use, powerful, smart tips

As a code farmer, you may not want to switch back and forth many tools, myeclipse or idea have built-in database connection tools.

The eclipse is recommended as a plug-in Dbeaver Core, the icon seems to be a cute little squirrel.

Installation method: The STS here, of course eclipse

Enter SQL to find, you can see the Dbeaver, click the Install button according to the prompt installation is OK

After the installation is complete, there are several more icons in Eclipse, click Create Connection

Choose to connect to MySQL database

Fill in the connection information

Select Load Database driver jar Package

Test if the connection is successful

You can switch to the operation view of the database operation

There are some smart tips oh, it is a pity that the current intelligent tips are not enough, such as auto_increment are not prompted, make use of it ^_^

"Original" no Brain operation: Windows 5.5 + MySQL installation use and free installation