mysql 报错: The specified database user/password combination is rejected: [28000][1045]
报错:The specified database user/password combination is rejected: [28000][1045] Could not connect to address=(host=localhost)(port=3306)(type=master) : (conn=18) Access denied for user 'root'@'127.0.0.
报错:
The specified database user/password combination is rejected: [28000][1045] Could not connect to address=(host=localhost)(port=3306)(type=master) : (conn=18) Access denied for user 'root'@'127.0.0.1' (using password: YES) Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding' [28000][1045] (conn=18) Access denied for user 'root'@'127.0.0.1' (using password: YES) Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'
参考: https://blog.csdn.net/weixin_39608791/article/details/108323651 没找到答案
https://blog.csdn.net/qq_28938933/article/details/72872064
我的数据库是在docker中部署的 ipburger/mysql-alpine.docker:release (MariaDB)
1, my.ini中
在[mysqld]下添加skip-grant-tables,保存即可。
2, 重启docker 容器
3, 进入容器内部
mysql -u root -p;
回车
use mysql;
4, select host,user,password from user order by host desc,user desc;
将排序序列中最前面的用户修改host为’%’
5 改不了 就把最前面的用户删掉
DELETE FROM mysql.user where host = ‘127.0.0.1’ and user = ‘root’;
flush privileges;
好了 数据库就可以连上了
他奶奶个腿!
更多推荐
所有评论(0)