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

grover id:grover

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

${{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}}

MySQL|MariaDBã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã®ã€ŒAccess denied for user 'root'@'localhost'ã€ã®ä»¶
åŒã˜ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ã„ãªã„äº‹ã‚’ç¢ºã‹ã‚ã‚‹ç‚ºã«ã€exitã‹quitã§mysqlã‚’çµ‚äº†ã•ã›ã‚‹ã€‚ å¯èƒ½ãªã‚‰rootã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰å¤‰æ›´ã§ã¯ãªãã€åˆ¥ã®ä¸€èˆ¬ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’æ–°è¦ä½œæˆã—ãŸã»ã†ãŒæœ›ã¾ã—ã„ã€‚ æ¬¡å›žã‹ã‚‰sudoã‚’ä½¿ã‚ãšã€-u rootã€-pã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä»˜ã‘ã¦ãƒã‚°ã‚¤ãƒ³ã‚’è©¦ã¿ã‚‹ã€‚ ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒè¦æ±‚ã•ã‚Œã€èªè¨¼ãŒé€šã‚Œã°æˆåŠŸã§é¼»é«˜ã ï¼ ãªãœåˆã£ã±ãªã‹ã‚‰Access deniedãŒç™ºç”Ÿã™ã‚‹ã®ã‹ï¼Ÿ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ç›´å¾Œã«mysqlã‚’ã€æ¨©é™ã®ãªã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰æ“ä½œã™ã‚‹ã¨ã‚½ã‚±ãƒƒãƒˆï¼ˆmysql.sockã®ã‚ˆã†ãªï¼‰ãŒä½œæˆã§ããªã„ãŸã‚ã«ç™ºç”Ÿã™ã‚‹ã€‚ ãªã®ã§åˆå›žã«ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚’sudoã§æ˜‡æ ¼ã—ã¦ã‚„ã‚Œã°ã§ç§’ã§è§£æ¶ˆã§ãã‚‹ä»¶ãªã®ã«ã‚°ã‚°ã‚‹ã¨ ã‚½ã‚±ãƒƒãƒˆã‚’æ‰‹å‹•ã§ä½œæˆï¼ˆã¾ã åˆ†ã‹ã‚‹ï¼‰ my.cnfã§ã‚½ã‚±ãƒƒãƒˆã®ä½œæˆå ´æ‰€å¤‰æ›´ï¼ˆã“ã‚Œã‚‚ã¾ã åˆ†ã‹ã‚‹ï¼‰ ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ¢ã‚ãŸã‚Šã™ã‚‹ï¼ˆæ¢ã‚ãŸã“ã¨ã§ã‚½ã‚±ãƒƒãƒˆã‚’ä½œæˆã§ãã‚‹æ¨©é™ã‚’æŒã¡åˆã‚ã›ã¦ç„¡ã„ã®ã§é–¢ä¿‚ãªã„ï¼‰ ã‚„ãŸã‚‰skip-gra
grover 2024/07/13
mysql
ãƒªãƒ³ã‚¯
mysqldumpã§PROCESSæ¨©é™(PROCESS privilege)ã‚’è¦æ±‚ã•ã‚Œã‚‹ - ã„ã£ã•ã„ãŒã£ã•ã„
cronã§å®šæœŸå®Ÿè¡Œã—ã¦ã„ãŸMySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚¿ã‚¹ã‚¯ãŒã‚¨ãƒ©ãƒ¼ã‚’åãã‚ˆã†ã«ãªã£ãŸã€‚mysqldumpã§ã‚¨ãƒ©ãƒ¼ã«ãªã£ã¦ã„ã‚‹ã€‚ mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces MySQLã‚’5.7.31ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ãŸã“ã¨ã§æ¨©é™ã®è¦æ±‚ãŒå¤‰ã‚ã£ãŸã‚‰ã—ã„ã€‚PROCESSæ¨©é™ãŒå¿…è¦ã¨ãŠã£ã—ã‚ƒã£ã¦ã„ã‚‹ã€‚ è§£æ±ºæ‰‹æ®µ ã¨ã‚Šã‚ãˆãšã€PROCESSæ¨©é™ã‚’æŒãŸã›ã‚Œã°ã‚ˆã•ãã†ãªã®ã§ã€æ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã§mysqldumpã‚’å®Ÿè¡Œã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«æ¨©é™ã‚’ä¸Žãˆã‚‹ã€‚ mysql > GRANT PROCESS ON *.* TO 'your-user'; ã§æ¨©é™ã‚’ä»˜ã‘ã‚‹ã€‚your-userã¯ã‚³ãƒžãƒ³ãƒ‰ã§
grover 2024/06/07
mysql
ãƒªãƒ³ã‚¯
docker compose ã§ MySQL ã‚’å‹•ã‹ã™ã¨ãã®ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³æŒ‡å®šæ–¹æ³•
ã¾ãˆãŒã å€‹äººé–‹ç™ºã§ SELECT NOW() ã—ãŸã¨ãã«ã€UTC ã®æ—¥ä»˜æ™‚åˆ»ãŒè¿”ã£ã¦ããŸãŸã‚ä¿®æ£ã™ã‚‹ï¼ ç’°å¢ƒ WSL2 (Windows 10 64bit) Ubuntu 22.04.2 LTS docker compose MySQL 8.0.32 æ‰‹é † docker-compose.yaml ã‚’ç·¨é›† ç¾çŠ¶ã¯ã“ã‚“ãªæ„Ÿã˜ version: '3.9' services: mysql: build: ./mysql volumes: - ./mysql/data:/var/lib/mysql ports: - "3306:3306" environment: - MYSQL_ROOT_PASSWORD=password version: '3.9' services: mysql: build: ./mysql volumes: - ./mysql/data:/var/lib/mysql
grover 2023/11/13
mysql
ãƒªãƒ³ã‚¯
MySQL ver5.7ã§mysqldumpã—ã‚ˆã†ã¨ã—ã¦ã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸã¨ãã®å¯¾å‡¦æ³• - Qiita
databaseã®ãƒãƒƒã‚°ã‚¢ãƒƒãƒ—ã‚’å–ã‚ã†ã¨ã—ã¦ä¸€æ—¦sqlãƒ•ã‚¡ã‚¤ãƒ«ã«è½ã¨ãã†ã¨ã—ãŸã‚‰ã€MySQLã‹ã‚‰æ¬¡ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãŒå‡ºã¾ã—ãŸã€‚ $ mysqldump -uroot -p hogehoge >hogehoge.sql Enter password: mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'gtid\_mode'': Table 'performance_schema.session_variables' doesn't exist (1146) $ mysql_upgrade -u root -p Enter password: Checking if update is needed. Checking server version. Running queries to upgrade MySQL server. Checkin
grover 2023/10/19
mysql
ãƒªãƒ³ã‚¯
RDS ã‹ã‚‰ mysqldump ã™ã‚‹ã¨ãã®ãŠä½œæ³• - AR ãƒ›ãƒ¼ãƒ ãƒ™ãƒ¼ã‚«ãƒªãƒ¼
GTID ã¨ã‹ã¤ã„ã¦ãã¦ã€ãã®ã¾ã¾ä»–ã®ç’°å¢ƒã«æŒã¡è¾¼ã‚‚ã†ã¨ã™ã‚‹ã¨ã†ã¾ãè¡Œã‹ãšã€‚ ã€Œã‚¤ãƒ©ã‚¡ã€ã¨ã—ãªã„ãŸã‚ã®ãƒ¡ãƒ¢ã€‚ mysqldump -u ${ãƒ¦ãƒ¼ã‚¶å} -p -h ${ã‚¨ãƒ³ãƒ‰ãƒã‚¤ãƒ³ãƒˆ} --quick --single-transaction --skip-triggers --set-gtid-purged=OFF ${DBå} > ${ãƒ•ã‚¡ã‚¤ãƒ«å} ã“ã‚Œã§ã‚ˆã„ã€‚ mysql -u ${USER} -p -h ${HOST} < ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«.sql ã¨ã‹ã§ã‚¹ãƒ«ã£ã¨æˆ»ã›ã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚
grover 2022/01/24
aws

