Mysql修改密码
初次安装MySQL默认没有密码,安装完毕之后最好增加密码
1、命令
1 #/usr/bin/mysqladmin -u root password 'new-password'
格式:mysqladmin -u 用户名 -p 旧密码 password 新密码
2、例子
例1:给root加个密码admin
键入以下命令 :
1 [root@node1]# /usr/bin/mysqladmin -u root password admin
注:因为开始时root没有密码,所以-p旧密码一项就可以省略了。
3、测试是否修改成功
1)不用密码登录
1 [root@node1 /]# mysql
2 ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
显示错误,说明密码已经修改。
2)用修改后的密码登录
1 [root@node1 /]# mysql -u root -p 2 Enter password: (输入修改后的密码admin) Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 7
Server version: 5.5.60-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
成功!
这是通过mysqladmin命令修改口令,也可通过修改库来更改口令。
4)使用SQL语句再次修改密码
1 [root@node1 /]# mysql -u root -p 2 Enter password: (输入修改后的密码admin)
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 28
Server version: 5.5.60-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [mysql]> set password=password('123456');
Query OK, 0 rows affected (0.00 sec)
MariaDB [mysql]> exit
Bye
5)用再次修改后的密码登录
1 [root@node1 /]# mysql -u root -p 2 Enter password: (输入再次修改后的密码)
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 29
Server version: 5.5.60-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
登录成功!
6)使用linux命令再次修改密码
1 [root@node1 /]# mysqladmin -u root -p password abcdef (这里abcdef是新密码) 2 Enter password: (输入上一次的密码)
7)使用新密码登录
1 [root@node1 /]# mysql -u root -p 2 Enter password: (使用新密码)
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 35
Server version: 5.5.60-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
登录成功!