1).第一次设置root密码 (默认root密码为空)1[root@Mysql1 ~]# mysqladmin -uroot passWord '1
1).第一次设置root密码 (默认root密码为空)
1 |
2).修改root密码
1 | [root@mysql1 ~]# mysqladmin -uroot -p123456 password '123456789' |
1 | [root@mysql1 ~]# mysqladmin -uroot -p123456789 password 'hua19900822**' |
3).set password设置密码
1 2 3 4 5 | mysql> set password=password('123456'); #修改密码 Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges; #同步到磁盘上 Query OK, 0 rows affected (0.00 sec) |
4).update语句修改密码
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | mysql> use mysql; Database changed mysql> select user,host,password from user; +------+-----------+-------------------------------------------+ | user | host | password | +------+-----------+-------------------------------------------+ | root | localhost | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | | root | mysql1 | | | root | 127.0.0.1 | | | root | ::1 | | | | localhost | | | | mysql1 | | +------+-----------+-------------------------------------------+ 6 rows in set (0.00 sec)
mysql> update user set password=PASSWORD('789789') where user='root' and host='localhost'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) |
--结束END--
本文标题: 03-设置root密码
本文链接: https://www.lsjlt.com/news/35154.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-07
2024-05-07
2024-05-07
2024-05-07
2024-05-07
2024-05-07
2024-05-07
2024-05-07
2024-05-07
2024-05-07
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0