\u767b\u5f55\uff1a<\/strong><\/p>\n\n\n\n# grep “password” \/var\/log\/mysqld.log<\/p>\n\n\n\n
2024-08-16T10:19:26.880855Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: R7)W&&\/JsX(G<\/p>\n\n\n\n
# mysql -uroot -p<\/p>\n\n\n\n
\u8f93\u5165\u4e0a\u9762\u7684\u5bc6\u7801\u767b\u5f55\u8fdb\u53bb\uff0c\u67e5\u770b\u63d2\u4ef6\uff0c\u4fdd\u8bc1mysql_native_password\u6fc0\u6d3b\u4ee5\u4fbf\u548c5.x\u7248\u672c\u7684\u5bc6\u7801\u7b97\u6cd5\u517c\u5bb9\uff1a<\/p>\n\n\n\n
> show plugins;<\/p>\n\n\n\n
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL |<\/p>\n\n\n\n
\u628a\u5bc6\u7801\u9a8c\u8bc1\u6539\u6210\u6700\u7b80\u5355\u7684\uff08\u7ebf\u4e0a\u7cfb\u7edf\u4e0d\u5efa\u8bae\uff09\uff1a<\/p>\n\n\n\n
> ALTER USER ‘root’@’localhost’ IDENTIFIED BY “1234@abcd”;<\/p>\n\n\n\n
> set global validate_password.policy=0;<\/p>\n\n\n\n
> set global validate_password.length=1;<\/p>\n\n\n\n
> ALTER USER ‘root’@’localhost’ IDENTIFIED BY “123456”;<\/p>\n\n\n\n
> use mysql;<\/p>\n\n\n\n
> select * from user;<\/p>\n\n\n\n
> CREATE USER ‘root’@’%’ IDENTIFIED BY ‘123456’;<\/p>\n\n\n\n
\uff08\u5982\u679c\u4ece\u8001\u7248\u672c\u5347\u7ea7\uff1a> CREATE USER ‘root’@’%’ IDENTIFIED WITH ‘mysql_native_password’ BY ‘123456’ \uff09<\/p>\n\n\n\n
> GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ WITH GRANT OPTION;<\/p>\n\n\n\n
> FLUSH PRIVILEGES;<\/p>\n\n\n\n
\u79fb\u9664\uff1a<\/strong><\/p>\n\n\n\n# dnf remove mysql-server<\/p>\n\n\n\n
# dnf remove mysql-server-common-*<\/p>\n\n\n\n
# dnf list installed | grep mysql<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5148\u66f4\u65b0Rocky\u7684\u6e90\u5230\u5883\u5185\uff1a # sed -e ‘s|^mirrorlist=|#mirrorli …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,63],"tags":[9,365,910],"class_list":["post-1166","post","type-post","status-publish","format-standard","hentry","category-linuxandroid","category-63","tag-linux","tag-mysql","tag-rocky"],"views":793,"_links":{"self":[{"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1166"}],"version-history":[{"count":1,"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1166\/revisions"}],"predecessor-version":[{"id":1167,"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1166\/revisions\/1167"}],"wp:attachment":[{"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1166"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.max-shu.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}