mysql
ãƒªãƒ³ã‚¯
[MySQL] ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER privilege(s) for this operation - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
grover 2021/10/23
mysql
ãƒªãƒ³ã‚¯
ã“ã‚Œã§ã‚ã‹ã£ãŸ!? LEFT / RIGHT JOIN. - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
grover 2021/04/24
mysql
ãƒªãƒ³ã‚¯
MySQL ã§ç‰¹å®šã® IP ã‚¢ãƒ‰ãƒ¬ã‚¹ã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’è¨±å¯ã™ã‚‹ - Qiita
ã¯ã˜ã‚ã« web ã‚µãƒ¼ãƒãƒ¼ã‹ã‚‰ DB ã‚µãƒ¼ãƒãƒ¼ã«ã‚¢ã‚¯ã‚»ã‚¹ã‚’è¨±å¯ã™ã‚‹ã¨ããªã©ã€MySQL ã§å¤–éƒ¨ã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’è¨±å¯ã—ãŸã„ã¨ãã®è¨å®šã‚ã‚Œã“ã‚Œã‚’è‡ªåˆ†ç”¨ã«ãƒ¡ãƒ¢ã€‚ ãŠã—ãªãŒã DB ã‚µãƒ¼ãƒãƒ¼ã«ãƒã‚°ã‚¤ãƒ³ã—ã¦ä»¥ä¸‹ã®ä½œæ¥ã‚’è¡Œã£ã¦ã„ãã¾ã™ã€‚ MySQL ã®è¨å®š MySQL ã§å¤–éƒ¨ã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹æ¨©ã‚’æŒã£ãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ä½œæˆ firewall ã®è¨å®š ç’°å¢ƒ OSï¼š CentOS 7 MySQLï¼š 5.7 MySQL ã®è¨å®š å¿…è¦ã«å¿œã˜ã¦ my.conf ã‚’æ›¸ãæ›ãˆã¾ã™ã€‚ ãªãŠã€ç’°å¢ƒã«ã‚ˆã£ã¦ my.conf ãŒä¿å˜ã•ã‚Œã¦ã„ã‚‹å ´æ‰€ãŒé•ã†ã‚ˆã†ã§ã™ã€‚ è‡ªåˆ†ã¯ /etc/my.cnf ã«ã‚ã‚Šã¾ã—ãŸã€‚ ã€å‚è€ƒã€‘my.cnfã®å ´æ‰€ã‚’èª¿ã¹ã‚‹ bind-address ã«æŽ¥ç¶šã—ãŸã„ IP ã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’è¿½åŠ ã€‚
grover 2020/12/17
centos

