2015/08/22 YAPC::Asia Tokyo 2015 Lightning Talk 2016/01/13 update about default_password_lifetime will be 0Read less

2015/08/22 YAPC::Asia Tokyo 2015 Lightning Talk 2016/01/13 update about default_password_lifetime will be 0Read less
2013å¹´10æ25æ¥ã«ãªã©ã¯ã«ã§éå¬ããããMySQL Casual Talks Vol.5ãã«åå ãã¾ããã ãããååã®çºè¡¨ã§ã®ç´æãæããããã«ãã¨ãã訳ã§ä»åã¯2åç®ã®åå ï¼2度ç®ã®ãã¼ã¯ã§ãã çºè¡¨ãã¼ã Tritonn (MySQL5.0.87+Senna)ããã® mroonga (MySQL5.6) 移è¡ä½é¨è¨ MySQL5.0ãã5.6ã¸ç§»è¡ããã«ããããå ¨ææ¤ç´¢æ©è½ãTritonnããmroongaã¸ä¹ãæããã¨ããããã¸ã§ã¯ãã®ä½é¨è¨ããå±ããã¾ãã çºè¡¨è³æ Tritonn (MySQL5.0.87+Senna)ããã® mroonga (MySQL5.6) 移è¡ä½é¨è¨ from Kentaro Yoshida http://www.slideshare.net/y-ken/mysql-migrate-mysql50-to-mysql56-with-fulltext
MySQL 5.6.10 以ä¸ã«åå¨ãã ã¬ããªã±ã¼ã·ã§ã³ã®ãã°ã¨åå ç¹å®ã«ã¤ã㦠(Heartbeats 社å åå¼·ä¼ 2014/12/11)
[root@centos ~]# vi /etc/my.cnfãâãMySQLè¨å®ãã¡ã¤ã«ç·¨é [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 character-set-server = utf8ãâã追å (MySQLãµã¼ãã¼ã®æåã³ã¼ããUTF-8ã«ãã) [root@centos ~]# /etc/rc.d/init.d/mysqld startãâãMySQLèµ·å MySQL ãã¼ã¿ãã¼ã¹ãåæåä¸: Installing MySQL system tables... OK Filling he
ã»æ¬æ ¼çãªããã°ã©ãã³ã°ãå¦ã³ããå ´å㯠Javaåå¿è å ¥éè¬åº§ ã次ã®ã¹ãããã¨ãã¦ãæ´»ç¨ãã ããã ã»Webç³»ã®ããã°ã©ãã³ã°ãå¦ã³ããå ´å㯠PHPåå¿è å ¥éè¬åº§ ã次ã®ã¹ãããã¨ãã¦ãæ´»ç¨ãã ããã MySQLã®ãã¼ã¿ãã¼ã¹ãæä½ããã«ã¯ãããããªæ¹æ³(管çãã¼ã«)ãããã¾ãã æä½ã¨ã¯ããã¼ã¿ãã¼ã¹ããã¼ãã«ãã¯ã¨ãªãªã©ã¸å¯¾ããåç §ã»ä½æã»è¿½å ã»ä¿®æ£ã»åé¤ãªã©ã®ãã¨ã§ãã ããã¾ã§ã«ãå½å ¥éè¬åº§ã§ã¯ã ã³ãã³ãããã³ãããAccessã使ã£ãæ¹æ³ãç´¹ä»ãã¦ãã¾ãããã ããä¸åº¦ã¾ã¨ãã¦ã¿ã¾ãã MySQLããã½ã³ã³ã«ã¤ã³ã¹ãã¼ã«ããã¨ã Windowsä»å±ã®ã³ãã³ãããã³ãããããã³ãã³ãã©ã¤ã³ã§æä½ã§ããããã«ãªãã¾ãã ããã¯è¬åº§ã®æé ã§ãMySQLã®binãã©ã«ãã«ç°å¢å¤æ°ã®PATHãéããããã MySQLé¢ä¿ã®ããã°ã©ã ãããã«å®è¡ã§ããããã§ãã ã§ãã³ãã³ãããã³ã
ã©ã³ãã³ã°
é害
ã©ã³ãã³ã°
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}