IDEA console error message.
    check the manual that corresponds to your MySQL server version for the right
    Code: 1064, SQL State: 42000]  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=1000' （'OPTION SQL_SELECT_LIMIT=DEFAULT'）at line 1

Problem solving process.
    Update mysql version according to "You have an error in your SQL syntax", "your MySQL server version", to no avail.

    Check the pom.xml
        <! -- Importing Mysql database link jar package -->
                <dependency>
                    <groupId>mysql</groupId>
                    <artifactId>mysql-connector-java</artifactId>
                    <version>${mysql-connector.version}</version>
                    <scope>runtime</scope>
                </dependency>

    According to "OPTION SQL_SELECT_LIMIT=1000 (DEFAULT)", the online information will be srm project, ssm (Basic-Single-Module-SSM) project to change the mysql driver file in Database to mysql-connector-java-5.1.21.jar successfully.

Similar Posts:

• [Solved] SLF4J: Failed to load class “org.slf4j.impl.StaticLoggerBinder”.
• [How to Solve] for the right syntax to use near ”X”
• Springboot always reports an error when importing JSP dependencies
• [Solved] SparkSQL Error: org.apache.hadoop.security.HadoopKerberosName.setRuleMechanism
• Error during artifact deployment. See server log f
• Springboot startup error start bean ‘eurekaautoserviceregistration’ NullPointerException
• Maven does not have a servlet (an error is reported after the servlet is created)
• mysqldump: Couldn’t execute ‘SET OPTION SQL_QUOTE_SHOW_CREATE=1’
• Unregistering JMX-exposed beans on shutdown Solution
• [Solved] Cannot initialize Cluster. Please check your configuration for mapreduce.framework.name and the correspond server addresses