[B! mysql] kiyo_hikoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kiyo_hiko id:kiyo_hiko

mysqlã«é–¢ã™ã‚‹kiyo_hikoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (98)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Oracleã€ã€ŒMySQL Shell for VS Codeã€ã‚’ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼å…¬é–‹ï¼ã€ŒMySQLã€ã®é–‹ç™ºãƒ»ç®¡ç†ã‚·ã‚§ãƒ«ã€ŒMySQL Shellã€ã‚’ã€ŒVisual Studio Codeã€ã§ç›´æŽ¥æ‰±ãˆã‚‹
kiyo_hiko 2022/03/26
mysql
ãƒªãƒ³ã‚¯
ansible answers to mysql_secure_installation
kiyo_hiko 2019/05/27
mysql_secure_installationç›¸å½“ã®playbookä½œã£ã¡ã‚ƒãˆã§ã™ã£ã¦

ansible

mysql

mariadb
ãƒªãƒ³ã‚¯
MySQLÂ 8.0ã¯ä½•ãŒå„ªã‚Œã¦ã„ã¦ã€ã©ã“ã«æ³¨æ„ã™ã¹ãã‹ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚é–€å®¶ãŒæ–°æ©Ÿèƒ½ã‚’å¾¹åº•è§£èª¬ - ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢Hubï½œWebã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ã‚ãƒ£ãƒªã‚¢ã‚’è€ƒãˆã‚‹ï¼
MySQLÂ 8.0ã¯ä½•ãŒå„ªã‚Œã¦ã„ã¦ã€ã©ã“ã«æ³¨æ„ã™ã¹ãã‹ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚é–€å®¶ãŒæ–°æ©Ÿèƒ½ã‚’å¾¹åº•è§£èª¬ MySQLã®æœ€æ–°ç‰ˆã€ŒMySQLÂ 8.0ã€æ£å¼ç‰ˆãŒ2018å¹´4æœˆã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚æ•°å¤šãã®æ©Ÿèƒ½ã‚„è¨å®šãŒè¿½åŠ ãƒ»å¤‰æ›´ã•ã‚Œã¦ã„ã‚‹MySQLÂ 8.0ã®ã€ŒçŸ¥ã£ã¦ãŠããŸã„ä¾¿åˆ©ãªæ©Ÿèƒ½ã€ã‚„ã€Œå±é™ºãªãƒãƒžã‚Šã©ã“ã‚ã€ãªã©ã‚’ã€MyÂ SQLã®å°‚é–€å®¶ã«æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ 2018å¹´4æœˆã€ä¸–ç•Œä¸ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒå¾…ã¡ã«å¾…ã£ãŸMySQL 8.0ã®æ£å¼ç‰ˆãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚æœ¬ãƒªãƒªãƒ¼ã‚¹ã«ä¼´ã„ã€æ•°å¤šãã®æ©Ÿèƒ½ã‚„è¨å®šãŒè¿½åŠ ãƒ»å¤‰æ›´ã•ã‚Œã¦ãŠã‚Šã€MySQLãŒã‚ˆã‚Šä¾¿åˆ©ãªã‚‚ã®ã¸ã¨é€²åŒ–ã—ã¦ã„ã¾ã™ã€‚ MySQL 8.0ã§ç©æ¥µçš„ã«åˆ©ç”¨ã™ã¹ãç›®çŽ‰æ©Ÿèƒ½ã‚„ã€çŸ¥ã£ã¦ãŠã‹ãªã‘ã‚Œã°å±é™ºãªãƒãƒžã‚Šã©ã“ã‚ãªã©é‡è¦ãªå¤‰æ›´ç‚¹ã‚’ã€MySQLã®ä¿å®ˆã‚µãƒãƒ¼ãƒˆã‚„ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãªã©ã‚’å°‚é–€ã¨ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ãƒžãƒ¼ãƒˆã‚¹ã‚¿ã‚¤ãƒ«ã®ä¸é‡ŽçœŸä¹Ÿã•ã‚“ã¨æˆç”°å„ªéš†ã•ã‚“ã«è§£èª¬ã—ã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ ä¸é‡ŽçœŸä¹Ÿï¼ˆãª
kiyo_hiko 2018/11/26
CTEã‚ˆã•ãã†