mysql
ãƒªãƒ³ã‚¯
Install MySQL 8.0 on CentOS 7
ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ æœ¬è¨˜äº‹ã¯ã€CentOS 7.x ã¸ã® MySQL 8.0 ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«ã¤ã„ã¦è¨˜è¼‰ã—ã¦ã„ã¾ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« å…¬å¼ã‚¬ã‚¤ãƒ‰ ã‚’å‚è€ƒã«ã€yum ã‚’ä½¿ç”¨ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’è¡Œã£ã¦ã„ãã¾ã™ã€‚ ç’°å¢ƒ OSï¼šCentOS 7.5 DBï¼šMySQL 8.0 MariaDB ã®å‰Šé™¤ CentOS 7 ã«ã¯ã€MySQL ãƒ•ã‚©ãƒ¼ã‚¯ã® MariaDB ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ å ´åˆãŒã‚ã‚Šã¾ã™ã®ã§ã€å‰Šé™¤ã—ã¦ãŠãã¾ã™ã€‚
grover 2020/12/17
centos

mysql
ãƒªãƒ³ã‚¯
MySQLã§å…¨æ–‡æ¤œç´¢ãã®1(Mroongaç·¨) - è™Žã®ç©´ãƒ©ãƒœæŠ€è¡“ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ãŠä¹…ã—ã¶ã‚Šã§ã™ã€‚è™Žã®ç©´ãƒ©ãƒœã®A.M.ã§ã™ã€‚ å‰å›žã®è¨˜äº‹ã€Œå…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã«ã¤ã„ã¦èª¿ã¹ã¦ã¿ãŸã€ã‹ã‚‰å¤§åˆ†é–“ãŒç©ºã„ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€ä»Šå›žã¯ã¨ã‚‰ã®ã‚ãªã®ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ç”¨é »åº¦ã®é«˜ã„MySQLã§ã€å®Ÿéš›ã«å…¨æ–‡æ¤œç´¢ã‚’ã‚„ã£ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ MySQLã§æ‰‹è»½ã«å…¨æ–‡æ¤œç´¢ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã®æ‰‹æ³•ã¨ã—ã¦ã¯ã€ä»¥ä¸‹ã®ï¼’ã¤ãŒæŒ™ã’ã‚‰ã‚Œã¾ã™ã€‚ MySQLã®FULLTEXTã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼šMySQLã®æ¨™æº–æ©Ÿèƒ½ã€‚v5.7ã‹ã‚‰æ—¥æœ¬èªžã«å¯¾å¿œã€‚ Mroongaï¼šGroongaãƒ™ãƒ¼ã‚¹ã®MySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€‚ â€»FULLTEXTã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„Mroongaã€Groongaãªã©ã«ã¤ã„ã¦è©³ã—ãã¯å‰å›žã®è¨˜äº‹ã‚„ã€ç¬¬3å›žãƒ©ã‚¤ãƒˆãƒ‹ãƒ³ã‚°ãƒˆãƒ¼ã‚¯ã‚¤ãƒ™ãƒ³ãƒˆè¨˜äº‹ã‚’ã”å‚ç…§ãã ã•ã„ã€‚ toranoana-lab.hatena blog.com toranoana-lab.hatena blog.com ä»Šå›žã¯ã€è¨˜äº‹ã®ã‚¿ã‚¤ãƒˆãƒ«ã«ã‚‚ã‚ã‚‹ã‚ˆã†ã«ã€Mroong
grover 2020/04/01
mysql
ãƒªãƒ³ã‚¯
MySQL8.0ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã—ãŸã‚‰ãƒã‚°ã‚¤ãƒ³ã§ããªããªã£ãŸæ™‚ã®è§£æ±ºæ³• | e-joint.jp
mySQL8.0ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã—ãŸã‚‰ã€ãƒãƒ¼ã‚«ãƒ«ã®phpMyAdminã«ã“ã‚“ãªã‚¨ãƒ©ãƒ¼ãŒè¡¨ç¤ºã•ã‚Œãƒã‚°ã‚¤ãƒ³ã§ããªããªã£ãŸã®ã§ã€è§£æ±ºæ³•ã€‚ mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] è§£æ±ºæ³• ãƒ¦ãƒ¼ã‚¶ãƒ¼ rootã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ pwdã® å ´åˆã€‚ use mysql; ALTER USER 'root'@'localhost' identified WITH mysql_native_password BY 'pwd'; my.cnf ã«ã‚‚è¿½è¨˜ã€‚ [mysqld] # æ—§ MySQL Clientã¨ã®äº’æ›æ€§ç¢ºä¿ default_authentication_plugin=mysql_native_password ã“ã‚Œã§ãƒã‚°ã‚¤
grover 2019/07/24
mysql
ãƒªãƒ³ã‚¯
CentOS7ã«MySQL8.0ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
grover 2019/07/24
mysql

