¢ª¥Ç¡¼¥¿¥Ù¡¼¥¹´ØÏ¢ #contents *¸ø¼°¥µ¥¤¥È [#sc4b63d6] -[[¸ø¼°¥É¥¥å¥á¥ó¥Æ¡¼¥·¥ç¥ó>https://dev.mysql.com/doc/]] -[[MySQL 5.7 Reference Manual>https://dev.mysql.com/doc/refman/5.7/en/]] *ÆþÌçµ»ö [#s98370f5] -[[¤ï¤«¤é¤Ê¤¤¤Ê¤ê¤ËÍý²ò¤·¤¿¤¤¥Ç¡¼¥¿¥Ù¡¼¥¹¡¡§RDBÊÔ¡§MySQL¡ | SIOS Tech. Lab>https://tech-lab.sios.jp/archives/29702]] 2022.6 -[[MySQL¤Î»È¤¤Êý>https://www.dbonline.jp/mysql/]] -[[MySQL Tutorial 1: Overview, Tables, Queries>http://arachnoid.com/MySQL/]] -[[MySQL¤ò´ðÁ䫤鱿ÍѤޤǿ¼¤¯³Ø¤Ó¤¿¤¤¿Í¤Ë¤ª¤¹¤¹¤á¤Î¥¹¥é¥¤¥É¤Þ¤È¤á8¤Ä >http://it-ch.net/t/11]] 2012.7.25 *´ðÁÃÃμ± [#t196031f] -¥æ¡¼¥¶ºîÀ®¤Ç¡¢@°Ê²¼¤Î¥Û¥¹¥È̾¤¬°ã¤¦¤È°Û¤Ê¤ë¥æ¡¼¥¶¤È¤·¤Æ°·¤ï¤ì¤ë¡£ -mysql¥¯¥é¥¤¥¢¥ó¥È¤«¤éÆþÎϤ¹¤ë¥³¥Þ¥ó¥É¤Ï¡¢´ðËܤÏÂçʸ»ú/¾®Ê¸»ú¤Ï¶èÊ̤·¤Ê¤¤¡£Ã¢¤·¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾¤Î¤ß¤ÏLinux´Ä¶¤Ç¤ÏÂçʸ»ú/¾®Ê¸»ú¤Ï¶èÊ̤µ¤ì¤ë¡£ -mysql¥¯¥é¥¤¥¢¥ó¥È¤«¤é¤Î¥³¥Þ¥ó¥É¤Ç¡¢ºÇ¸å¤Ë;¤Ç½ª¤ï¤ë¤â¤Î¤ÏSQL¡¢¤Ê¤¤¤â¤Î¤Ïmysql¤ËÂФ¹¤ë¥³¥Þ¥ó¥É¡£ -¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î³ÊǼÀè¤Ï¥Ç¥Õ¥©¥ë¥È¤Ç¤Ï/var/lib/mysql/¡£/etc/mysql/mysql.conf.d/mysqld.cnf¤Îdatadir¤Ë»ØÄꤷ¤Æ¤¢¤ë¡£ -³°Éô¥Û¥¹¥È¤«¤éµö²Ä¤¹¤ë¤Î¤Ëbind-address¤Îµ½Ò¤Ï¥¢¥É¥ì¥¹¤Î¤ß¤Ç¡¢192.168.1.*¤Î¤è¤¦¤Ê¥Í¥Ã¥È¥ï¡¼¥¯¥¢¥É¥ì¥¹¤Ï»ØÄê¤Ç¤¤Ê¤¤¡£ *DDL¡¢¥¹¥¡¼¥ÞºîÀ® [#b8355f63] -username@ ¤Î¸å¤Î¥Û¥¹¥È̾¤Ë¥ï¥¤¥ë¥É¥«¡¼¥É¤ò»È¤¨¤ë --¥Û¥¹¥È̾¤Ë¤Ï¥ï¥¤¥ë¥É¥«¡¼¥É¤Ç¤¢¤ë '_' ¤È '%' ¤¬»ÈÍѤǤ¤Þ¤¹¡£ --'_'¤ÏǤ°Õ¤Î°ìʸ»ú¤òɽ¤·'%'¤ÏǤ°Õ¤ÎŤµ¤Îʸ»úÎó¤Ë°ìÃפ·¤Þ¤¹¡£(¥æ¡¼¥¶¡¼Ì¾¤Ç¤Ï¥ï¥¤¥ë¥É¥«¡¼¥É¤ò»ÈÍѤǤ¤Þ¤»¤ó)¡£ -[[MySQL¤ÎÆüÉÕ·¿¤Î°·¤¤Êý¤äµ¡Ç½¤ò¤Þ¤È¤á¤Æ¤ß¤Þ¤·¤¿ >http://tech-blog.tsukaby.com/archives/179]] 2013 *¾õÂÖ¤òÃΤëSQL [#j19898f4] -¥æ¡¼¥¶¤ò¥ê¥¹¥È¤¹¤ë select user, host from mysql.user; +------------------+-----------+ | user | host | +------------------+-----------+ | wordpress | % | | mysql.infoschema | localhost | | mysql.session | localhost | | mysql.sys | localhost | | root | localhost | +------------------+-----------+ 5 rows in set (0.00 sec) -¥Æ¡¼¥Ö¥ë¤ò¥ê¥¹¥È¤¹¤ë¡Êhttps://uxmilk.jp/12296¡Ë MySQL [(none)]> show tables from wordpress; +-----------------------+ | Tables_in_wordpress | +-----------------------+ | wp_commentmeta | | wp_comments | | wp_links | | wp_options | | wp_postmeta | | wp_posts | | wp_term_relationships | | wp_term_taxonomy | | wp_termmeta | | wp_terms | | wp_usermeta | | wp_users | +-----------------------+ 12 rows in set (0.01 sec) -¥Æ¡¼¥Ö¥ë¤ÎDDL¤òɽ¼¨¤µ¤»¤ë show create table <table̾> -[[MySQL¤Ç¥æ¡¼¥¶¡¼°ìÍ÷¤ò¼èÆÀ¤¹¤ëÊýË¡ ¸¢¸Â¤È¥Ñ¥¹¥ï¡¼¥É°ìÍ÷¤â¼èÆÀ¡ª>https://www.sejuku.net/blog/81974]] 2018.12 --¥Æ¡¼¥Ö¥ë¤Î¥«¥é¥àɽ¼¨ SHOW COLUMNS FROM <table>; --¥æ¡¼¥¶¤Î¸¢¸Â°ìÍ÷ SHOW GRANTS FOR <user>@<host>; *Tips [#f8bc018e] -[[MySQL8.0¤Ç¤ÏGRANT¤Ç¥æ¡¼¥¶ÅÐÏ¿¤¬¤Ç¤¤Ê¤«¤Ã¤¿ÏÃ>https://qiita.com/tech31/items/e40a3e73c237c97f94f1]] 2019 -[[Node.js¤ÎMySQL¤ÇAsync/Await¤¹¤ëÊýË¡>https://qiita.com/reon777/items/d3781e40ba518a6544f8]] 2018.5 -[[MySQL¤ÎCollation¤òÍý²ò¤¹¤ë¤¿¤á¤Ë¤Þ¤È¤á¤Æ¤ß¤¿¡£>http://blog.6vox.com/2014/05/mysqlcollatoin.html]] 2014 -[[¥Æ¥¥¹¥È¥Õ¥¡¥¤¥ë¤«¤é SQL ¥¹¥Æ¡¼¥È¥á¥ó¥È¤ò¼Â¹Ô¤¹¤ë(¸ø¼°)>https://dev.mysql.com/doc/refman/5.6/ja/mysql-batch-commands.html]] -[[mysqldump¤ÇÆÃÄê¤Î¥ì¥³¡¼¥É¤À¤±¥¨¥¯¥¹¥Ý¡¼¥È¤¹¤ë>https://journal.lampetty.net/entry/mysqldump-option-where]] 2016.12 -[[DeNA¤Ë¤è¤ëÂ絬ÌϤÊMySQL¥Î¥ó¥¹¥È¥Ã¥×±¿ÍѤÎ΢¦¤Ë¤¢¤ë¡¢¥Õ¥§¥¤¥ë¥ª¡¼¥Ð¡¼¼«Æ°²½¥Ä¡¼¥ë>http://www.publickey1.jp/blog/11/denamysql.html]] 2011.4.15 -[[MySQL´ÉÍý¼ÔºÇ®¥Þ¥¹¥¿¡¼>http://nippondanji.blogspot.com/2010/02/mysql.html]] 2010.2.5 -[[MySQL¤ËÅ»¤ï¤ë10¤ÎÅÔ»ÔÅÁÀâ>http://nippondanji.blogspot.com/2009/12/mysql10.html]] 2009.12.18 -[[MySQL InnoDB¤À¤±¤ÇÁ´Ê¸¸¡º÷>http://d.hatena.ne.jp/sh2/20091206]] 2009.12.6 --Twitter¤Î¥Ç¡¼¥¿¤òžÃÖ¥¤¥ó¥Ç¥Ã¥¯¥¹¤Ç¸¡º÷ -[[MySQL¤ÎEXPLAIN¤òÅ°Äì²òÀâ>http://nippondanji.blogspot.com/2009/03/mysqlexplain.html]] -[[¤Ê¤¼MySQL¤Î¥µ¥Ö¥¯¥¨¥ê¤ÏÃÙ¤¤¤Î¤«>http://nippondanji.blogspot.com/2009/03/mysql_25.html]] --·ëÏÀ¤«¤é¸À¤ª¤¦¡£ÃÙ¤¤¤Î¤Ï2ÈÖÌÜ¡¢DEPENDENT SUBQUERY¤Ç¤¢¤ë¡£DEPENDENT SUBQUERY¤È¤Ï¤¤¤ï¤æ¤ëÁê´Ø¥µ¥Ö¥¯¥¨¥ê¤ËÁêÅö¤¹¤ë¤â¤Î¤Ç¡¢¥µ¥Ö¥¯¥¨¥ê¤Ë¤ª¤¤¤Æ³°Éô¥¯¥¨¥ê¤Î¥«¥é¥à¤ò»²¾È¤·¤Æ¤¤¤ë¥µ¥Ö¥¯¥¨¥ê¤Î¤³¤È¤Ç¤¢¤ë¡£¤½¤·¤Æ¡¢ MySQL¤Î¥ª¥×¥Æ¥£¥Þ¥¤¥¶¤Ï¤¿¤Ó¤¿¤ÓÁê´Ø´Ø·¸¤Î¤Ê¤¤¤â¤Î¡¢¤Ä¤Þ¤êËÜÍè¤ÏSUBQUERY¤ÈʬÎव¤ì¤ë¤Ù¤¤â¤Î¤òDEPENDENT SUBQUERY¤Ç¤¢¤ë¤ÈȽÃǤ·¤Æ¤·¤Þ¤¦¡£¤½¤Î¤¿¤á¡¢Â¿¤¯¤Î¾ì¹ç¤Ë¤ª¤¤¤Æ¥µ¥Ö¥¯¥¨¥ê¤¬ÃÙ¤¯¤Ê¤Ã¤Æ¤·¤Þ¤¦¤Î¤Ç¤¢¤ë¡£ -[[MySQL¤ÇOracle¤ÎROWNUM>http://code.nanigac.com/source/view/88]] *´ØÏ¢¥Ä¡¼¥ë [#ob21c660] -[[MySQL Workbench>https://www.mysql.com/jp/products/workbench/]] ¸ø¼°¥Ä¡¼¥ë -[[¥Ö¥é¥¦¥¶¤«¤é²÷Ŭ¤Ë»È¤¨¤ëMySQL´ÉÍý¥Ä¡¼¥ë¡ØSQL Buddy¡Ù¤ò»î¤·¤Æ¤ß¤¿>http://www.ideaxidea.com/archives/2008/08/mysqlsql_buddy.html]] -https://www.heidisql.com/ --Àܳ»þ¤Ë 10061 ¥¨¥é¡¼¤Ë¤Ê¤Ã¤¿¤é¢ª hosts.allow ¤Çµö²Ä¤¹¤ë --Àܳ»þ¤Ë ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 102¢ªmysql.cnf¤Çµö²ÄÀßÄê $ sudo -e /etc/mysql/mysql.conf.d/mysqld.cnf #bind-address = 172.0.0.1 ¡ã¥³¥á¥ó¥È¥¢¥¦¥È¤¹¤ë --»²¹Í¡§https://qiita.com/hachiya/items/a496cd2ec4ac3be4ea84 -https://www.phpmyadmin.net/ *¥¤¥ó¥¹¥È¡¼¥ë [#qd8b1421] -[[MySQL¤Îǧ¾Ú¥×¥é¥°¥¤¥ó¤òÊѹ¹¤¹¤ëÊýË¡(caching_sha2_password)>https://qiita.com/shungo_m/items/5363c16b698ef6310014]] 2021.9 --°Ê²¼¤Î¤è¤¦¤Ê¥¨¥é¡¼¤¬½Ð¤¿¾ì¹ç¤ÎÂбþ ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory -[[Ubuntu¤Çmysql-server¤ò´°Á´¤Ëºï½ü¤¹¤ëÊýË¡>https://a-zumi.net/ubuntu-mysql-server-purge/]] -[[¡ÚUbuntu 18.04 LTS Server¡ÛMySQL¥µ¡¼¥Ð¤òÆ°¤«¤¹ >https://www.yokoweb.net/2018/05/13/ubuntu-18_04-server-mysql/]] 2019.5 -¼«Æ°µ¯Æ°¤¹¤ë¤è¤¦¤ËÀßÄê sudo chkconfig mysqld on