mysql

8

json
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
kiyo_hiko 2018/05/07
mysql

ansible

setup
ãƒªãƒ³ã‚¯
Ansible ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« (MySQL 5.6) - Qiita
ä»Šå›žã¯ MySQL 5.6 ã‚’ Ansible ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯å¿…é ˆã¨ãªã‚‹ DBMS ã¨ã—ã¦åˆ©ç”¨ã™ã‚‹æ©Ÿä¼šã¯å¤šã„ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¯æœ€æ–°ç‰ˆã® 5.7 ã§ã¯ãªã 5.6 ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ ç’°å¢ƒ CentOS 6.7 ansible 2.0 â€»é–‹ç™ºç’°å¢ƒåˆ©ç”¨ã®ç‚ºã€iptables / SELinux ã«ã¤ã„ã¦ã¯äº‹å‰ã«ç„¡åŠ¹åŒ–ã—ã¦ãŠã‚Šã¾ã™ã€‚ â€»yum ã§ "Developer tools" ã‚°ãƒ«ãƒ¼ãƒ—ã‚’ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã€å¿…è¦ãªã‚³ãƒžãƒ³ãƒ‰ã¯é©å®œå°Žå…¥ã—ã¦ã„ã¾ã™ã€‚ Playbook ã®è¨˜è¿° Playbook ã¯ Role æ§‹é€ ã§è¨˜è¿°ã—ã¾ã™ã€‚ Role ä½œæˆæ–¹æ³•ã«ã¤ã„ã¦ã¯ ã“ã¡ã‚‰ ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ æ§‹æˆã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ . â”œâ”€â”€ group_vars â”‚ â””â”€â”€ dbservers # å„ã‚¿ã‚¹ã‚¯ã§ä½¿ç”¨ã™ã‚‹å¤‰æ•°å®šç¾© â”œâ”€â”€ hosts â”œâ”€â”€ rol
kiyo_hiko 2017/11/30
ansible

