idea连接mysql报错:The specified database user/password combination is rejected: [28000][1045]

我的pycharm连接mysql报错,
报错可能原因:JDBC驱动程序的5.2版本与UTC时区配合使用,必须在连接字符串中明确指定serverTimezone。

下面直接写解决方案:

  1. 将下面图一中的原URL修改URL为下面这个长串:
jdbc:mysql://localhost:3308/dict?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

在这里插入图片描述
2. 修改之后:
注意要把端口号修改成自己的mysql默认监听端口,有的是3306,有的是3308
还有URL长串中绿色框里的‘dict’这个一定要修改为自己的数据库名

在这里插入图片描述
点击右下角Apply,再点击OK即可,成功连接mysql数据库。

补充:
my.init文件在mysql安装目录下:
在这里插入图片描述

另一个查询端口号方法,也可以在cmd中进入mysql(进入mysql命令自行百度),然后输入status,回车,也可以查询到mysql以及端口号等信息:
在这里插入图片描述

  • 3
    点赞
  • 10
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
The error message "The specified database user/password combination is rejected: [28000][1045] Access denied for user 'root'@'localhost' (using password: NO)" indicates that the specified user 'root' with the provided password is being denied access to the database. This can happen if the password is incorrect or if the user does not have the necessary privileges to access the database. To resolve this issue, you can try the following steps: 1. Double-check the password: Make sure you are using the correct password for the 'root' user. Remember that passwords are case-sensitive, so ensure that you are entering the password exactly as it is. 2. Grant necessary privileges: If the 'root' user does not have the necessary privileges to access the database, you can grant them by logging in to the database with a user that has administrative privileges and running the following command: ``` GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; ``` 3. Reset the password: If you're still unable to access the database, you can try resetting the password for the 'root' user. This can be done by following these steps: - Stop the MySQL server. - Start the MySQL server with the `--skip-grant-tables` option, which allows you to connect to the server without a password. - Connect to the MySQL server and switch to the 'mysql' database. - Update the password for the 'root' user using the following command: ``` UPDATE user SET authentication_string=PASSWORD('new_password') WHERE User='root'; ``` Replace 'new_password' with the desired password. - Flush the privileges and restart the MySQL server. After trying these steps, you should be able to access the database with the 'root' user. If you continue to experience issues, please provide more information about your setup and configuration so that I can assist you further.

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值