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

microgravity id:microgravity

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

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

MAMPã®MySQLã‚’ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§æ“ä½œ - Macã‚¿ãƒ¼ãƒŸãƒŠãƒ« - MAMPã®ä½¿ã„æ–¹ - MySQLå…¥é–€ - Webkaru
MAMP ã® MySQL ã‚’ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§æ“ä½œã™ã‚‹æ–¹æ³•ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã¾ãšã¯ã€MAMPã‚’èµ·å‹•ã—ã¾ã™ã€‚ Finderã‚’èµ·å‹•ã—ã€ã€Œã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€â†’ã€Œãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã€ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã€ã€Œã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã€ã‚’èµ·å‹•ã—ã¾ã™ã€‚ MAMPã®ã‚³ãƒžãƒ³ãƒ‰ç¾¤ã¯ã€Œ/Applications/MAMP/Library/bin/ã€ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ã€Œcdã‚³ãƒžãƒ³ãƒ‰ã€ã§ä½œæ¥ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ç§»å‹•ã—ã¾ã™ã€‚ $ cd /Applications/MAMP/Library/bin/ mysqlã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ $ ./mysql -u root -p Enter password: â† ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å…¥åŠ›ã—ã¾ã™ã€‚ Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.5.29
microgravity 2018/03/23
MAMP

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ã‚’ã‚„ã‚‰ãªã‹ã£ãŸã‹ã‚‰ã„ã‘ãªã„ã®
microgravity 2018/03/21
â€œdrop user ã§ãƒ¦ãƒ¼ã‚¶å‰Šé™¤â€

MySQL
ãƒªãƒ³ã‚¯
MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãŸã‚ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ - ä¹…ä¿æ¸…éš†ã®ãƒ–ãƒã‚°
ä»•äº‹ã§MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ã„ã¦ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åˆ†ã‹ã£ã¦ã„ãªã„ã“ã¨ãŒå¤šã‹ã£ãŸã®ã§èª¿ã¹ãŸã“ã¨ã‚’ãƒ¡ãƒ¢ã€‚åŸºæœ¬çš„ãªã¨ã“ã‚ã‹ã‚‰å¦ç¿’ã—ãªãŠã—ãŸã€‚ MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã€ã‚«ãƒ©ãƒ ãŒç‰¹å®šã®å€¤ã‚’ã‚‚ã¤ãƒ¬ã‚³ãƒ¼ãƒ‰ã®è¿…é€Ÿãªæ¤œç´¢ã«ä½¿ç”¨ã•ã‚Œã‚‹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã™ã‚Œã°ã€æ•°ç™¾ã¨ã‹æ•°å„„ã‚‚ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå…¥ã£ã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ã€ä¸€çµ„ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿…é€Ÿã«è¦‹ã¤ã‘ã¦å–ã‚Šå‡ºã™ã“ã¨ãŒå¯èƒ½ã«ãªã‚‹ã€‚ ã—ã‹ã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯é€Ÿåº¦ã‚’æ”¹å–„ã™ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ãŒã€æŒ¿å…¥ã®é‚ªé”ã«ãªã£ã¦é…ããªã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é©åˆ‡ã«ä½¿ã†ãŸã‚ã«ã€ã¾ãšã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºæœ¬æ¦‚å¿µã‚’ãŠã•ãˆã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ¦‚å¿µ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä»•çµ„ã¿ã‚’ç†è§£ã™ã‚‹ã«ã¯ã€ã¾ãšMySQLãŒã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªã«å¿œç”ã™ã‚‹ã‹ã‚’çŸ¥ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ä¾‹ãˆã°ã€ SELECT * FROM phone_book WHERE last_name = 'Hoge'
microgravity 2018/01/25
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
CentOS7ã«mysqlã‚’å°Žå…¥ã—åˆæœŸè¨å®šã¾ã§ã‚„ã£ã¦ã¿ãŸ - é”æ³•ä½¿ã„ã®åµ
CentOS7ã«mysqlã‚’å…¥ã‚Œã‚‹ MariaDBãŒå…¥ã£ã¦ã„ã‚‹å ´åˆç«¶åˆã‚’èµ·ã“ã™ç‚ºå˜åœ¨ã®æœ‰ç„¡ã‚’ç¢ºèª yum list installed | grep maria å®Ÿè¡Œçµæžœ mariadb-libs.x86_64 1:5.5.35-3.el7 @anaconda ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« yum -y remove mariadb-libs mysqlã‚’å…¥ã‚Œã‚‹ MySQLå…¬å¼ãƒªãƒã‚¸ãƒˆãƒªãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« yum -y install http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm MySQLã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« yum -y install mysql yum -y install mysql-devel yum -y install mysql-server yum -y install mysql-utilities
microgravity 2017/09/14
MySQL
ãƒªãƒ³ã‚¯
ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã§MAMPç‰ˆMySQLã«æŽ¥ç¶šã™ã‚‹æ–¹æ³• - ç©ã¿é‡ããŸæ—¥ã€…
ãã®ã¾ã¾æŽ¥ç¶šã™ã‚‹ã¨ä»¥ä¸‹ã®ã‚¨ãƒ©ãƒ¼ãŒè¡¨ç¤ºã•ã‚Œã¦ã—ã¾ã†ã€‚ $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2)ãã®å ´åˆã«ã¯æ˜Žç¤ºçš„ã«MAMPç‰ˆMySQLã®Socketã‚’æŒ‡å®šã—ã¦ã‚ã’ã‚‹ã¨ã‚ˆã„ã€‚ $ mysql -S /Applications/MAMP/tmp/mysql/mysql.sockãŸã ã€æ¯Žå›žæ¯Žå›žMySQLã«æŽ¥ç¶šã™ã‚‹ãŸã³ã«Socketã‚’æŒ‡å®šã™ã‚‹ã®ã¯é¢å€’ãªã®ã§ã€~/my.cnfã®ä»¥ä¸‹ã®æŒ‡å®šã‚’å…¥ã‚Œã¦ãŠãã€‚ [client] socket = /Applications/MAMP/tmp/mysql/mysql.sock è¿½è¨˜ MAMPç‰ˆMySQLã¯ã€åˆæœŸè¨å®šã®ã¾ã¾ã§ã‚ã‚Œã°ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼åã¨ãƒ‘ã‚¹ãƒ¯
microgravity 2016/12/27
MySQL