mysql
ãƒªãƒ³ã‚¯
MySQL Workbenchã§ã®ã‚°ãƒªãƒƒãƒ‰ã«Nullã‚’ã‚»ãƒƒãƒˆã™ã‚‹æ–¹æ³•
MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’æ“ä½œã™ã‚‹ã«ã¯MySQLã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã‚‹ç„¡å„Ÿãƒ„ãƒ¼ãƒ«ã€ŒMySQL Workbenchã€ã‚’ä½¿ã†ã¨ä¾¿åˆ©ã§ã™ã€‚ SQLã‚’çŸ¥ã‚‰ãªãã¦ã‚‚ã‚°ãƒªãƒƒãƒ‰ã‹ã‚‰è¡¨ç¤ºã—ã¦ä¿®æ£ãªã©ã€ã‚ã–ã‚ã–SQLã‚’è¨˜è¼‰ã—ãªãã¦ã‚‚è‰¯ã„ã¨ã“ã‚ãŒã„ã„ã§ã™ã€‚ ãã®Workbenchãƒ„ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã—ã¦ã¦ã€ã‚°ãƒªãƒƒãƒ‰ã§ã€ã¨ã‚ã‚‹ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«nullã‚’ä»£å…¥ã—ãŸã‹ã£ãŸã®ã§ã™ãŒã€ã©ã†ã‚„ã£ãŸã‚‰ã‚ˆã„ã‹ãƒãƒžã£ã¦ã—ã¾ã£ãŸã®ã§ãƒ¡ãƒ¢ã¨ã—ã¦è¨˜è¼‰ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ç›®æ¬¡ å‰ææ¡ä»¶ ã‚°ãƒªãƒƒãƒ‰å¤‰æ›´æ–¹æ³• å‚è€ƒæ–‡çŒ® å‰ææ¡ä»¶ MySQL 5.5.XX MySQL Workbench 5.2.40 Windows XP 32bit ã‚°ãƒªãƒƒãƒ‰å¤‰æ›´æ–¹æ³• ä¾‹ãˆã°ã€ä»¥ä¸‹ã®æ§˜ãªãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ãŒã‚ã£ãŸã¨ã—ã¾ã™ã€‚ CREATE TABLE `test` ( `id` int(11) NOT NULL AUTO_INCREMENT, `hoge` int(11) DEFAUL
kiyo_hiko 2017/10/10
å³ã‚¯ãƒªãƒƒã‚¯ã¨ã‹ç›²ç‚¹ã ã£ãŸã€‚è¨€ã‚ã‚Œã¦ã¿ã‚Œã°ãã†ã„ã‚„ãã†ã‹ã£ã¦ãƒ¬ãƒ™ãƒ«ã®è©±ãªã®ã«ç›²ç‚¹ã ã£ãŸã€‚

mysql

null
ãƒªãƒ³ã‚¯
MySQL 5.7ã§rootãƒ¦ãƒ¼ã‚¶ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å†è¨å®š - Qiita
ä»Šå›žã¯ã€MySQL5.7ã§rootãƒ¦ãƒ¼ã‚¶ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¿˜ã‚Œã¦ã—ã¾ã£ãŸã¨ãã«å†è¨å®šã‚’è¡Œã†æ‰‹é †ãŒã“ã‚Œã¾ã§ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨ã„ãã¤ã‹ç•°ãªã‚‹éƒ¨åˆ†ãŒã‚ã£ãŸã®ã§å‚™å¿˜éŒ²ã¨ã—ã¦æŠ•ç¨¿ã—ã¾ã™ã€‚ ç’°å¢ƒ MySQL ï¼š 5.7.11 CentOS : 7.1 1. MySQLã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰å…¥åŠ›ãªã—ã§ãƒã‚°ã‚¤ãƒ³ã§ãã‚‹ã‚ˆã†è¨å®š ã¯ã˜ã‚ã«ã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰å…¥åŠ›ãªã—ã§MySQLã«ãƒã‚°ã‚¤ãƒ³ã§ãã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰å…¥åŠ›ãªã—ã§ãƒã‚°ã‚¤ãƒ³ã§ãã‚‹ã‚ˆã†ã« /etc/my.cnf ã« skip-grant-tables ã‚’è¿½åŠ ã—ã¾ã™
kiyo_hiko 2017/07/28
rootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰å¿˜ã‚Œã¦ã—ã¾ã„ã€ã¨ã¦ã‚‚ãŸã™ã‹ã£ãŸã€‚

mysql

trouble

forgot

password

reset
ãƒªãƒ³ã‚¯
mysql5.7ã§ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã™ã‚‹ - Qiita
ç’°å¢ƒ CentOS7.1 (Vagrant) MySQL 5.7.13 ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ã“ã£ã¡ å•é¡Œ MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã€$ mysql -uroot -proot ã§å…¥ã‚ã†ã¨ã—ãŸã‚‰ä»¥ä¸‹ã®ã‚¨ãƒ©ãƒ¼ ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) MySQL5.7ã§ã¯åˆæœŸãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ï¼ˆãƒ©ãƒ³ãƒ€ãƒ æ–‡å—åˆ—ï¼‰ãŒç™ºè¡Œã•ã‚Œã¦ã„ã‚‹ã‚‰ã—ã„ã€‚é¢å€’ãã•ã„ã®ã§ã€rootãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’rootã«å¤‰æ›´ã—ãŸã„ã€‚ æ‰‹é † åˆæœŸãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¯/var/log/mysqld.logã«å‡ºåŠ›ã•ã‚Œã¦ã„ã‚‹ã€‚ [vagrant@localhost ~]$ sudo cat /var/log/mysqld.log | grep "temporary password" ... ..temporary passw
kiyo_hiko 2017/07/05
mysql

5

7

setup

