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

1.停止服务:停止MySQL服务;

2.跳过验证:修改MySQL安装目录下的my.ini配置文件,使登录时跳过权限检查;

在[mysqld]下面添加skip-grant-tables

4.重启服务:service mysqld restart

  • 3
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 3
    评论
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.
评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

夜色如墨

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值