MariaDB设置初始化密码及修改密码

方法1：
[root@localhost ~]# mysql
MariaDB[(none)]> UPDATE mysql.user SET password = PASSWORD(‘newpassword’) WHERE USER = ‘root’;
MariaDB[(none)]> FLUSH PRIVILEGES;

方法2：
[root@localhost ~]# mysql
MariaDB[(none)]> SET password=PASSWORD(‘newpassward’);

方法3：
[root@localhost ~]# mysqladmin -u root password ‘newpassword’
如果root已经设置过密码，采用如下方法
[root@localhost ~]#mysqladmin -u root -p ‘oldpassword’ password ‘newpassword’

https://blog.csdn.net/zwj52pk/article/details/78651647