[B! MySQL] mimosafaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

mimosafa id:mimosafa

MySQLã«é–¢ã™ã‚‹mimosafaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (47)

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

Macã®Dockerã§Apache+MySQL+PHPã®é–‹ç™ºç’°å¢ƒæ§‹ç¯‰
Dockerã‚’ä½¿ã£ã¦Macä¸Šã«LAMP(Linux + Apache + MySQL + PHP)ç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹æ–¹æ³•ã‚’è§£èª¬ã—ã¾ã™ã€‚ Dockerã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒã¾ã ã®æ–¹ã¯ã“ã¡ã‚‰ã‚’ã”è¦§ãã ã•ã„ã€‚
mimosafa 2024/04/25
ã‚ã¨ã§èªã‚€

docker

compose

Apache

MySQL

PHP

LAMP
ãƒªãƒ³ã‚¯
Docker-compose check if mysql connection is ready
I am trying to make sure that my app container does not run migrations / start until the db container is started and READY TO accept connections. So I decided to use the healthcheck and depends on option in docker compose file v2. In the app, I have the following app: ... depends_on: db: condition: service_healthy The db on the other hand has the following healthcheck db: ... healthcheck: test: TE
mimosafa 2022/12/07
docker

docker-compose

MySQL

healthcheck
ãƒªãƒ³ã‚¯
Docker-compose with MySQL/MariaDB and healthcheck
mimosafa 2022/12/07
docker

docker-compose

MySQL

healthcheck
ãƒªãƒ³ã‚¯
M1 mac ã§ MySQL ã‚³ãƒ³ãƒ†ãƒŠã‚’ä½¿ã†æ–¹æ³• - ã‚ã—ãŸã‹ã‚‰ãŒã‚“ã°ã‚‹
ã¤ã„å…ˆæ—¥ã€æˆ‘ãŒå®¶ã«M1 MacãŒå±Šãã¾ã—ãŸã€‚ ã€ŒDockerã¾ã‚ã‚ŠãŒã¤ã‚‰ã„ã‚ˆã€ã¨ã„ã†è©±ã¯èžã„ã¦ã„ã¾ã—ãŸãŒã€ç§ã‚‚ã—ã£ã‹ã‚Šã¨ MySQL ã®ã‚³ãƒ³ãƒ†ãƒŠãŒç«‹ã¡ä¸ŠãŒã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ è»½ãã‚°ã‚°ã£ã¦ã‚‚ã€Œã‚€ã‚€ãƒ»ãƒ»ãƒ»ï¼ŸðŸ¤”ã€ã¨æ€ã†çµæžœã ã£ãŸã®ã§ã€è‡ªåˆ†ã§ã—ã£ã‹ã‚Šã¾ã¨ã‚ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ãã‚‚ãã‚‚ã®å•é¡Œ M1 Mac ã§ Docker å…¬å¼ã® MySQL ã‚³ãƒ³ãƒ†ãƒŠã‚’ãã®ã¾ã¾ä½¿ãŠã†ã¨ã™ã‚‹ã¨ã€ä»¥ä¸‹ã®ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ä½¿ç”¨ã§ãã¾ã›ã‚“ã€‚ ERROR: no matching manifest for linux/arm64/v8 in the manifest list entries ã“ã‚Œã¯é›‘ã«èª¬æ˜Žã™ã‚‹ã¨ã€ã€Œã“ã®ã‚³ãƒ³ãƒ†ãƒŠã¯ ARM64 ã«å¯¾å¿œã—ã¦ãªã„ã‚ˆã€ã¨ã„ã†ã“ã¨ã§ã™ã€‚ ãã—ã¦ã€ M1 ãƒãƒƒãƒ—ã¯ ARM64 ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’æŽ¡ç”¨ã—ã¦ã„ã¾ã™ã€‚ è§£æ±ºã™ã‚‹æ–¹æ³• è‰²ã€…ã¨èª¿ã¹ã¦ã¿ã‚‹ã¨ã€ä¸»ã«3ã¤ã®æ–¹æ³•ãŒã‚ã‚‹ã‚ˆã†ã§ã™ã€‚ arm64v8
mimosafa 2022/12/02
MySQL