password
ãƒªãƒ³ã‚¯
CentOS6ã«MySQL5.7ã‚’yumã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - Qiita
ã¯ã˜ã‚ã« CentOS6ç³»ã®æ¨™æº–ãƒªãƒã‚¸ãƒˆãƒªã®MySQLã¯ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.1ãªã®ã§ ãã‚Œä»¥å¤–ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹ã«ã¯ã€è‡ªåˆ†ã§è©²å½“ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ãƒªãƒã‚¸ãƒˆãƒªã‚’è¿½åŠ ã—ã¦ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ä½œæ¥ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ ã‹ã¤ã¦ã¯Baseãƒªãƒã‚¸ãƒˆãƒªã®mysql-libsãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®ä¾å˜é–¢ä¿‚ã§ ã‚¹ãƒ ãƒ¼ã‚ºã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå‡ºæ¥ãªã‹ã£ãŸã“ã¨ã‚‚ã‚ã‚‹ã‚ˆã†ã§ã™ãŒ 5.7.10ã§ã¯å•é¡Œãªãmysql-libsãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’mysql-community-libs-5.7.10ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã—ã¦ãã‚Œã¾ã—ãŸã€‚ (â€»2016-01-31ç¾åœ¨ã®æƒ…å ±ã§ã™) Yumãƒªãƒã‚¸ãƒˆãƒªè¿½åŠ Yumãƒªãƒã‚¸ãƒˆãƒªãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰URLã¯ä»¥ä¸‹ã§ç¢ºèª (â€»2016-01-31ç¾åœ¨) http://dev.mysql.com/downloads/repo/yum/ ä»¥ä¸‹ã§è¿½åŠ ã™ã‚‹ rpm -Uvh http://dev.mysql.com/get/mysql57-
kiyo_hiko 2017/07/05
centos

6

mysql

setup
ãƒªãƒ³ã‚¯
èª°ã‚‚æ•™ãˆã¦ãã‚Œãªã‹ã£ãŸMySQLã®éšœå®³è§£æžæ–¹æ³• - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
kiyo_hiko 2017/05/19
mysql

trouble
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 13.7.7.10 SHOW CREATE TABLE ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ
SAVEPOINTã€ROLLBACK TO SAVEPOINT ãŠã‚ˆã³ RELEASE SAVEPOINT ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ
kiyo_hiko 2017/05/18
show create table t_name;

mysql

ddl

re
ãƒªãƒ³ã‚¯
mysqlã«sqlãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä¸€æ‹¬ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹æ–¹æ³• | æ€ã„ç«‹ã£ãŸãŒå‰æ—¥
mysqlã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦.sqlã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ãŒã‚ã‚Šã¾ã™ãŒã€ã“ã‚Œã¯ãƒ†ãƒ¼ãƒ–ãƒ«æ¯Žã«ãƒ•ã‚¡ã‚¤ãƒ«ãŒåˆ†ã‹ã‚Œã¦ã„ã‚‹äº‹ãŒå¤šã„ã§ã™ã€‚ ã“ã‚Œã‚’ä¸€æ‹¬ã§ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹æ–¹æ³•ã‚’ä»Šå›žã¯ã”ç´¹ä»‹ã€‚ï¼ˆã”ç´¹ä»‹ã¨ã„ã†ã‹ãƒ¡ãƒ¢æ›¸ãã§ã™ï¼‰ åŸºç¤ŽçŸ¥è˜ ã¾ãšã¯ã€ä¸€æ‹¬ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ãŸã‚ã«çŸ¥ã‚ŠãŸã„äº‹ã§ã™ã€‚ ã©ã†ã‚„ã£ã¦ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ã®ã‹ï¼Ÿ ã‚¹ã‚¯ãƒªãƒ—ãƒˆåŒ–ã§ãã‚‹ã®ã‹ï¼Ÿ ä¸€æ‹¬ã‚¤ãƒ³ãƒãƒ¼ãƒˆã®ã‚³ãƒžãƒ³ãƒ‰ã¨ã‹ã‚ã‚Œã°è‰¯ã„ã‚“ã§ã™ãŒã€è»½ãæ¤œç´¢ã—ãŸé™ã‚Šã§ã¯ä¸€ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ã‹è¦‹ã¤ã‹ã‚‰ãªã‹ã£ãŸã®ã§ã€è¤‡æ•°ãƒ•ã‚¡ã‚¤ãƒ«ã¯bashã‚¹ã‚¯ãƒªãƒ—ãƒˆã§è§£æ±ºã™ã‚‹äº‹ã«ã—ã¾ã™ã€‚ ï¼‘ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹å ´åˆ ã¾ãšã€.sqlãƒ•ã‚¡ã‚¤ãƒ«ä¸€ã¤ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹æ–¹æ³•ã§ã™ã€‚ ã“ã‚Œã§ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ãã¾ã™ã€‚ã—ã‹ã—ã€ã“ã‚Œã§ã¯æ¯Žå›žãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰å…¥åŠ›ã‚’æ±‚ã‚ã‚‰ã‚Œã¾ã™ã‹ã‚‰ã€bashã‚¹ã‚¯ãƒªãƒ—ãƒˆã§å¤§é‡ã®.sqlãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡¦ç†ã™ã‚‹ã®ã«ã¯å‘ãã¾ã›ã‚“ã€‚ ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰å…¥åŠ›ã‚’çœç•¥ã™ã‚‹ ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰å…¥åŠ›ã‚’çœç•¥ã™ã‚‹æ–¹æ³•ã¨
kiyo_hiko 2017/04/07
ä¾¿åˆ©ã„

