java 和mysql相关常见问题汇总，持续更新

1、IDEA 2019.1 Unable to get current time from Google’s servers
file》setting》plugins》取消 Andriod Support 选中状态。
2、IDEA 2019.1 配置maven，使用mavne3.6.3 版本 报错，降低版本为3.5.3.
3、配置maven仓库

<localRepository>E:\JAVA\Maven</localRepository>

<mirror>
    <id>alimaven</id>
    <name>aliyun maven</name>
    <url>http://maven.aliyun.com/nexus/content/groups/public/</url>
    <mirrorOf>central</mirrorOf>
</mirror>
<mirror>
    <id>alimaven</id>
    <mirrorOf>central</mirrorOf>
    <name>aliyun maven</name>
    <url>http://maven.aliyun.com/nexus/content/repositories/central/</url>
</mirror>
 
<mirror>
    <id>ibiblio</id>
    <mirrorOf>central</mirrorOf>
    <name>Human Readable Name for this Mirror.</name>
    <url>http://mirrors.ibiblio.org/pub/mirrors/maven2/</url>
</mirror>
<mirror>
    <id>jboss-public-repository-group</id>
    <mirrorOf>central</mirrorOf>
    <name>JBoss Public Repository Group</name>
    <url>http://repository.jboss.org/nexus/content/groups/public</url>
</mirror>
 
<mirror>
    <id>central</id>
    <name>Maven Repository Switchboard</name>
    <url>http://repo1.maven.org/maven2/</url>
    <mirrorOf>central</mirrorOf>
</mirror>
<mirror>
    <id>repo2</id>
    <mirrorOf>central</mirrorOf>
    <name>Human Readable Name for this Mirror.</name>
    <url>http://repo2.maven.org/maven2/</url>
</mirror>

4、配置jdk
projcect structure》sdks，设置jdk版本

5、mysql8 远程登陆报错 报错 mysql authentication plugin ‘caching_sha2_password’ cannot be loaded; 注意单引号写法
ALTER USER ’root‘@’localhost‘ IDENTIFIED BY ’Xinxi‘ PASSWORD EXPIRE NEVER;
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ’Xinxi‘;
FLUSH PRIVILEGES;
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘Xinxi’
6、IDEA设置代码不提示大小写：
Setting -> Editor -> Code Completion -> 去掉Match case对勾 -> Apply

7、关闭Intellij IDEA自动更新
在File->Settings->Appearance & Behavior->System Settings->Updates下取消Automatically check updates for勾选

8、全局JDK配置
File ->Other Settings -> Structure for new Projects-> Project

9、行号显示和方法间的分隔符
File -> Settings -> Editor -> General ->Appearance

10、自动导包和优化
File -> Editor -> Auto Import

11、生成类注释模板（全局）
File ->Other Settings -> Structure for new Projects-> Editor-> File And Code templates