Windows 10 + MySQL 5.5 installation and usage tutorial sharing

1. To install MySQL 5.5, use

. Click the MySQL installation file directly to install, but there are relatively large ones. Probability of 2502 error and 2503 error

Solution:

##1) Find the directory :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 Subject"

6）In the pop-up window, enter every and click "Check Name", you will find "Everyone"

##7) Click OK Finally, set Everyone's basic permissions to "Full Control"

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

##9) After clicking Apply , a security warning pops up, select "Yes"

##10) Then use MySQL Installation files, there will be no 2502 errors and 2503 errors

Note: There is a pit here, even if you set up the installation If the path is elsewhere, MySQL will still be installed in the C:\Program Files path. Of course, it will have no impact on use

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

2. Use the free installation of MySQL 5.5

1) Unzip the MySQL free installation file, such as Place it in D:\Java\mysql

2) Copy the my-small.ini file in the directory and name it my.ini

3) Modify the contents in my.ini

Find the [client] node, append: default-character-set = utf8

Find the [mysqld] node, append:

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

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

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

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

This command is used to register the mysql service into the windows service. If "Service successfully installed." appears after the operation, it means that the service has been installed successfully

You can find the service through the control panel to see if there is a service named MySQL, or you can enter services.msc with win+r to directly enter the service window to see

For the corresponding uninstall service, you can execute the command: enter: mysqld -remove, prompting to uninstall the MySQL service

Similarly, the MySQL service can have a graphical interface Operate to start or close the service. You can also start the service through net start mysql in the command line window, and close the service with net stop mysql

##6) win+r input cmd to enter the command line window, enter: mysql -uroot -p and press Enter. At this time, mysql has no password by default. If "Welcome to the MySQL monitor." is displayed, it means successful login to MySQL

7) Check the character set settings of the database, enter in the command line window: SHOW VARIABLES LIKE "character%"; If the displayed results are "character_set_server" and

"character_set_client" and other series of values They are all utf8, indicating that the character set is set successfully

8) Change the login password to sa, and enter in the command line window: set password for root@localhost = password( 'sa'); After logging out and logging in again, you need to enter: mysql -uroot -psa to log in successfully

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

3. Use of MySQL client

After repeated comparisons, I personally recommend the SQLyog client. It is simple, easy to use, powerful, and has intelligent prompts

As a coder, you may not want to go back and forth with many tools Switch, myeclipse or idea have built-in database connection tools.

Here we recommend DBeaver Core, a plug-in for eclipse. The icon looks like a cute little squirrel.

Installation method: STS is used here, of course eclipse is the same

Enter sql to search, you can see DBeaver, click the Install button and follow the prompts to install it

After the installation is completed, there are several more icons in eclipse, click Create Connection

Choose to connect to the MySQL database

##Fill in the connection information

Choose to load the database driver jar package

Test whether the connection is successful

## You can switch to the database operation view to perform operations

##There are some Smart prompts. It’s a pity that there are not enough smart prompts at present. For example, auto_increment doesn’t prompt, so just use it. ^_^

The above is the detailed content of Windows 10 + MySQL 5.5 installation and usage tutorial sharing. For more information, please follow other related articles on the PHP Chinese website!