docker

M1

mac
ãƒªãƒ³ã‚¯
ç¬¬167å›žã€€M1æè¼‰Macã®Dockerã§MySQLã‚’å‹•ã‹ã—ã¦ã¿ã‚‹ | gihyo.jp
2020å¹´11æœˆã«ç™ºè¡¨ã•ã‚ŒãŸMacBook Airã‹ã‚‰æè¼‰ã•ã‚Œã¦ã„ã‚‹M1ãƒãƒƒãƒ—ã¨ã„ã†CPUãŒã‚ã‚Šã¾ã™ã€‚ã“ã¡ã‚‰ã¯å¾“æ¥ã®Macã«æè¼‰ã•ã‚Œã¦ã„ãŸCPUãŒx86/64ã®å‘½ä»¤ã‚»ãƒƒãƒˆã¨ã¯ç•°ãªã‚Šã€ARMã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’æŽ¡ç”¨ã—ã¦ã„ã‚‹ã¨ã„ã†é•ã„ãŒã‚ã‚Šã¾ã™ã€‚ç™ºå£²ã‹ã‚‰1å¹´ä»¥ä¸ŠãŸã¡ã€ã‚¤ãƒ³ãƒ†ãƒ«è£½ã®CPUã‚’æè¼‰ã—ãŸMacãŒãƒ©ã‚¤ãƒ³ãƒŠãƒƒãƒ—ã‹ã‚‰ç„¡ããªã£ãŸã®ã§ã€æ¬¡ã‚‚ã—Macã‚’è³¼å…¥ã™ã‚‹ã¨ãªã‚‹ã¨M1ãƒãƒƒãƒ—æè¼‰ã®Macã‚’è³¼å…¥ã™ã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ä»Šå›žã¯ã€ãã®éš›ã«å•é¡ŒãŒèµ·ã“ã‚ŠãŒã¡ãªDockerã§ã®é–‹ç™ºç’°å¢ƒã®æ§‹ç¯‰ã«ã¤ã„ã¦ã€ç´¹ä»‹ã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ Dockerã§MySQLã‚’å‹•ã‹ã—ã¦ã¿ã‚‹ ã¾ãšã¯ã€dockerã‚³ãƒžãƒ³ãƒ‰ã§MySQLã‚’æŒ‡å®šã—ã¦å‹•ã‹ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ % docker run -p 3307:3306 -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:latest Unable
mimosafa 2022/11/30
MySQL

M1

mac

docker

