连接数据库报错
Connection to demo@localhost failed. [08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up.

连接数据库报错

Connection to demo@localhost failed. [08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up.

处理



在URL后面加上?serverTimezone=GMT即可

数据库报错1264



php程序报错1264 



这个原因有可能是字段长度不够，改变一下字段长度



 

 

 

连接信息配置错误

SpringBoot项目连接数据库报错：Access denied for user 'root'@'localhost' (using password: YES)

reate connection SQLException, url: jdbc:mysql://localhost:3306/ebook, errorCode 1045, state 28000

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[mysql-connector-java-5.1.47.jar:5.1.47]

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) ~[mysql-connector-java-5.1.47.jar:5.1.47]

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) ~[mysql-connector-java-5.1.47.jar:5.1.47]

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871) ~[mysql-connector-java-5.1.47.jar:5.1.47]

    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714) ~[mysql-connector-java-5.1.47.jar:5.1.47]

SpringBoot项目配置文件有两种格式，常用的application-xx.properties和最新的application-xx.yml。 

运行项目时常常出现以上错误。一般是两个原因导致的：要么是连接信息配置错误，要么就是数据库未授权。

properties方式配置的话，只要填写正确的用户名和密码，就可以了，但是yml配置会出现一些错误；

如下：

spring:

  datasource:

    driver-class-name: com.mysql.jdbc.Driver

    url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&useSSL=false

    username: root

    password: 012345


正确表示：

spring:

  datasource:

    driver-class-name: com.mysql.jdbc.Driver

    url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&useSSL=false

    username: root

    password: "012345"


yml是区分数据类型的，所以如果用户名或者密码是数字的话就会出错。所以如果password为012345的话，最终获取到的值是12345，这样是不对的，只能用字符串"012345"，才能正确表示。

 

mysql 初始化数据库报错
bin/mysqld \
> --initialize-insecure \    
2018-07-09T09:01:33.092169Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-07-09T09:01:33.093305Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2018-07-09T09:01:33.099451Z 0 [ERROR] Too many arguments (first extra is ' ').
2018-07-09T09:01:33.093325Z 0 [ERROR] Aborting

报错 
[ERROR] --initialize specified but the data directory has files in it. Aborting.
解决方法  删除data 原因 ，可能是重复安装 mysql 导致 data文件夹下有文件
rm -rf /usr/local/mysql/data/*

报错
[ERROR] Too many arguments (first extra is ' ').
初始化命令有空格或者' '里面的命令未能识别

报错
 [ERROR] Aborting
异常终止 ，把其他报错解决 ，就可以了。