mysql
ãƒªãƒ³ã‚¯
ã€Žã€MySQLã€‘é€£ç•ªã‚’æŒ¯ã‚ŠãªãŠã™ã€
æ„›çŸ¥çœŒä¸€å®®å¸‚ã«ã‚ã‚‹ã®ãŒã€ ã‚ãŸã—ãŸã¡ã®ã€Œæ ªå¼ä¼šç¤¾ã‚¨ã‚¹ãƒ—ãƒªã€ã§ã™ã€‚ ã‚ãŸã—ãŸã¡ã®ä»•äº‹ã¶ã‚Šã ã‘ã§ãªãã€ æ—¥å¸¸ã‚’ã”è¦§ãã ã•ã„ã€‚ MySQLã§ãƒ‡ãƒ¼ã‚¿ã‚’æ•´ç†ã—ãŸã„æ™‚ã«ä¾¿åˆ©ãªSQLã®ãƒ¡ãƒ¢ SET @i := 0; UPDATE ãƒ†ãƒ¼ãƒ–ãƒ«å SET ã‚«ãƒ©ãƒ å = (@i := @i +1); 1è¡Œç›®ã§æŒ‡å®šã—ãŸæ•°å€¤+1ã‹ã‚‰ç•ªå·ãŒæŒ¯ã‚‰ã‚Œã‚‹ã®ã§ã€ä¸Šè¨˜ã®ä¾‹ã§ã¯1ã‹ã‚‰é€£ç•ªãŒæŒ¯ã‚‰ã‚Œã¾ã™ã€‚ UPDATE ãƒ†ãƒ¼ãƒ–ãƒ«å SET ã‚«ãƒ©ãƒ A = (@i := @i +1) ORDER BY ã‚«ãƒ©ãƒ B DESC; ORDERå¥ã‚’ä½¿ç”¨ã—ã¦ä¸¦ã³é †ã‚’æŒ‡å®šã—ã¦é€£ç•ªã‚’æŒ¯ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚
kiyo_hiko 2017/04/05
mysql
ãƒªãƒ³ã‚¯
å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã‚’ä¸€æ™‚çš„ã«ç„¡åŠ¹ã«ã™ã‚‹ - dondari
ç’°å¢ƒ MySQL 5.5ã§ç¢ºèª çµŒç·¯ ãƒ‡ãƒ¼ã‚¿æ“ä½œä¸Šã€å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã‚’ç„¡åŠ¹ã«ã—ãŸã„å ´é¢ãŒã‚ã‚Šã¾ã™ã€‚ ã‚„ã‚‹ã“ã¨ ç„¡åŠ¹ã«ã™ã‚‹ SET FOREIGN_KEY_CHECKS = 0 æœ‰åŠ¹ã«æˆ»ã™ SET FOREIGN_KEY_CHECKS = 1 Tweet
kiyo_hiko 2017/04/05
mysql
ãƒªãƒ³ã‚¯
MySQL ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£/ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ï¼ | QK
ã„ã‚„ãƒ¼ãƒ»ãƒ»ãƒ»æœ¬å½“ã«æƒ…å ±ãŒå°‘ãªãã¦è‹¦åŠ´ã—ãŸã€‚ã¨ã„ã†ã‹ç¾åœ¨é€²è¡Œå½¢ã§è‹¦åŠ´ã—ã¦ã¾ã™ã€‚è¡¨é¡Œã®é€šã‚Šã€MySQLã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£/ã‚¹ãƒˆã‚¢ãƒ‰ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã®ä»¶ãªã®ã§ã™ãŒã€oracleè§¦ã£ã¦ã„ã‚‹ã¨ãã‚‚ã€db2è§¦ã£ã¦ã„ã‚‹ã¨ãã‚‚ã€ã€Œç®¡ç†ãŒè¤‡é›‘ã«ãªã‚‹ã‹ã‚‰ã€ã¨ã‚‚ã£ã¨ã‚‚ã‚‰ã—ã„ã“ã¨ã‚’ã„ã£ã¦é¿ã‘ã¦ã„ãŸé“ãªã‚“ã§ã™ã‘ã©ã€ãªã‚“ã¨ãªãã‚ã‹ã£ãŸã¨ã“ã‚ã§ã€ã€Œã‚ã€ã“ã‚Œçµæ§‹ã¤ã‹ãˆã‚‹ã˜ã‚ƒã‚“ï¼Ÿã€ã¨æ€ã£ã¦ããŸã€‚ã¾ã‚ã€ãŸã—ã‹ã«ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£å´ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã§å‹•ãã‚ã‘ãªã®ã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã®æ¯”é‡ã‚’è€ƒãˆã‚‹å¿…è¦ãŒã‚ã‚‹ã‹ã¨æ€ã†ã‘ã©ã€phpã¨ã§ã‚‚javaã§ã‚‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è¦–ç‚¹ã§è€ƒãˆã¦ã¿ã‚Œã°ã€å°é›£ã—ã„ã“ã¨è€ƒãˆãªãã¦ã‚‚ã‚ˆããªã‚‹ã®ã§ã€ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿æ¸¡ã—ãŸã‚‰æœŸå¾…ã—ãŸçµæžœãŒæˆ»ã‚Œã°ãã‚Œã§è‰¯ã„ã‚ã‘ã§SQLã§ã®éŽç¨‹ãªã‚“ã¦ã©ãƒ¼ã§ã‚‚è‰¯ã„ã‚ã‘ã ã€ã¾ãŸã‚ã‚‹æ„å‘³ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã¨ã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¯åˆ†é›¢ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç´°ã‹ã„è¨ˆç®—ãƒã‚¸ãƒƒã‚¯ã‚’ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—
kiyo_hiko 2017/02/08
mysql