MAMP
ãƒªãƒ³ã‚¯
MySQLã®ã‚½ã‚±ãƒƒãƒˆå ´æ‰€å¤‰æ›´ã€my.cnfã§ã®socketè¨å®šã®æ³¨æ„ç‚¹
EasyRamble ã¯ã€æŠ€è¡“ãƒã‚¿ã‚„åè‚²ã¦ã€è‹±èªžå¦ç¿’ã€ã‚¢ã‚¦ãƒˆãƒ‰ã‚¢ãªã©ã«ã¤ã„ã¦ç¶´ã‚‹ãƒ–ãƒã‚°ã§ã™ã€‚Ruby on Rails ã‚„ Swift ãªã©ã§ã€Webã‚µãƒ¼ãƒ“ã‚¹/ã‚¢ãƒ—ãƒªã‚’ä½œã£ã¦ã„ã¾ã™ã€‚
microgravity 2015/01/16
MySQL

mac
ãƒªãƒ³ã‚¯
mysqlã‚½ã‚±ãƒƒãƒˆã‚¨ãƒ©ãƒ¼è§£æ±ºæ³• - ã‚¦ãƒžã„è©±ã€ã¡ã‚‡ã„ãã‚Œã‚„ã€‚
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'ã“ã‚Œã€‚ãŸã¾ã«å‡ºã‚‹ãã€‚ ã“ã„ã¤ã«ãƒãƒžã‚‹ã¨ã©ã†ã—ã‚ˆã†ã‚‚ãªããªã‚‹ã€‚ ã¨ã‚Šã‚ãˆãšæŒ‡å®šã®å ´æ‰€ã«socketãƒ•ã‚¡ã‚¤ãƒ«ãŒã‚ã‚‹ã‹ç¢ºèª $ ls -al /var/lib/mysql/ ãªã‹ã£ãŸã‚‰ä½œæˆ $ sudo touch /var/lib/mysql/mysql.sock ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ‰€æœ‰è€…ã®å¤‰æ›´ $ sudo chown mysql:mysql /var/lib/mysql mysqlå†èµ·å‹• $ sudo /etc/init.d/mysqld restart /etc/my.cnfã‚’ã„ã˜ã£ãŸã‚Šã—ã¦ãªã‘ã‚Œã°ã“ã‚Œã§ã»ã¼è§£æ±ºã™ã‚‹ã€‚
microgravity 2015/01/15
MySQL
ãƒªãƒ³ã‚¯
ã‚ªãƒ¬ã‚ªãƒ¬Railsã‚¢ãƒ—ãƒªã‚’æ”¯ãˆã‚‹ã‚¤ãƒ³ãƒ•ãƒ©ã®ä½œã‚Šæ–¹ - ãã‚Šã«ã£ã
ã¯ã˜ã‚ã« ã“ã‚Œã¯ Ruby on Rails Advent Calendar 2014 - Qiita ã®19æ—¥ç›®ã§ã™ 18æ—¥ç›® @yancya ã•ã‚“ã® Rails ã§ã‚·ãƒ³ã‚°ãƒ«ã˜ã‚ƒãªã„ãƒ†ãƒ¼ãƒ–ãƒ«ç¶™æ‰¿ - Qiita ã§ã—ãŸ 19æ—¥ç›®ï¼šã‚ªãƒ¬ã‚ªãƒ¬Railsã‚¢ãƒ—ãƒªã‚’æ”¯ãˆã‚‹ã‚¤ãƒ³ãƒ•ãƒ©ã®ä½œã‚Šæ–¹ æœ€è¿‘ã§ã¯ Heroku ãªã©ã®PaaS*1 ã‚‚æ™®åŠã—ã¦ã‚¤ãƒ³ãƒ•ãƒ©ã®ã“ã¨ã‚’çŸ¥ã‚‰ãªãã¦ã‚‚ç°¡å˜ã«ã‚¢ãƒ—ãƒªã‚’å…¬é–‹ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ã—ã‹ã—ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã‚„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãªã©ã‚’è¡Œã†ã«ã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚³ãƒ¼ãƒ‰ã ã‘ã§å®Œçµã™ã‚‹ã“ã¨ã¯å°‘ãªãã€å…¨ä½“åƒã‚’æŠŠæ¡ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚Railsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è£ã§ã©ã‚“ãªæ§‹æˆã§å‹•ã„ã¦ã„ã‚‹ã‹ã‚’çŸ¥ã£ã¦ãŠãã‹ã¯é‡è¦ãªã®ã§ã–ã£ãã‚Šã¨ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ æ›¸ã‹ãªã„ã“ã¨ Railsã‚¢ãƒ—ãƒªã‚’ä½œã‚‹ä¸Šã§ã®ãƒŽã‚¦ãƒã‚¦ ä¾¿åˆ©ãªgemã‚„å¤–éƒ¨ã‚µãƒ¼ãƒ“ã‚¹ã®ç´¹ä»‹ *2 ç›£è¦– ã‚¢ãƒ©ãƒ¼ãƒˆæ¤œçŸ¥ ãƒ¢
microgravity 2014/12/19
rails

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