docker-compose
ãƒªãƒ³ã‚¯
MySQLã§æ–‡å—åˆ—ã‚’æ‰±ã†ãªã‚‰æŠ¼ã•ãˆã¦ãŠããŸã„textåž‹ã®åŸºæœ¬ | ãƒãƒ†ãƒ‘ãƒ³ã‚¹ã‚¿ã‚¤ãƒ«
Oracleã®æ•™ç§‘æ›¸ã§SQLã‚’å¦ã‚“ã æ–¹ãªã‚‰ã€æ–‡å—åˆ—ã‚’æ‰±ã†ãªã‚‰varcharåž‹ã‚’ä½¿ã†ã®ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ã—ã‹ã—ã€MySQLã§ã¯ã€æ–‡å—æ•°ã‚’æ°—ã«ã™ã‚‹å¿…è¦ã®ãªã„textåž‹ãŒåˆ©ç”¨ã§ãã¾ã™ã€‚ã¨ã¯ã„ãˆã€MySQLã®textã«ã¯æ–‡å—æ•°ã®åˆ¶é™ãŒã‚ã‚Šã€é•·ã„æ–‡å—åˆ—ã‚’æ‰±ã†å ´åˆã¯æ³¨æ„ãŒå¿…è¦ã§ã™ã€‚ä»Šå›žã¯ã€ã“ã®ã‚ˆã†ãªMySQLã®textåž‹ã®ç‰¹å¾´ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ æ–‡å—åˆ—ã‚’æ ¼ç´ã™ã‚‹åŸºæœ¬ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ã¯ãŸãã•ã‚“ã‚ã‚Šã¾ã™ãŒã€ãã†ã„ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯å¿…ãšã®ã‚ˆã†ã«æ–‡å—åˆ—ã‚’æ ¼ç´ã—ã¦ã„ã¾ã™ã€‚ãã—ã¦ã€æ–‡å—åˆ—ã‚’æ‰±ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚‹ã«ã¯ã€MySQLãªã‚‰varcharåž‹ã¨textåž‹ãŒåˆ©ç”¨ã§ãã¾ã™ã€‚ã¾ãšã¯ã€ã“ã®2ã¤ã®æ–‡å—åˆ—ã‚’æ‰±ã†ãƒ‡ãƒ¼ã‚¿åž‹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ æ–‡å—åˆ—ã‚’æ‰±ã†ãªã‚‰varcharãŒåŸºæœ¬ å›½éš›æ¨™æº–ã®SQLã®è¦æ ¼ã§ã¯ã€æ–‡å—åˆ—ã‚’æ‰±ã†ãƒ‡ãƒ¼ã‚¿åž‹ã¨ã—ã¦ã€å›ºå®šé•·ã®charåž‹ã€ã¾ãŸã¯ã€å¯å¤‰é•·varcharåž‹ãŒå®šç¾©ã•ã‚Œã¦ã„ã¾
mimosafa 2020/09/13
MySQL

text
ãƒªãƒ³ã‚¯
MySQL ã® VARCHAR ã¨ TEXT
RDBMS ã« MySQL ã‚’æŽ¡ç”¨ã—ãŸã‚·ã‚¹ãƒ†ãƒ ã§ã€VARCHAR ã®ä»£ã‚ã‚Šã« TEXT ã‚’é »ç”¨ã™ã‚‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒã‚ã£ãŸã€‚ãã‚“ãªã«æ˜”ã®è©±ã§ã¯ãªã„ã€‚ã¤ã„æœ€è¿‘ä½œã‚‰ã‚ŒãŸã‚·ã‚¹ãƒ†ãƒ ã ã€‚ VARCHAR ã‚‚ TEXT ã‚‚å¯å¤‰é•·æ–‡å—åˆ—ã‚’æ ¼ç´ã™ã‚‹åž‹ã§ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰è¦‹ã‚‹ã¨ã‚ã¾ã‚Šé•ã„ãŒãªã„ã€‚ã©ã¡ã‚‰ã‚‚ SQL ã§åŒã˜ã‚ˆã†ã«æ‰±ãˆã‚‹ã€‚ã—ã‹ã—ã€ã“ã‚“ãªå ´åˆã¯ VARCHAR ã‚’ä½¿ã†ã®ãŒå½“ç„¶ã˜ã‚ƒãªã„ã‹ã€‚ã‚ã–ã‚ã– TEXT ã‚’ä½¿ã†ç†ç”±ãŒãªã„ã€‚ãã†æ€ã£ãŸã®ã ãŒã€èª¿ã¹ã¦ã¿ã‚‹ã¨æ„å¤–ã«è¤‡é›‘ãªå•é¡Œã§ã‚ã£ãŸã€‚ ä½¿ã† SQL ã¯ã»ã¨ã‚“ã©åŒã˜ã§ã‚‚ã€VARCHAR ã¨ TEXT ã® MySQL å†…éƒ¨ã«ãŠã‘ã‚‹æ‰±ã„ã¯ã€ã ã„ã¶ç•°ãªã‚‹ã€‚InnoDB ã®å ´åˆã¯ã€é•·ã„ VARCHAR ã¯è‡ªå‹•çš„ã« TEXT ã¨åŒã˜ã‚ˆã†ã«æ‰±ã‚ã‚Œã‚‹ã€‚MyISAM ã®å ´åˆã€VARCHAR ã¯è¡Œã®ä¸ã«ã‚¤ãƒ³ãƒ©ã‚¤ãƒ³ã§ä¿ç®¡ã•ã‚Œã‚‹ãŒã€TEXT ã¯åˆ¥ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦æ ¼ç´ã•ã‚Œã‚‹ã€‚å¾“
mimosafa 2020/09/13
MySQL

