报错:

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;
好了 数据库就可以连上了

他奶奶个腿!
在这里插入图片描述

Logo

华为开发者空间,是为全球开发者打造的专属开发空间,汇聚了华为优质开发资源及工具,致力于让每一位开发者拥有一台云主机,基于华为根生态开发、创新。

更多推荐