Mariadb数据库开启密码登录

相关链接：MySQL开启密码登录

Linux安装MySQL数据库并配置远程登录

use mysql;
UPDATE mysql.user SET authentication_string = PASSWORD('xinyang123'), plugin = 'mysql_native_password' WHERE User = 'root' AND Host = 'localhost';
FLUSH PRIVILEGES;

ps:第二句命令中的xinyang123为设置的密码，请根据自身需求更改