mysql修改密码

数据库内修改密码

MariaDB [(none)]> set password for root@localhost = password('123');

Query OK, 0 rows affected (0.00 sec)

 

MariaDB [(none)]> flush privileges;

Query OK, 0 rows affected (0.00 sec)

数据库外修改密码

旧密码修改为新密码

[root@client ~]# mysqladmin -uroot -p'123' password '123456'