IntelliJ idea MySQL5 Spring 4 Mybatis 3 Dubbo elastic-job Configuration steps detailed (b)

Objective

Continue on an installation tutorial first is the MySQL green version after the installation of other components, if the length of the longer will be divided into a number of in-depth explanation, essays belong to the study notes many errors also hope to point out the common learning.

MySQL 5.7 Green Edition

My local installation is MySQL5.7.16, resources Baidu Search a large number of large quantities of the. exe version of the I did not install but look at the tutorial does not seem difficult here do not do too much explanation, simply say the green version of the installation steps:

First download MySQL 5.7.16 after the decompression, you need to note the decompression address because the subsequent need to configure this address in the environment variables, so do not put a place.

After creating the folder, you need to modify the default configuration, open the My-default.ini file as text to find the following lines of code, delete the previous # parameter parameter value, parameter description:

# These is commonly set, remove the # and set as required.

These are common settings, delete # and on-demand settings

# set up the MySQL installation directory
basedir=d:\dev\mysql-5.7.11
# Set the data storage directory for MySQL database, must be
Datadir=d:\dev\mysql-5.7.11\data
Note: The path is a backslash, can also be changed to two forward slash, you can also add a double quotation mark
# MySQL port (default)
port=3306

Add MySQL global variable to path in environment variable after basic setup is complete

When the preparation is complete, start the CMD console and start the installation, and the console page enters the installation directory Bin folder and enters the following command:

mysqld--initialize-insecure the command means to initialize the MySQL program without the root password or

Mysqld--initialize After the command is executed, it is randomly obtained a root password subsequent login requires this password

According to the requirements of the choice of one can be executed after the console is not responding but the installation directory Data folder will appear a lot of files:

It's important to note that when you execute the command, your data folder Chunga like this:

Include files correctly:

If the data folder looks like this after your command has been executed, you will need to re-delete all files under the Data folder to check if the input command is re-entered correctly.

Then execute the Mysqld-install if the servicesuccessfully installed indicates that the service has been successfully installed

Here is a summary of several unsuccessful installation, the error for your reference:

The first is the installation of MySQL this time the reinstallation will appear:

Workaround: Remove the once installed service to reinstall the console database under the bin directory to execute SC delete MySQL If successful execution will appear after the prompt of [SC] DeleteService SUCCESS and then install normally.

The second is a common problem with the installation of version 5.6.

Workaround: Follow the above and execute the mysqld-explicit_defaults_for_timestamp=true before you proceed with the command.

Cause of Error:

The third mistake is to enter the startup services net start MySQL error "When you finish the install" MySQL service failed to start, the service did not report any errors, please type NET helpmsg 3534 for more help ":

Workaround: Follow the above method to check whether the command is entered incorrectly, check the data folder if the file is correct if you do not delete all the contents and execute mysqld-remove-->mysqld install-->mysqld-- Initialize view the data directory again, and you can continue to do so after normal.

Cause of error: When executing mysqld--initialize and executing mysqld-initialize system will not actively prompt you missing some files, when running MySQL need to read data inside the current database information, If there is no MySQL file in the data, you will get an error.

For the time being to provide a solution to these two errors, do not want to resolve the error of the classmate can choose to directly reinstall MySQL actually the steps are very simple but here to provide three points of advice

1. To stop the MySQL Service execution command net stop MySQL before reloading

2. Delete all the contents of the Data folder and delete the service Mysqld-remove

3. Delete Related legacy registration Information execute SC delete MySQL

After these three successes are re-installed

Error message above summarizes a few common, continue to start the MySQL service, after successfully adding the service after the CMD console Mysqlbin directory continues to execute the net start MySQL display service startup, the service starts successfully.

Here are the changes to the default password if you choose to login without a password, then directly in the CMD console mysqlbin directory input mysql-u root display input login password, without the control of the direct return to the landing success

If you choose to generate root random password then how to find this password I will not say it is very simple Baidu will know, here to say how to modify his root random password

First to stop the current MySQL service, console MySQL bin directory input net stop MySQL,

After stopping the service, locate the My-default.ini or the My.ini file,

Open this file as a notepad last line add a sentence skip-grant-tables then save

After re-opening the service console data net start MySQL successfully turned on after re-entering mysql-u root prompt input password no tube direct enter

Appear welcome .... Indicates successful landing

The following starts to modify the login password, enter the update mysql.user set Password=password (' root ') where user= ' root ' here need to explain Mysql5.6 before the password store is in the password field , and after 5.7 changes will be error display does not have this field, changed to authentication_string, so when the password change if there is a 1054 error encoding may be this reason, know why after re-enter: Update Mysql.user set Authentication_string=password (' root ') where user= ' root ' well, it worked.

IntelliJ idea MySQL5 Spring 4 Mybatis 3 Dubbo elastic-job Configuration steps detailed (b)