{"id":4663,"date":"2019-12-12T08:20:50","date_gmt":"2019-12-11T23:20:50","guid":{"rendered":"http:\/\/saj-fs.com\/?page_id=4663"},"modified":"2020-04-16T13:57:55","modified_gmt":"2020-04-16T04:57:55","slug":"mysql%e3%82%b5%e3%83%bc%e3%83%90%e3%83%bc%e3%81%8c%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%81%a7%e3%81%8d%e3%81%aa%e3%81%84%e5%a0%b4%e5%90%88","status":"publish","type":"page","link":"https:\/\/saj-fs.com\/?page_id=4663","title":{"rendered":"MySQL\u30b5\u30fc\u30d0\u30fc\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u306a\u3044\u5834\u5408"},"content":{"rendered":"

zip\u304b\u3089\u306eMySQL\u30b5\u30fc\u30d0\u30fc\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n

MySQL\u30b5\u30fc\u30d0\u30fc\u3092DL\u3059\u308b<\/h3>\n

mysql 5.7.20\u3092DL\u3059\u308b
\nProduct Version:5.7.20<\/span>
\nOperating System:MicrosoftWindows<\/span>
\nOS Version:Windows(x86,64-bit)<\/span>
\nZIP Archive\u306eDownload\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b
\nhttps:\/\/downloads.mysql.com\/archives\/community\/<\/a><\/code><\/p>\n

\u89e3\u51cd\u3057\u3066\u8a2d\u7f6e\u3059\u308b<\/h3>\n

C:\/xamp\/mysql5720<\/code><\/p>\n

MySQL\u30b5\u30fc\u30d0\u30fc\uff08mysqld.exe\uff09\u3092\u521d\u671f\u5316\u3059\u308b<\/h3>\n

bin\u3078\u79fb\u52d5\u3059\u308b
\nmysqld.exe --defaults-file=my.ini --initialize --console<\/code><\/span><\/em><\/p>\n

my.ini\u306e\u4e2d\u8eab<\/h3>\n

my.ini\u3092bin\u30d5\u30a9\u30eb\u30c0\u914d\u4e0b\u306b\u4f5c\u6210\u3059\u308b\u3002\u5185\u5bb9\u306f\u4ee5\u4e0b\u3092\u30b3\u30d4\u30da\u3067\u5927\u4e08\u592b\u3002
\n[client]
\npassword = root
\nport = 3306
\nsocket = \"C:\/xamp\/mysql5720\/mysql.sock\"
\n# The MySQL server
\n[mysqld]
\nport= 3306
\nsocket = \"C:\/xamp\/mysql5720\/mysql.sock\"
\nbasedir = \"C:\/xamp\/mysql5720\"
\ntmpdir = \"C:\/xamp\/tmp\"
\ndatadir = \"C:\/xamp\/mysql5720\/data\"
\ninnodb_flush_method=normal<\/code><\/p>\n

\u521d\u671f\u5316\u304c\u7d42\u308f\u308b\u3068\u521d\u671f\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u767a\u884c\u3055\u308c\u308b<\/h3>\n

C:\\xamp\\mysql5720\\bin>mysqld.exe --defaults-file=my.ini --initialize --console<\/em><\/span>
\n[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
\n[Warning] InnoDB: New log files created, LSN=45790
\n[Warning] InnoDB: Creating foreign key constraint system tables.
\n[Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 99010da8-7a1c-11ea-be34-38f9d3365851.
\n[Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
\n[Note] A temporary password is generated for root@localhost: ocqFh6a*#c*z<\/span><\/code><\/p>\n

\u521d\u671f\u5316\u30aa\u30d7\u30b7\u30e7\u30f3\u306a\u3057\u3067MySQL\u30b5\u30fc\u30d0\u30fc\u3092\u8d77\u52d5\u3059\u308b<\/h3>\n

C:\\xamp\\mysql5720\\bin>mysqld.exe --defaults-file=my.ini --console<\/span><\/em><\/code><\/p>\n

\u5225\u306e\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u304b\u3089MySQL\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\uff08mysql.exe\uff09\u3092\u8d77\u52d5\u3059\u308b<\/h3>\n

C:\\Users\\ganas\\Documents\\dumps\\Dump20200407>\\xamp\\mysql5720\\bin\\mysql -u root -p<\/span><\/em>
\nEnter password: ************
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 4
\nServer version: 5.7.20<\/code><\/p>\n

Copyright (c) 2000, 2017, Oracle and\/or its affiliates. All rights reserved.<\/p>\n

Oracle is a registered trademark of Oracle Corporation and\/or its
\naffiliates. Other names may be trademarks of their respective
\nowners.<\/p>\n

Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n

mysql> show grants;<\/span><\/em>
\nERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.<\/span><\/p>\n

root\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u5909\u66f4\u3092\u4fc3\u3055\u308c\u308b\u306e\u3067\u5909\u66f4\u3059\u308b<\/h3>\n

mysql> set password for root@localhost=password('root');<\/span><\/em><\/code><\/p>\n

\u65e2\u51fa\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u30fc\u3067\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u306e\u30c8\u30e9\u30d6\u30eb\uff1f<\/h2>\n

xamp\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u308b\u3068mysql-installer-web-community-5.6.45.0.msi\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d\u306b\u9014\u4e2d\u3067\u300cstarting the server\u300d\u3067\u9577\u3044\u6642\u9593\u6b62\u307e\u3063\u3066\u3057\u307e\u3046\u3002xamp\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u308b\u5834\u5408\u306b\u767a\u751f\u3059\u308b\uff1f<\/p>\n

root\u306e\u8a2d\u5b9a<\/h2>\n
    \n
  1. create database mogul;<\/li>\n
  2. grant all on mogul.* to ‘root’@’127.0.0.1’ identified by ‘root’;<\/li>\n
  3. grant all on mogul.* to ‘root’@’localhost’ identified by ‘root’;<\/li>\n
  4. select User, Password, host from user ;<\/li>\n
  5. FLUSH PRIVILEGES;<\/li>\n<\/ol>\n

    MySQL Server 8\u306e\u5834\u5408<\/h2>\n

    MySQL5.7\u307e\u3067\u306e\u8a8d\u8a3c\u30d7\u30e9\u30b0\u30a4\u30f3\u306f \u300cmysql_native_password\u300d\u304c\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u4f7f\u7528\u3055\u308c\u3066\u3044\u305f\u3002MySQL8.0\u304b\u3089\u306f\u65b0\u305f\u306b\u8ffd\u52a0\u3055\u308c\u305f\u300ccaching_sha2_password\u300d\u306b\u5909\u66f4\u3055\u308c\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

    zip\u304b\u3089\u306eMySQL\u30b5\u30fc\u30d0\u30fc\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb MySQL\u30b5\u30fc\u30d0\u30fc\u3092DL\u3059\u308b mysql 5.7.20\u3092DL\u3059\u308b Product Version:5.7.20 Operating System:MicrosoftWindo \u7d9a\u304d\u3092\u8aad\u3080 MySQL\u30b5\u30fc\u30d0\u30fc\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u306a\u3044\u5834\u5408<\/span>→<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-4663","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/saj-fs.com\/index.php?rest_route=\/wp\/v2\/pages\/4663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saj-fs.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/saj-fs.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/saj-fs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/saj-fs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4663"}],"version-history":[{"count":8,"href":"https:\/\/saj-fs.com\/index.php?rest_route=\/wp\/v2\/pages\/4663\/revisions"}],"predecessor-version":[{"id":4756,"href":"https:\/\/saj-fs.com\/index.php?rest_route=\/wp\/v2\/pages\/4663\/revisions\/4756"}],"wp:attachment":[{"href":"https:\/\/saj-fs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}