Mysql报错记录

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO

很直观的错误，"root"帐号密码错误(有时密码正确也会报这个错)，直接改密码即可
①跳过密码验证登陆MySql
先停止MySql服务

tasklist |findstr mysqld 确认已经停止
taskkill /F /PID xxxx 如果还在运行，用该代码终止

执行下面代码跳过密码验证，执行代码之后cmd会阻塞，直接关闭当前cmd，重新打开一个

 

②密码修改(本人使用的MySql是5.7版，有些版本的密码字段名不同)
跳过密码验证之后直接使用mysql登陆

用select * from mysql.user\G;查询帐号信息(5.7版本密码字段是authentication_string)

修改密码：update mysql.user set authentication_string=password('密码') where user = '帐号';
数据库刷新：flush privileges

重启一下MySql服务

 

---

Access denied for user ' '@'localhost' (using password: NO)

 

与上一个ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO错误很像，但是没有root，配置错误

server:
  port: 9001
spring:
  application:
    name: study-base
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/test2?characterEncoding=utf-8
    //data-username: root
    //data-password: root
    //修改
    username: root
    password: root
  jpa:
    database: mysql
    show-sql: true
    generate-ddl: true

 

---

The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone.

 

jdbc:mysql://localhost:3306/test2
修改
jdbc:mysql://localhost:3306/test2?serverTimezone=UTC