mariadb设置初始化密码

方法1：

 [[email protected] ~]# mysql 
    MariaDB[(none)]> UPDATE mysql.user SET password = PASSWORD(‘newpassword’) WHERE USER = ‘root’;
    MariaDB[(none)]> FLUSH PRIVILEGES;

方法2：

[[email protected] ~]# mysql
MariaDB[(none)]> SET password=PASSWORD('newpassward');

方法3：

  [[email protected] ~]# mysqladmin -u root password 'newpassword'
  如果root已经设置过密码，采用如下方法 
 [[email protected] ~]#mysqladmin -u root -p 'oldpassword' password 'newpassword'