[MYAQL / Mariadb] 数据库学习-修改数据库密码

最新推荐文章于 2024-07-27 14:04:42 发布

Satushi-sho

最新推荐文章于 2024-07-27 14:04:42 发布

阅读量425

点赞数

分类专栏：数据库文章标签：数据库 mariadb 学习 mysql

本文链接：https://blog.csdn.net/HYFarashi/article/details/130730957

版权

数据库专栏收录该内容

17 篇文章 0 订阅

订阅专栏

修改数据库密码

mysqladmin -hlocalhost -uroot -p111（原密码） password ‘222’; （）新密码

[root@control ~]# mysqladmin -hlocalhost -uroot password '111';
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

[root@control ~]# mysql -uroot -p111;
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.17 Source distribution

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> exit
Bye


修改密码：
[root@control ~]# mysqladmin -hlocalhost -uroot -p111 password '222';
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.


[root@control ~]# mysql -uroot -p222;
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.17 Source distribution

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql>