kali 取消mysql免密登录设置，mariadb10.5.8版本；进入MySQL，准确说是mariadb添加一条命令即可

一直不成功，找了好多才成功 

1.查看mariadb状态是否为active,如果没有开启就输入

# systemctl start mariadb  //启动服务
# systemctl enable mariadb  //开机自启
# systemctl status mariadb //查看数据库启动状态

┌──(root💀localhost)-[~]
└─# systemctl status mariadb                                                                                              1 ⨯
● mariadb.service - MariaDB 10.5.8 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
     Active: active (running) since Fri 2023-04-21 19:00:48 CST; 1min 55s ago

2.输入mysql直接可以登录，免密登录一直成功

┌──(root💀localhost)-[~]
└─# mysql                     
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 31
Server version: 10.5.8-MariaDB-3 Debian buildd-unstable

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 

3.进入mariadb中加入一句，设置密码123456，注意这个；也要输入

MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

4.再用刚才方法登录，不输入密码就会报错如图error1045

用mysql -u root -p回车，输入刚才密码123456，免密登录就取消成功了

┌──(root💀localhost)-[~]
└─# mysql                   
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
                                                                                                                              
┌──(root💀localhost)-[~]
└─# mysql -u root -p                                                                                                      1 ⨯
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
                                                                                                                              
┌──(root💀localhost)-[~]
└─# mysql -u root -p                                                                                                      1 ⨯
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 35
Server version: 10.5.8-MariaDB-3 Debian buildd-unstable

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.000 sec)

MariaDB [(none)]> 

免密登录取消成功了