Installation and Use of Windows 10 and MySQL 5.5 and installation-free tutorials (image text), mysql5.5

Installation and Use of Windows 10 and MySQL 5.5 and installation-free tutorials (image text), mysql5.5

This article describes how to install and use MySQL 5.5 in Windows 10.

Download resources:

MySQL Installation File: http://download.csdn.net/detail/lf19820717/9892711

MySQL installation-free files: http://download.csdn.net/detail/lf19820717/9892716

Bytes ------------------------------------------------------------------------------------------------

1. install and use MySQL 5.5

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

Solution:

1) Find the directory C: \ Windows \ temp

2) Right-click the directory -----> "properties" -----> "security"

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

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

5) in the displayed window, click "select subject"

6) in the displayed window, enter every and click "Check name" to find "Everyone"

7) Click "OK" and set the basic permissions of Everyone to "full control"

8) Click "OK" to view the "Everyone" message.

9) Click "application" and a security warning will pop up. Select "yes"

10) if you use the MySQL installation file again, no 2502 or 2503 errors will occur.

Note: There is a pitfall here. Even if you have set the installation path elsewhere, MySQL will still be installed in the C: \ Program Files path. Of course, this will not affect the usage.

Bytes ------------------------------------------------------------------------------------------------

2. free installation and use of MySQL 5.5

1) decompress the MySQL installation-free file, for example, in the D: \ Java \ mysql location

2) copy the my-small.ini file under the directory named my. ini

3) modify the content in my. ini.

Find the [client] node and append it to default-character-set = utf8.

Locate the [mysqld] node and append the node:

Basedir = "D :\\ Java \ MySQL" datadir = "D :\\ Java \ MySQL \ data" character_set_server = utf8 collation-server = utf8_general_ci

Create a [WinMySQLadmin] node and add: Server = D: \ Java \ mysql \ bin \ mysqld.exe

4) append: D: \ Java \ mysql \ bin to the Path of the system variable of the environment variable;

5) in the D: \ Java \ mysql \ bin directory, execute the command (you can right-click and find "Open command window here ", you can also enter this directory in command line window mode): mysqld-install

This command is used to register the mysql Service to the windows Service. If "Service successfully installed." appears after the operation, the Service is successfully installed.

You can find the service on the Control Panel to check whether it is a MySQL service, or enter services. msc in win + r to go to the service window to view the service.

Run the following command to uninstall the MySQL service: mysqld-remove.

Similarly, the MySQL service can be opened or closed through a graphical interface, or the service can be started through net start mysql in the command line window, and the service can be disabled by net stop mysql.

6) win + r Enter cmd to enter the command line window, enter mysql-uroot-p and press Enter. mysql has no password by default. If "Welcome to the MySQL monitor" is displayed. "indicates that MySQL is successfully logged on.

7) Check the character set settings of the database. In the command line window, enter: show variables like "character % "; if the displayed result "character_set_server" and "character_set_client" are all UTF-8, the character set is set successfully.

8) change the logon password to sa. In the command line window, enter: set password for root @ localhost = password ('sa '). After exiting, log on again and enter: mysql-uroot-psa can be successfully logged on

Certificate -----------------------------------------------------------------------------------------------------------------------------------------------------------------------

3. Use of the MySQL client

After repeated comparisons, I personally recommend the SQLyog client, which is simple and easy to use, powerful and smart.

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

We recommend a plug-in DBeaver Core of eclipse. the icon is like a cute squirrel.

Installation Method: STS is used here. Of course, eclipse is the same.

Enter SQL to search for DBeaver. Click the Install button and Install DBeaver as prompted.

After the installation is complete, Several icons are added to eclipse. Click Create connection.

Select to connect to the MySQL database

Enter connection information

Select to load the database driver jar package

Test whether the connection is successful.

You can switch to the database operation view for operations.

There are some Smart Tips. Unfortunately, there are not many smart prompts at present. For example, there are no prompts for auto_increment. Use them together. ^_^

The above section describes how to install and use Windows 10 and MySQL 5.5 and how to use it without installation. If you have any questions, please leave a message, the editor will reply to you in time!