centos
ãƒªãƒ³ã‚¯
phpMyAdmin çµŒç”±ã§ã€ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰ DB ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã—ã¦ã¿ã‚‹ - Qiita
ï¼ï¼Žã¯ã˜ã‚ã« å…±ç”¨ã‚µãƒ¼ãƒãªã©ã€ å¤–éƒ¨ã‹ã‚‰ phpMyAdmin çµŒç”±ã§ã—ã‹ DB ã¸ã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„å ´åˆã§ã‚‚ã€ ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰è‡ªå‹•ã§ DB ã‚’ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã—ãŸã„ãªã€ ã¨æ€ã„ã€ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ ï¼‘ï¼Žãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã„ã€‚ ã¨ã„ã†äº‹ã§ã€ ä»¥ä¸‹ã®ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’å®Ÿè¡Œã™ã‚Œã°ã§ãã‚‹ã¨æ€ã„ã¾ã™ã€‚ ã§ã€è§£èª¬ã‚’ã¡ã‚‡ã£ã¨å¾Œè¿°ã—ã¨ãã¾ã™ã€‚ ã‚ã¨ã€phpMyAdmin ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 4.0.10.17 ã§ã—ã‹ç¢ºèªã—ã¦ã„ãªã„ã®ã§ã€ ã†ã¾ãã„ã‹ãªã„å ´åˆã¯ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«åˆã‚ã›ã¦ä¿®æ£ã—ã¦ä¸‹ã•ã„ã€‚ #!/bin/bash # ---1----+----2----+----3----+----4----+----5----+----6----+----7----+----8---- # ===================================================================
grover 2019/06/13
mysql
ãƒªãƒ³ã‚¯
SQLç´ äººã§ã‚‚åˆ†ã‹ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«çµåˆ(inner joinã¨outer join) - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
grover 2019/03/28
mysql
ãƒªãƒ³ã‚¯
MySQL5.6ã‹ã‚‰5.7ã«Yumã§ã‚µã‚¯ãƒƒã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
grover 2019/03/11
mysql
ãƒªãƒ³ã‚¯
ã€BigDumpã§ã‚¤ãƒ³ãƒãƒ¼ãƒˆã€‘phpMyAdminã§ãƒ•ã‚¡ã‚¤ãƒ«ãŒå¤§ãã™ãŽã¦ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ããªã„æ™‚ | WEBåˆ¶ä½œã«å½¹ç«‹ã¤ãƒ’ãƒ³ãƒˆã€‚å¿˜ã‚Œãªã„ãŸã‚ã®ãƒ¡ãƒ¢çš„ã‚µã‚¤ãƒˆã€‚
grover 2019/02/05
phpmyadminã§ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹æ™‚ã€‚