ã‚¹ãƒˆã‚¢ãƒ‰
ãƒªãƒ³ã‚¯
MySQL ä¸€åº¦DELETEã—ãŸuserã¨åŒã˜åå‰ã®userã‚’ç™»éŒ²ã—ã‚ˆã†ã¨ã™ã‚‹ã¨å¤±æ•—ã™ã‚‹ - ã€ã¯ã¦ãªã€‘ã‚¬ãƒƒãƒˆãƒãƒ³ãƒã‚³
ã†ãƒ¼ã‚“ã€‚MySQLã®ãƒã‚°ãªã‚“ã ã‚ã†ã‹ã€ä¸€åº¦DELETEã—ãŸuserã¨åŒã˜åå‰ã®userã‚’ç™»éŒ²ã—ã‚ˆã†ã¨ã™ã‚‹ã¨å¤±æ•—ã™ã‚‹ã€‚ ã‚„ã£ãŸã“ã¨ã¯ã“ã†ã€‚ DELETE æ§‹æ–‡ã§ user 'boss' ã‚’å‰Šé™¤ã™ã‚‹ã€‚ mysql> DELETE FROM mysql.user WHERE user='boss' and host='localhost'; CREATE USER æ§‹æ–‡ã§ boss ã‚’å†åº¦ä½œã‚ã†ã¨ã—ãŸãŒã€å¤±æ•—ã€‚ mysql> CREATE USER 'boss'@'localhost' IDENTIFIED BY 'password'; ERROR 1396 (HY000): Operation CREATE USER failed for 'boss'@'localhost' MySQLã‚¯ã‚¤ãƒƒã‚¯ãƒ»ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«ã‚ˆã‚‹ã¨ã€ æœ¬æ¥ã®ãƒ¦ãƒ¼ã‚¶å‰Šé™¤ã¯ã“ã†ã‚‰ã—ã„ã€‚å…ˆã«REVOKEã‚’ã‚„ã‚‰ãªã‹ã£ãŸã‹ã‚‰ã„ã‘ãªã„ã®
kiyo_hiko 2017/02/02
"flush privileges;"

