- Äɲ䵤줿¹Ô¤Ï¤³¤Î¿§¤Ç¤¹¡£
- ºï½ü¤µ¤ì¤¿¹Ô¤Ï¤³¤Î¿§¤Ç¤¹¡£
#author("2023-08-30T16:35:20+09:00","default:irrp","irrp")
¢ª¥Ç¡¼¥¿¥Ù¡¼¥¹´ØÏ¢
#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
-[[¤ï¤«¤é¤Ê¤¤¤Ê¤ê¤ËÍý²ò¤·¤¿¤¤¥Ç¡¼¥¿¥Ù¡¼¥¹?¡§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]
-[[MySQL ¤Î¥¤¥ó¥Ç¥Ã¥¯¥¹¤È EXPLAIN ¤Î¼ÒÆâ¹Ö½¬²ñ¤·¤Þ¤·¤¿¡ª¡Ãµ»½Ñ¥Ö¥í¥°¡ÃË̳¤Æ»»¥ËÚ»Ô¡¦µÜ¾ë¸©ÀçÂæ»Ô¤ÎVR¡¦¥²¡¼¥à¡¦¥·¥¹¥Æ¥à³«È¯ ¥¤¥ó¥Õ¥£¥Ë¥Ã¥È¥ë¡¼¥×>https://www.infiniteloop.co.jp/tech-blog/2023/08/learning-mysql-index-explain/]] 2023.8
-[[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