VARCHAR

TEXT
ãƒªãƒ³ã‚¯
Mysqlã‚³ãƒžãƒ³ãƒ‰ - Qiita
mysql -u (ãƒ¦ãƒ¼ã‚¶ãƒ¼å) = èµ·å‹• mysql -u (ãƒ¦ãƒ¼ã‚¶ãƒ¼å) -p = ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å…¥åŠ›ã—ã¦èµ·å‹• use (ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å) = ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ‡ã‚Šæ›¿ãˆã‚‹ã‚³ãƒžãƒ³ãƒ‰ set password for root@localhost=password('è¨å®šã—ãŸã„ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰'); ãƒ‡ãƒ¼ã‚¿ã®ä¸èº«ã®ç¢ºèª select * from (ãƒ†ãƒ¼ãƒ–ãƒ«å) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚‹ create database (ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å); grant all on ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åï¼‰.* to dbuser@localhost identified by 'è¨å®šã—ãŸã„ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰';ä½œæ¥ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’ä½œã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ï¼ˆä¾‹æ–‡ï¼‰ create table users ( id int not null auto_increment primary key, name varchar(255), em ail v
mimosafa 2017/11/23
mysql
ãƒªãƒ³ã‚¯
Docker MySQLå…¬å¼ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’ä½¿ç”¨ã—ã¦DBã«åˆæœŸãƒ‡ãƒ¼ã‚¿ã‚’æµã—è¾¼ã‚€ - Qiita
ä¸€æ™‚æœŸã¯alpineã«ä¹—ã£ã‹ã£ãŸMySQLã‚’ä½¿ãŠã†ã¨ã—ã¾ã—ãŸãŒMariaDBã ã£ãŸã®ã§æ–å¿µã€‚ ã„ãã‚‰äº’æ›ã ã¨ã¯ã„ãˆã€ã¾ã è‡ªåˆ†ã«ã¯æ—©ã„ã€‚ ãã‚“ãªã‚ã‘ã§Docker MySQLå…¬å¼ã‚¤ãƒ¡ãƒ¼ã‚¸ã®5.5ã‚’åˆ©ç”¨ã—ã¦DBã‚’æ§‹ç¯‰ã€‚ å…¬å¼ã‚¤ãƒ¡ãƒ¼ã‚¸ https://hub.docker.com/_/mysql/ åˆæœŸãƒ‡ãƒ¼ã‚¿ã‚’æŠ•å…¥ã—ãŸçŠ¶æ…‹ã§githubã«pushã—ã‚ˆã†ã¨ã—ãŸã‚‰ã€rejectã•ã‚Œã¦ã—ã¾ã„ã¾ã—ãŸã€‚ èª¿ã¹ã¦ã¿ã‚‹ã¨Githubã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºåˆ¶é™ã«ã²ã£ã‹ã‹ã£ãŸæ¨¡æ§˜ Working with large files https://help.github.com/articles/working-with-large-files/ 1ãƒ•ã‚¡ã‚¤ãƒ«ã‚ãŸã‚Š100MBã¾ã§ã¨ã®ã“ã¨ã€‚ InnoDBã®ibdata1ãŒã‚µã‚¤ã‚ºåˆ¶é™ã‚’è¶…éŽã—ã¦ã„ãŸã®ã§ã—ãŸã€‚ã‹ãªã‚Šãƒ‡ãƒ¼ã‚¿ã‚’åŽ³é¸ã—ãŸã‚“ã ã‘ã©ãªã€œã€‚ åˆæœŸãƒ‡ãƒ¼ã‚¿ã‚¤ãƒ³ãƒãƒ¼ãƒˆã«ä½¿ç”¨ã—ãŸd
mimosafa 2016/09/30
docker

MySQL
ãƒªãƒ³ã‚¯
Vagrant + chef-solo ã«ã‚ˆã‚‹PHP + MySQLãªé–‹ç™ºç’°å¢ƒæ§‹ç¯‰å…¥é–€ | é–‹ç™ºãƒ¡ãƒ¢ã‚‹ã‚¢ãƒ«
é–‹ç™ºç’°å¢ƒã‚’ãƒãƒ¼ã‚«ãƒ«PCä¸Šã®ä»®æƒ³ã‚µãƒ¼ãƒã«æ§‹ç¯‰ã™ã‚‹ã“ã¨ãŒå½“ãŸã‚Šå‰ã«ãªã£ã¦ããŸæ˜¨ä»Šã€ ç’°å¢ƒæ§‹ç¯‰ã‚’ã‚‚ã£ã¨åŠ¹çŽ‡è‰¯ãã€æ¥½ã«ã—ãŸã„ã¨ã„ã†ã“ã¨ã§ã€é…ã‚Œã°ã›ãªãŒã‚‰Vagrant+chef-soloã‚’ã„ã˜ã‚Šå§‹ã‚ã¾ã—ãŸã€‚ ãªã‚“ã¨ã‹ãã‚Œã£ã½ã„é–‹ç™ºç’°å¢ƒãŒæ§‹ç¯‰ã§ããŸã®ã§ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ ã¨ã«ã‹ãå‹•ãç’°å¢ƒã‚’ã¾ãšä½œã£ã¦ã¿ã‚‹ã€Vagrant + chef-soloã§é–‹ç™ºã§ãã‚‹ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’æŒã¤ã€ã“ã¨ã‚’é‡è¦–ã—ã¦ä½œã‚Šã¾ã—ãŸã€‚ é–‹ç™ºç’°å¢ƒã®æ¦‚è¦ å¤§ä½“ã“ã‚“ãªæ„Ÿã˜ã®ç’°å¢ƒã‚’ä½œã‚Šã¾ã™ã€‚ ä»Šå›žã¯Fedora20ä¸Šã®VirtualBoxã«ä»®æƒ³ã‚µãƒ¼ãƒã‚’æ§‹ç¯‰ã—ã¦ã„ã¾ã™ã€‚ ã‚‚ã¡ã‚ã‚“Windowsä¸Šã§ã‚‚OSXä¸Šã§ã‚‚æ§‹ç¯‰å¯èƒ½ã§ã™ã€‚ â€»Windowsã®å ´åˆã€ä»¥é™ã§èª¬æ˜Žã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã¨å°‘ã—é•ã£ãŸæ‰‹é †ãŒå¿…è¦ã«ãªã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ ã€ŒPHPã€ã¨ãªã£ã¦ã„ã‚‹éƒ¨åˆ†ã‚‚ã€Rubyãªã©ä»–ã®è¨€èªžã«ã‚‚ç½®ãæ›ãˆãŒåŠ¹ãã¨æ€ã„ã¾ã™ãŒã€ ä»Šå›žã¯PHPã§æ§‹ç¯‰ã—ã¦ã„ã¾ã™ã€‚ ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’å…±
mimosafa 2014/10/14
vagrant

chef-solo

ç’°å¢ƒæ§‹ç¯‰

ã‚¤ãƒ³ãƒ•ãƒ©

PHP

MySQL
ãƒªãƒ³ã‚¯
http://hensachi35.com/vagrant
mimosafa 2014/10/12
vagrant

MySQL

phpMyAdmin
ãƒªãƒ³ã‚¯
Mac ã« Homebrew ã§ MySQL ã‚’ã„ã‚Œã‚‹ - Qiita
Oracle ãŒæä¾›ã—ã¦ã„ã‚‹ã‚‚ã®ã¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã‚‚ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚ã—ã¥ã‚‰ã„ã®ã§ Homebrew ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨è¨å®š
mimosafa 2014/08/25
homebrew

MySQL
ãƒªãƒ³ã‚¯
ã“ã‚Œã‹ã‚‰MySQLã‚’ã‚¤ãƒã‹ã‚‰å¦ã¶äººã«æ§ã’ãŸã„23å€‹ã®ã‚³ãƒžãƒ³ãƒ‰ãƒªã‚¹ãƒˆ
ã©ãƒ¼ã‚‚ã€‚ä»Šå¹´ã®æ˜¥é ƒã‹ã‚‰MySQLã‚’å¦ã³å§‹ã‚ãŸã€ã™ã‚‹ã·ï¼ˆ @isloop ï¼‰ã§ã™ã€‚ å¦ã³åˆã‚ã®ã“ã‚ã¯ã€ã€ŒãŸã‹ã ã‹æ–‡å—åˆ—ã‚’è¨˜éŒ²ã™ã‚‹ã ã‘ã§ãªã‚“ã¦ã‹ã£ãŸã‚‹ã„ã‚“ã ã€‚ã‚„ã£ã±ã‚ŠCSVä¿å˜ã«é€ƒã’ã‚ˆã†ã‹ãªã€‚ã€ã¨æ€ã£ã¦ã„ã¾ã—ãŸã€‚ãŒã€æœ€è¿‘ã«ãªã£ã¦ã‚ˆã†ã‚„ãæ…£ã‚Œã¦ããŸã‚ˆã†ã§ã€ã€Œçµæ§‹ä¾¿åˆ©ã˜ã‚ƒã‚“MySQLã€ã¨æ€ãˆã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¾ã—ãŸã€‚ ã¨ã„ã†ã‚ã‘ã§ä»Šæ—¥ã¯ã€å¦ã³åˆã‚ã®é ƒã«æ¬²ã—ã‹ã£ãŸã€Œã¨ã‚Šã‚ãˆãšã“ã‚Œã ã‘è¦šãˆãŸã‚‰ãªã‚“ã¨ã‹ãªã‚‹MySQLã®ã‚³ãƒžãƒ³ãƒ‰ãƒªã‚¹ãƒˆã€ã¨ã„ã†ã‚‚ã®ã‚’ä½œã£ã¦ã¿ã¾ã—ãŸã€‚ ã“ã‚Œã‹ã‚‰MySQLã‚’ã‚¤ãƒã‹ã‚‰å¦ã³ãŸã„ã¨ã„ã†äººãŒå‚è€ƒã«ãªã‚Œã°ã“ã‚Œå¹¸ã„ã€‚
mimosafa 2014/07/17
MySQL

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
Grunt ã§ Vagrant up æ™‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ã‚ˆã†ã«ã—ãŸã‚‰ã™ã”ãæ—ã‚‹ï¼
æ™®æ®µã€ãƒãƒ¼ã‚«ãƒ«ã¯ Vagrantï¼ˆ VCCW ï¼‰ã§é–‹ç™ºã‚’è¡Œã£ã¦ã„ã¦ã€WordPress ã®å„ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãƒ»ãƒ•ã‚¡ã‚¤ãƒ«ã¯ Vagrant ã®å…±æœ‰ãƒ•ã‚©ãƒ«ãƒ€æ©Ÿèƒ½ãŒã‚ã‚‹ã®ã§è‰¯ã„æ„Ÿã˜ã«åˆ¥ç’°å¢ƒã«è¤‡è£½ã—ãŸã‚Šãƒ†ã‚¹ãƒˆç’°å¢ƒã€æœ¬ç•ªç’°å¢ƒã«ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ãŸã‚Šã§ãã‚‹ã®ã§ã™ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ã¯ãƒãƒ¼ã‚«ãƒ«ã¨å…±æœ‰ã§ããšã€Vagrant ç’°å¢ƒã®ä¸ã«ã‚ã‚‹å½¢ã¨ãªã‚‹ã®ã§ã€ã‚¤ãƒ³ãƒãƒ¼ãƒˆã€ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒã¨ã£ã¦ã‚‚é¢å€’ã ãªã¨æ€ã£ã¦ã„ã¾ã—ãŸã€‚ ã¨ã„ã†ã“ã¨ã§ã€Grunt ã‹ã‚‰ WordPress ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆã€ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒè‰¯ã„æ„Ÿã˜ã«ã§ãã‚‹ã‚ˆã†ã«ã—ã¦ã¿ã¾ã—ãŸã€‚ å®Ÿéš›ã©ã®ã‚ˆã†ãªç’°å¢ƒã«ã—ãŸã®ã‹ å¯¾è±¡ã‚µã‚¤ãƒˆã®é–‹ç™ºç’°å¢ƒã®ãƒ«ãƒ¼ãƒˆã§ grunt ã¨ã‚³ãƒžãƒ³ãƒ‰ã‚’æ‰“ã¤ã ã‘ã§ Vagrant ã®èµ·å‹•ã€sql ãƒ•ã‚¡ã‚¤ãƒ«ãŒå˜åœ¨ã—ãŸã‚‰ãã‚Œã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆï¼ˆç„¡ã‘ã‚Œã°ç„¡è¦–ï¼‰ã€grunt halt ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã€Vagrant ã®çµ‚äº†ãŒè¡Œã‚ã‚Œã‚‹ã‚ˆã†ã«ã—
mimosafa 2014/07/11
grunt

vagrant

MySQL

WordPress
ãƒªãƒ³ã‚¯
https://www.hachi-log.com/sakura-ssh-db-error2002/
mimosafa 2014/05/15
MySQL

ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆ

ssh
ãƒªãƒ³ã‚¯
MySQLã§ä»–ã®ã‚µãƒ¼ãƒãƒ¼ã‹ã‚‰ã®æŽ¥ç¶šã‚’è¨±å¯ã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
mimosafa 2014/05/13
MySQL
ãƒªãƒ³ã‚¯
ãªã¾ã‘ã¦yumã§mysql 5.5ã«ã—ãŸã‚‰ã‚¨ãƒ©ãƒ¼ã§ãã‚“ãªã«æ¥½ã˜ã‚ƒãªã‹ã£ãŸ - ãƒ‡ãƒ©ã‚¨ãƒ¢ãƒ³ã€ã‚«ã‚¤ãƒãƒ„ãƒ‹ãƒƒã‚
æœ€è¿‘ã¯ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‹ã‚‰ãƒ“ãƒ«ãƒ‰ã—ãªã„ã¨æ°—ãŒæ¸ˆã¾ãªã„ãŠå¹´é ƒã§ã™ãŒã€ãªã¾ã‘ãŸã¾ã—ãŸã€‚ ã¾ã‚ã€çŠ¶æ³ã«å¿œã˜ãŸã¨ã„ã†ã“ã¨ã§ã€‚ ãã‚Œãªã‚Šã«æ–°ã—ã„MySQLãŒã•ã£ãã‚Šä½¿ãˆã‚Œã°ã‚ˆã‹ã£ãŸã®ã§yumã§å…¥ã‚Œã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ [ç’°å¢ƒ] CentOS release 5.7 (Final) x86_64 1.ãƒ¬ãƒã‚¸ãƒˆãƒªã®è¿½åŠ rpm -ivh http://download.fedora.redhat.com/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm rpm -ivh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm2.ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å®Ÿè¡Œ yum --enablerepo=remi,eplp install mysql mysql-server /etc/init.d/mysqld start My
mimosafa 2014/04/30
MySQL
ãƒªãƒ³ã‚¯
CentOSã‚µãƒ¼ãƒæ§‹ç¯‰ MySQLã‚µãƒ¼ãƒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ãã‚Œã§ã¯ï¼Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆDBMSï¼‰ã§ã‚ã‚‹MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ï¼Ž CentOSã§ã¯ï¼ŒMySQLã®ã‚µãƒ¼ãƒï¼ˆãƒ‡ãƒ¼ãƒ¢ãƒ³ï¼‰ã§ã‚ã‚‹ã€Œmysql-serverã€ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã¨MySQLã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã§ã‚ã‚‹ã€Œmysqlã€ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ï¼Ž 01. ä¸€èˆ¬ãƒ¦ãƒ¼ã‚¶ã§ãƒã‚°ã‚¤ãƒ³ã—ã¦ã„ã‚‹å ´åˆã¯ï¼Œsuã‚³ãƒžãƒ³ãƒ‰ã§rootã«ãªã‚Šã¾ã™ï¼ˆsudoã§æ“ä½œã—ã¦ã‚‚è‰¯ã„ã§ã™ï¼‰ï¼Ž $ su - 02. yumã‚³ãƒžãƒ³ãƒ‰ã§ï¼Œmysqlã¨mysql-serverã‚’ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆçµŒç”±ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ï¼Ž # yum install mysql mysql-server â€»ä¾å˜ã™ã‚‹ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚‚åˆã‚ã›ã¦5ã¤ã»ã©ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã•ã‚Œã¾ã™ï¼Ž ã€ŒIs this ok [y/N]:ã€ã¨èžã„ã¦ãã‚‹ã®ã§ã€Œyã€ã‚’å…¥åŠ›ã—ã¦Enterã‚ãƒ¼ã‚’æŠ¼ã—ã¾ã™ï¼Ž â€»ã€ŒComplete!ã€ã¨å‡ºã‚Œã°OKã§ã™ï¼Ž
mimosafa 2014/04/30
MySQL

CentOS
ãƒªãƒ³ã‚¯
VirtualBoxã¨Vagrantã§é–‹ç™ºç’°å¢ƒã‚’æ§‹ç¯‰ ãã®2 PHP + MySQLã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ã®ç¶šãã¨ãªã‚Šã¾ã™ã€‚ ä»Šå›žã¯gitã€vimã€PHPã€MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ãã¾ã™ã€‚ å‰å›žã€ã‚µãƒ©ã£ã¨æ›¸ã„ãŸã®ã§ã™ãŒã€PHPã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‹ã‚‰ã€‚ Vagrant + CentOS PHPã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ä½•ã¯ã¨ã‚‚ã‚ã‚Œã€ vagrant up ã§vargrantã‚’èµ·ã¡ä¸Šã’ã¾ã—ã‚‡ã†ã€‚ ã‚³ãƒžãƒ³ãƒ‰ã¯Vagrantfileã®ã‚ã‚‹å ´æ‰€ã‹ã‚‰ã€‚ vagrantãŒç«‹ã¡ä¸ŠãŒã‚Šã¾ã—ãŸã‚‰sshã§æŽ¥ç¶šã—ã¾ã™ã€‚ sudo yum -y install php ã“ã¡ã‚‰ã®yumã‚³ãƒžãƒ³ãƒ‰ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå‡ºæ¥ã¾ã™ã€‚ Vagrant + gitÂ vimã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ç¶šã‘ã¦ã€/home/vagrantã«Â yumã‚³ãƒžãƒ³ãƒ‰ã§git vimã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ãã¾ã™ã€‚ ãã®å‰ã«ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã‚’ã€‚å°‘ã€…æ™‚é–“ãŒã‹ã‹ã‚Šã¾ã™ã€‚ sudo yum -y update git sudo yum -y install vim git ã§gitã¨ vimã‚’
mimosafa 2014/04/30
vagrant

VirtualBox

ç’°å¢ƒæ§‹ç¯‰

php

MySQL
ãƒªãƒ³ã‚¯
AngularJSã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’PHPã§å‡¦ç†ã™ã‚‹ã¨ãã®ãƒ¡ãƒ¢ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
mimosafa 2014/04/28
AngularJS

application

php

MySQL
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