mysql
ãƒªãƒ³ã‚¯
phpMyAdminã‚’ä½¿ã£ã¦WordPressã‚’åˆ¥ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã§ä½¿ãˆã‚‹ã‚ˆã†ã«ã™ã‚‹æ–¹æ³• | ãã‚Œã‹ã‚‰ãƒ‡ã‚¶ã‚¤ãƒ³ ã‚¹ã‚¿ãƒƒãƒ•ãƒ–ãƒã‚°
WordPressã¯MySQLã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚µã‚¤ãƒˆã®ã•ã¾ã–ã¾ãªæƒ…å ±ã‚’ç®¡ç†ã—ã¦ã„ã¾ã™ãŒã€åˆ¥ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¸ã‚·ã‚¹ãƒ†ãƒ ã‚’ç§»è»¢ã•ã›ã‚‹ã«ã¯ã€åŸºæœ¬çš„ãªã‚µã‚¤ãƒˆURLã®ç™»éŒ²æƒ…å ±ã®ä»–ã€ãƒ‘ãƒ¼ãƒžãƒªãƒ³ã‚¯ã¨å‘¼ã°ã‚Œã‚‹å„æŠ•ç¨¿è¨˜äº‹ã®URLã«åŸ‹ã‚è¾¼ã¾ã‚ŒãŸãƒ‰ãƒ¡ã‚¤ãƒ³åã‚’æ–°ãƒ‰ãƒ¡ã‚¤ãƒ³åã¸ç½®æ›ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ä¾‹ãˆã°ä»¥ä¸‹ã®å›³ã¯ã€WordPressã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸€éƒ¨ã‚’è¦–è¦šåŒ–ã—ãŸã‚‚ã®ã§ã™ã€‚ ã‚µã‚¤ãƒˆURLã‚„ãƒ‘ãƒ¼ãƒžãƒªãƒ³ã‚¯ã¯ã€ä¸‹å›³ã®ã‚ˆã†ã«ä¿å˜ã•ã‚Œã¦ã„ã¾ã™ã€‚ WordPressã¯ï¼‘è¨˜äº‹ã”ã¨ã«è¨˜äº‹ã®URLã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¿å˜ã™ã‚‹ä»•çµ„ã¿ã«ãªã£ã¦ã„ã¾ã™ã€‚æ•°ç™¾ã€æ•°åƒã¨ã„ã£ãŸè¨˜äº‹ã‚’ç½®æ›ã™ã‚‹ã«ã¯phpMyAdminãªã©ã®ã‚¦ã‚§ãƒ–ãƒ–ãƒ©ã‚¦ã‚¶ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ“ä½œãŒã§ãã‚‹å°‚ç”¨ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ã¨ä¾¿åˆ©ã§ã™ã€‚ ãã“ã§ä»Šå›žã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ“ä½œã«ä¸æ…£ã‚Œãªæ–¹ã§ã‚‚phpMyAdminã‹ã‚‰ãƒ‰ãƒ¡ã‚¤ãƒ³åã‚’ä¸€ç™ºç½®æ›ã—ã€æ—§ãƒ‰ãƒ¡ã‚¤ãƒ³ã§ä½¿ã£ã¦ã„ãŸWordPressã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ–°ãƒ‰ãƒ¡
grover 2019/01/10
mysql
ãƒªãƒ³ã‚¯
MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° -my.cnfã®è¦‹ç›´ã—- - Qiita
â€»RDSã¯ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ è² è·ã‚’è¦‹ã¦ã¿ã‚‹ DBã‚µãƒ¼ãƒãƒ¼ã®è² è·çŠ¶æ³ã‚’è¦‹ã¦ã¿ã¾ã™ã€‚ å½“æ™‚ã®ç›£è¦–ãƒ„ãƒ¼ãƒ«ã®ç”»åƒãŒãªã„ã®ã§ã™ãŒã€ä»¥ä¸‹ã®çŠ¶æ³ã§ã—ãŸã€‚ LA(Load Average)ãŒçªãæŠœã‘ã¦ã„ã‚‹ ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ•°ã¯ã€Œå¸¸è˜çš„ã«è€ƒãˆã¦ã€ãã‚Œã»ã©ã§ã‚‚ãªã„ ãƒ¡ãƒ¢ãƒªã®ä½¿ç”¨é‡ã«ã‚ã¾ã‚Šå¤‰åŒ–ãŒãªã„ swapã¯ã—ã¦ã„ãªã„ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸å®¹é‡ã‚’çµæ§‹é£Ÿã£ã¦ã„ã‚‹ WEBã‚µãƒ¼ãƒãƒ¼ã‹ã‚‰è¦‹ã‚Œã°ã€å‡¦ç†å¾…ã¡ã®ã¾ã¾ãƒ—ãƒã‚»ã‚¹ãŒå‡¦ç†ã•ã‚Œã¦ã„ãªã„å…¸åž‹çš„ãªãƒ‘ã‚¿ãƒ¼ãƒ³ã ã£ãŸã¨æ€ã„ã¾ã™ã€‚ DBã‚µãƒ¼ãƒãƒ¼ã¨ã—ã¦ã¯ã€LAã«å¯¾ã—ã€ãƒ¡ãƒ¢ãƒªã®ä½¿ç”¨é‡ãŒã‚ã£ã¦ã„ãªã„ã‚ˆã†ã«æ€ã‚ã‚Œã¾ã—ãŸã€‚ ä»®èª¬ ä¸Šè¨˜ã®çŠ¶æ…‹ã‹ã‚‰ã€ä»®èª¬ã‚’ç«‹ã¦ã¾ã™ã€‚ ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒª ãŒé »ç™ºã—ã¦ã„ã‚‹ã®ã§ã¯ãªã„ã‹ ãƒ¡ãƒ¢ãƒª ãŒæ£ã—ãå‰²ã‚Šå½“ã¦ã‚‰ã‚Œã¦ã„ãªã„ã®ã§ã¯ãªã„ã‹ å„ç¨®ãƒã‚° ã®è¨å®šãŒé©åˆ‡ã§ã¯ãªã„ã®ã§ã¯ãªã„ã‹ ä»®èª¬ã‚’æ¤œè¨¼ã™ã‚‹ã“ã¨ã§ã€å¯¾ç–ã‚’ã—ã¦ã„ãã¾ã™ã€‚ è¨å®šã‚’è¦‹ç›´ã™ ä¸Šè¨˜ã®ä»®èª¬ã®è¨å®šã¯ã€MySQLã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã§ã‚ã‚‹ã€Œ
grover 2018/09/07
mysql
ãƒªãƒ³ã‚¯
MySQL 8.0ç™»å ´ï¼ç«‹ã¡æ¢ã¾ã‚‹ã“ã¨ã‚’çŸ¥ã‚‰ãªã„é€²åŒ–ã¯ã“ã‚Œã‹ã‚‰ã‚‚ç¶šãã€‚
ã‚´ãƒ¼ãƒ«ãƒ‡ãƒ³ã‚¦ã‚£ãƒ¼ã‚¯ã¯ã„ã‹ãŒãŠéŽã”ã—ã•ã‚ŒãŸã ã‚ã†ã‹ã€‚ä»Šå¹´ã¯å¤©æ°—ã‚‚è‰¯ãã€è¡Œæ¥½æ—¥å’ŒãŒç¶šã„ãŸã‚ˆã†ã«æ€ã†ã€‚ ã•ã¦ã€å…ˆæ—¥MySQL 8.0ãŒæ£å¼ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã€‚å°‘ã—æ™‚é–“ãŒçµŒã£ã¦ã—ã¾ã£ãŸãŒã€ä»Šå›žã¯MySQL 8.0ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„ã€‚ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ç‰ˆã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯ã“ã¡ã‚‰ã‹ã‚‰å¯èƒ½ã ã€‚ ã²ã¨ã¤å‰ã®æ£å¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯MySQL 5.7ã ã£ãŸã®ã ãŒã€MySQL 8.0ã¯éžå¸¸ã«å¤§ããªãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ãŒå«ã¾ã‚Œã¦ãŠã‚Šã€5.xå°ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚’æ¨ã¦åŽ»ã‚ã†ã¨ã„ã†è©±ãŒã‚ã£ãŸã€‚ãã“ã§ã€æ¬¡ã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯æœ€åˆã®æ¡ã‚’å¢—ã‚„ã™ã¨ã„ã†ã“ã¨ã«ãªã£ãŸã®ã ãŒã€MySQL 6.0ã¯éŽåŽ»ã«æ—¢ã«å˜åœ¨ã—ã€è²·åŽãªã©ã®é¨’ãŽã§é–‹ç™ºãŒé “æŒ«ã—ã¦ã—ã¾ã£ãŸçµŒç·¯ãŒã‚ã‚‹ã€‚7.xã¯MySQL NDB Clusterã¨è¢«ã£ã¦ã„ã‚‹ã€‚ã¨ã„ã†ã‚ã‘ã§ã€5.7ã®7ã®éƒ¨åˆ†ã®æ¬¡ã¨ã„ã†æ„å‘³åˆã„ã‚‚ã‚ã£ã¦ã€8.0ã¨ã„ã†ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚’å¼•ã£ã•ã’ã€æº€ã‚’æŒã—ã¦ã®ç™»å ´ã¨ãªã£ãŸã€‚ãã®
grover 2018/05/07
mysql
ãƒªãƒ³ã‚¯
MySQLã§ã®ã€Œcurrent_timestampã€ã¯ãƒ†ãƒ¼ãƒ–ãƒ«å†…ã§ä¸€ã¤ã ã‘
MySQL ã§ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹éš›ã€ä»¥ä¸‹ã®ã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸã€‚ #1293 â€“ Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause åŽŸå› ç™»éŒ²æ—¥æ™‚ãƒ»æ›´æ–°æ—¥æ™‚ã® timestampåž‹ã®ã‚«ãƒ©ãƒ ã‚’2ã¤ç”¨æ„ã—ã€ä¸¡æ–¹ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã«ã€Œcurrent_timestampã€ã‚’è¨å®šã—ãŸãŸã‚ è§£æ±ºæ–¹æ³• ç™»éŒ²æ—¥ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã‚’ã€Œ0ã€ã«è¨å®šã™ã‚‹ï¼ˆinsertæ™‚ã«æ‰‹å‹•ã§å…¥ã‚Œã‚‹é‹ç”¨ã«ï¼‰ã€‚ 1.timestampåž‹ã®current_timestampã«ã¤ã„ã¦ timestampåž‹ã¯ã€ãƒ‡ãƒ¼ã‚¿ã®ç™»éŒ²æ—¥æ™‚ã‚„æ›´æ–°æ—¥æ™‚ã‚’ä¿å˜ã™ã‚‹ãŸã‚ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãã‚Œç”¨ã®ã‚«ãƒ©ãƒ ã‚’ä½œæˆã™ã‚‹ã“ã¨ãŒå¤šã„ï¼ˆã‚ˆãï¼ï¼Ÿï¼‰ã€‚ ã€Œcurrent_timestampã€ã¯ã€ãã® tim
grover 2018/04/18
mysql
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