{"id":261,"date":"2024-07-19T10:48:02","date_gmt":"2024-07-19T02:48:02","guid":{"rendered":"https:\/\/thereisno.top:4430\/?p=261"},"modified":"2024-07-19T10:48:02","modified_gmt":"2024-07-19T02:48:02","slug":"mysql%e9%87%8d%e7%bd%aeroot%e5%af%86%e7%a0%81-2","status":"publish","type":"post","link":"https:\/\/thereisno.top\/?p=261","title":{"rendered":"mysql\u91cd\u7f6eroot\u5bc6\u7801"},"content":{"rendered":"\n

\u82f1\u6587\u539f\u6587\u53c2\u8003\u5730\u5740<\/a><\/p>\n\n\n\n

1\u3001\u68c0\u67e5\u7248\u672c
mysql –version
MySQL output<\/p>\n\n\n\n

mysql Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using EditLine wrapper
Or output like this for MariaDB:<\/p>\n\n\n\n

MariaDB output
mysql Ver 15.1 Distrib 5.5.52-MariaDB, for Linux (x86_64) using readline 5.1<\/p>\n\n\n\n

2\u3001\u505c\u6b62\u670d\u52a1<\/p>\n\n\n\n

MySQL with:
sudosystemctl stop mysql<\/p>\n\n\n\n

MariaDB wtih:
sudosystemctl stop mariadb<\/p>\n\n\n\n

3\u3001\u5f00\u542f\u5b89\u5168\u6a21\u5f0f
sudo mysqld_safe –skip-grant-tables –skip-networking &<\/p>\n\n\n\n

4\u3001\u4f7f\u7528root\u514d\u5bc6\u7801\u767b\u5f55
mysql -uroot<\/p>\n\n\n\n

MySQL prompt
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.
mysql>
MariaDB prompt
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.
MariaDB [(none)]><\/p>\n\n\n\n

5\u3001FLUSH PRIVILEGES;
\u975e\u5e38\u5173\u952e\uff0c\u5fc5\u987b\u5148\u6267\u884c\u8fd9\u4e2a<\/mark>\uff0c\u7136\u540e\u6267\u884c\u540e\u9762\u7684\u8bed\u53e5\u624d\u6709\u6548<\/p>\n\n\n\n

6\u3001\u4fee\u6539\u5bc6\u7801
For MySQL 5.7.6 and newer as well as MariaDB 10.1.20 and newer, use the following command.<\/p>\n\n\n\n

ALTER USER’root’@’localhost’IDENTIFIED BY ‘new_password’;<\/p>\n\n\n\n

For MySQL 5.7.5 and older as well as MariaDB 10.1.20 and older, use:<\/p>\n\n\n\n

SET PASSWORD FOR ‘root’@’localhost’=PASSWORD(‘new_password’);<\/p>\n\n\n\n

\u6216\u8005
UPDATE mysql.user SET authentication_string =PASSWORD(‘new_password’)WHERE User =’root’AND Host =’localhost’;<\/p>\n\n\n\n

7\u3001\u91cd\u542f
For MySQL, use:
sudokillcat\/var\/run\/mysqld\/mysqld.pid<\/code><\/p>\n\n\n\n

For MariaDB, use:
sudokill\/var\/run\/mariadb\/mariadb.pid<\/code><\/p>\n\n\n\n

Then, restart the service using systemctl.<\/p>\n\n\n\n

For MySQL, use:
sudo systemctl start mysql<\/p>\n\n\n\n

For MariaDB, use:
sudo systemctl start mariadb<\/p>\n","protected":false},"excerpt":{"rendered":"

\u82f1\u6587\u539f\u6587\u53c2\u8003\u5730\u5740 1\u3001\u68c0\u67e5\u7248\u672cmysql –versionMySQL output mysql V … <\/p>\n

\u7ee7\u7eed\u9605\u8bfb\u201cmysql\u91cd\u7f6eroot\u5bc6\u7801\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[68,67],"class_list":["post-261","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql","tag-67"],"_links":{"self":[{"href":"https:\/\/thereisno.top\/index.php?rest_route=\/wp\/v2\/posts\/261","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thereisno.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thereisno.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thereisno.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thereisno.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=261"}],"version-history":[{"count":1,"href":"https:\/\/thereisno.top\/index.php?rest_route=\/wp\/v2\/posts\/261\/revisions"}],"predecessor-version":[{"id":262,"href":"https:\/\/thereisno.top\/index.php?rest_route=\/wp\/v2\/posts\/261\/revisions\/262"}],"wp:attachment":[{"href":"https:\/\/thereisno.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thereisno.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thereisno.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}