MySQL
ãƒªãƒ³ã‚¯
ã•ãã‚‰VPSã§ï¼‘ï¼åˆ†ã§wordpressã®è¨å®šã‚’ã™ã‚‹ - ç”˜å™›ã¿æœ€å‰ç·š
æœ€è¿‘ã•ãã‚‰ã®VPSã‚’å¥‘ç´„ã—ã¦ã€ã‚µãƒ¼ãƒãƒ¼ã®è¨å®šã‚’ã—ã¦ã€ãƒ¯ãƒ¼ãƒ‰ãƒ—ãƒ¬ã‚¹ã‚’å…¥ã‚Œã¦ã€‚ã€‚ã¨ã„ã†äº‹ã‚’ã‚ˆãã‚„ã‚Šã¾ã™ã€‚æ¯Žå›žæ¯Žå›žé¢å€’ãªã®ã§è‡ªå‹•åŒ–ã‚’è€ƒãˆã¦ã„ã‚‹ã®ã§ã™ãŒã€ã¾ãšã¨ã‚Šã‚ãˆãšå‹•ã‹ã—ãŸã„æ™‚ã«ã‚„ã‚‹äº‹ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚å¤šåˆ†ï¼‘ï¼åˆ†ç¨‹åº¦ã§è¨å®šã§ãã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç›®æ¨™ å¥‘ç´„ã—ãŸã•ãã‚‰ã®VPSã§ãƒ¯ãƒ¼ãƒ‰ãƒ—ãƒ¬ã‚¹ã‚’å‹•ã‹ã™ã€‚ ä»Šå›žã¯IPã§ã‚¢ã‚¯ã‚»ã‚¹ã—ã¾ã™ã€‚ ã‚„ã‚‹äº‹ã¯ï¼”ã¤ phpã€apacheã€mysqlã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« mysqlã‚’è¨å®š apacheã‚’è¨å®š wordpressã®è¨å®š 1. phpã€apacheã€mysqlã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã•ãã‚‰ã®ç®¡ç†ç”»é¢ã‹ã‚‰ã¾ãšã¯VPSã‚’èµ·å‹•ã—ã€æ•°åˆ†å¾…ã£ã¦sshã§æŽ¥ç¶šã—ã¾ã™ã€‚ ãã—ã¦ã€æŽ¥ç¶šå¾Œyumã§ã‚µã‚¯ãƒƒã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ ssh [email protected] :(ãƒ¡ãƒ¼ãƒ«ã§å±Šãrootã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ã‚³ãƒ”ãƒšã—ã¦æŽ¥ç¶šã—ã¾ã™) yum update yum install -y mysql-ser
microgravity 2014/10/07
VPS

php

MySQL

WordPress
ãƒªãƒ³ã‚¯
20 Time-Saving WordPress SQL Query Snippets
WordPress stores every single scrap of information within a MySQL database. Posts, pages, comments, shortcodes, plugin settingsâ€¦ absolutely everything. The WordPress backend is fantastic and does allow you to manage and edit everything with ease, but only up to a certain point. Say you have hundreds or even thousands of posts within your database, and you need to make site-wide global changes. Mak
microgravity 2011/03/24
wordpress

MySQL
ãƒªãƒ³ã‚¯
MySQL Practice Wiki
microgravity 2010/07/10
ã¾ã¨ã‚

MySQL
ãƒªãƒ³ã‚¯
1