mysql

account

setup

network
ãƒªãƒ³ã‚¯
rails - Mysql2::Error: Incorrect string value - ãã†ã„ã†ã“ã¨ã ã£ãŸã‚“ã§ã™ã
æ¬¡ã®ã‚¨ãƒ©ãƒ¼ãŒã§ãŸå ´åˆã€‚ Mysql2::Error: Incorrect string value: åŽŸå› ã‚’èª¿ã¹ã‚‹ ãŠãŠã‚€ãã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’ç¢ºèªã™ã‚‹ã€‚ ãŸã„ã¦ã„ latin1 ã¨ã‹ã«ãªã£ã¦ã„ã‚‹ã€‚ $ mysql -uuser -p my_db mysql > show create table posts; CREATE TABLE `posts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `text` text, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAUL
kiyo_hiko 2017/01/23
mysql>show create table TAB_NAME; --latin1ãªã©ã ã¨ã ã‚ // è‡ªåˆ†ã¯ActiveRecordã®ãŸã‚rake db:drop ï¼ž db:create ï¼ž db:migrateã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã§è§£æ±º

mysql

trouble

encoding

table
ãƒªãƒ³ã‚¯
Mysql2::Error: Incorrect string value: ãªã‚¨ãƒ©ãƒ¼ã®è§£æ±ºæ–¹æ³• - Fish And Tips
2014 - 07 - 27 Mysql2::Error: Incorrect string value: ãªã‚¨ãƒ©ãƒ¼ã®è§£æ±ºæ–¹æ³• DBã«ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã—ã‚ˆã†ã¨ã—ãŸã‚‰ ã€ŒMysql2:: Error : Incorrect string value: ã€ ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãŒâ€¦ã€‚ ã©ã†ã‚„ã‚‰ æ–‡å—ã‚³ãƒ¼ãƒ‰ ãŒå•é¡Œã‚‰ã—ã„ã€‚ mysql> show variables like 'character_set%'; ã‚ã‚‹ã„ã¯ mysql> status ã§ æ–‡å—ã‚³ãƒ¼ãƒ‰ ã‚’ç¢ºèªã™ã‚‹ã¨ã€ ç¢ºã‹ã«utf8ã§ãªã„ã¨ã„ã‘ãªã„ã¨ã“ã‚ãŒlatin1ã ã£ãŸã€‚ Sæ°ã¯ãŸã¾ã«ãƒ–ãƒã‚°ã‚’æ›´æ–°ã—ã¦ã¾ã™ã€‚in blogspot: mysqlã§æ—¥æœ¬èªžæŒ¿å…¥ã§ããªã„ ã“ã¡ã‚‰ã‚’å‚è€ƒã«ã—ãªãŒã‚‰/etc/my.cnfã‚’ä¿®æ£ã—ã¦å†èµ·å‹•ã—ãŸã®ã ãŒã€ç›´ã‚‰ãšâ€¦ã€‚ ç›´ã‚‰ãªã„ã¨ã„ã†ã‹DBã®å†èµ·å‹•ãŒå‡ºæ¥ãªã„ã€‚ ã“ã“ã§ AWS ã®RDSã‚’ä½¿ã£ã¦ã„ãŸã“ã¨ã‚’æ€ã„
kiyo_hiko 2017/01/20
mysql

trouble
ãƒªãƒ³ã‚¯
ã€ŒPHP MySQLãƒžã‚¹ã‚¿ãƒ¼ãƒ–ãƒƒã‚¯ã€èªã‚“ã æ„Ÿæƒ³ - 1981å¹´ç”Ÿã¾ã‚Œã®å…ƒçŠ¯ç½ªè€…äºˆå‚™è»ç„¡è·ã®è£ã‚‚è¡¨ã‚‚ãªã„æ—¥è¨˜
PHP æœ¬ã‚·ãƒªãƒ¼ã‚ºç¬¬3å¼¾ï¼ï¼PHP MySQLãƒžã‚¹ã‚¿ãƒ¼ãƒ–ãƒƒã‚¯èªã‚“ã§ã¿ãŸã€‚ ã“ã®æœ¬ã¯ã€ã‚¢ãƒžã‚¾ãƒ³ã®ãƒ¬ãƒ“ãƒ¥ãƒ¼ã«ã‚‚ã‚ã‚‹ã‚ˆã†ã«ä»¥å‰ã€åˆ¥ã®ã‚¿ã‚¤ãƒˆãƒ«ã§å‡ºç‰ˆã•ã‚Œã¦ã„ãŸæœ¬ãŒã€ã‚¿ã‚¤ãƒˆãƒ«ã ã‘å¤‰ãˆã¦å‡ºç‰ˆã•ã‚ŒãŸæœ¬ã‚‰ã—ã„ã®ã§ã€è³¼å…¥æ™‚ã«ã¯æ³¨æ„ã—ã¦ã„ãŸã ããŸã„ã€‚ å…¨ç·¨æŒ¿çµµç„¡ã—ã®ã²ãŸã™ã‚‰æ–‡å—ã¨ã‚³ãƒ¼ãƒ‰ã®ã¿ã€ èªç ´ã™ã‚‹ã«ã¯ã€ã¨ã¦ã‚‚æ ¹æ€§ãŒã„ã‚‹æœ¬ã§ã—ãŸã€‚ ã—ã‹ã—èªã¿çµ‚ã‚ã£ã¦ã¿ã‚‹ã¨è‡ªåˆ†ã®ãƒ¬ãƒ™ãƒ«ãŒ 2ãƒ¬ãƒ™ãƒ«ãã‚‰ã„ä¸ŠãŒã£ãŸã‚ˆã†ãªæ°—ã«ãªã‚‹ã€‚ ã“ã®æœ¬ã®è‰¯ã„ã¨ã“ã‚ã¯ã€MySQLæŽ¥ç¶šãŒPDOã§è§£èª¬ã•ã‚Œã¦ã„ã‚‹ã¨ã“ã‚ã ã¨æ€ã†ã€‚ PDOæŽ¥ç¶šã§ã“ã®ãã‚‰ã„ä¸å¯§ã«è§£èª¬ã•ã‚Œã¦ã„ã‚‹æœ¬ã¯ã€ä»Šã®ã¨ã“ã‚è¦‹ãŸã“ã¨ãŒãªã„ã€‚ æœ¬+å‹•ç”»ã§ãŠå‹‰å¼· ã“ã®æœ¬ã‚’èªã‚“ã§ã‹ã‚‰ã€ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«PHPãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¥é–€ã®å‹•ç”»ã‚’è¦³ã‚‹ã¨ã‚ˆã‚Šç†è§£ãŒæ·±ã¾ã‚‹ã€‚ â€»ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«é–¢ã—ã¦æ³¨æ„ã™ã‚‹ã“ã¨ãŒä¸€ç‚¹ã€ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚‚é…ä¿¡ã•ã‚Œã¦ã„ã‚‹ã®ã ãŒã€ã“ã‚Œã‚’è¦‹ã‚‹ãŸã‚ã«ã¯æœˆé¡980å††ã®æœ‰æ–™ä¼šå“¡ã«ãªã‚‰ãªã„ã¨ã„ã‘
kiyo_hiko 2016/07/18
book

review

php

mysql
ãƒªãƒ³ã‚¯
MySQLãŠã˜ã•ã‚“ã®é€†è¥²
17. MySQLã®â½´ã¡ä½ç½® app, browser app, browser app, browser app, browser app, browser app, browser WEB, AP WEB, AP WEB, AP WEB, AP WEB, AP WEB, AP Database 16/136 18. ã“ã“ãª app, browser app, browser app, browser app, browser app, browser app, browser WEB, AP WEB, AP WEB, AP WEB, AP WEB, AP WEB, AP Database 17/136 19. WEBã‚µãƒ¼ãƒãƒ¼ã¨ã®å¯¾â½ app, browser app, browser app, browser app, browser app, browser app, browser
kiyo_hiko 2016/06/10
mysql
ãƒªãƒ³ã‚¯
1 2 3 4 5 æ¬¡ã®ãƒšãƒ¼ã‚¸