Mariadb给用户设定密码后，还是可以不用密码就可以登录，脑浆被搞出来了，救救我！！！

Question

输入mysql就可以进数据库了

select user();
+-------------------          +
| user()                        |
+-------------------          +
| u0_a165@localhost |
+-------------------         +

select user,password from mysql.user;
 +-------------+-------------------------------------------+
| User        | Password                                  |
+-------------+-------------------------------------------+
| mariadb.sys |                                              |
| root         | invalid                            |
| u0_a165      | *4AD30FA4AA801EDEA3DC33D950D50C8DBDC96170 |    
+-------------+-------------------------------------------+  

这3个用户的plugin: mysql_native_password

确认了 /etc/my.cnf没有skip-grant-tables

也没找到skip-grant-tables相关的系统变量

为什么只输入mysql他就会以u0_a165来登录呢？而且不用密码

Answer 1

https://blog.csdn.net/weixin_39881575/article/details/113720546