¤Ê¤Ë¤«¤é¼ê¤ò¤Ä¤±¤ì¤Ð¤è¤¤¤Î¤«¤·¤é¡©
|
Ìܼ¡
|
- Install
- ¥½¡¼¥¹¤Î¥À¥¦¥ó¥í¡¼¥ÉÀè¤È¥Õ¥¡¥¤¥ë̾
- ¥½¡¼¥¹¤«¤é¤Î¥³¥ó¥Ñ¥¤¥ë¤È¥¤¥ó¥¹¥È¡¼¥ë
- ¥Ð¥¤¥Ê¥ê¤«¤é¤Î¥¤¥ó¥¹¥È¡¼¥ë
- Debian ¤Ç¤¢¤ë¤Ê¤é¤³¤Á¤é
- RPM ¤Ç¤¢¤ë¤Ê¤é¤³¤Á¤é
- Slackware ¤Ç¤¢¤ë¤Ê¤é¤³¤Á¤é
- FreeBSD ¤Ê¤é¤³¤Á¤é
- ¤½¤ì°Ê³°¤Ï¤³¤Á¤é
- Install¤Î¤¢¤È
- ¥¤¥ó¥¹¥È¡¼¥ë¤Ï½ª¤Ã¤ÆÆ°¤¤¤Æ¤Þ¤¹¤¬¡¢¤½¤Î¤¢¤È¤Ï¡©
- MySQL¤ò´ÉÍý¤¹¤ë¤Ë¤Ï¡©
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ã¤Æ¤¤¤ï¤ì¤Æ¤â?
- Databse ¤ò¿·¤·¤¯ºîÀ®¤¹¤ë¤Ë¤Ï¡©
- MySQL ¤Î¥æ¡¼¥¶¡¼¤Ã¤Æ¤¤¤ï¤ì¤Æ¤â???
- MySQL ¤Ë¥¢¥¯¥»¥¹¤¹¤ë¥æ¡¼¥¶¡¼¤òÄɲ乤ë¤Ë¤Ï¡©
- »²¹Í»ñÎÁ¡¢¾ðÊó¸»
- ÆüËܸì¥Þ¥Ë¥å¥¢¥ë¤Ï¤³¤Á¤é
- ÆüËܸì Mailing List ¤Ï¤³¤Á¤é
|
ª¡I. Install
¡¡
¡¡- ¡¡1.¥À¥¦¥ó¥í¡¼¥ÉÀè¤È¥Õ¥¡¥¤¥ë̾
¡¡
- MySQL ¤Î¥½¡¼¥¹¤Ï°Ê²¼¤Ë¤¢¤ê¤Þ¤¹¡£
ftp://ftp.softagency.co.jp/mysql/tcx/Downloads/
directory ¤Ï¡¢¥Ð¡¼¥¸¥ç¥ó̾¤¬ÉÕ¤¤¤Æ¤¤¤Þ¤¹¡£
Î㤨¤Ð¡¢3.22.25 ¤Î¥½¡¼¥¹¤¬Íߤ·¤¤¤Ê¤é
ftp://ftp.softagency.co.jp/mysql/tcx/Downloads/MySQL-3.22/mysql-3.22.25.tar.gz
¤É¤Î¥Ð¡¼¥¸¥ç¥ó¤Î¥Õ¥¡¥¤¥ë¤òÁª¤Ö¤«¡©
°ÂÄêÈǤΰìÈֺǶá¤Îʪ¤òÁª¤Ó¤Þ¤¹¡£
¤É¤Î¥Ð¡¼¥¸¥ç¥ó¤¬°ÂÄêÈÇ(Àµ¼°¥ê¥ê¡¼¥¹)¤«¤Ï¡¢¤³¤Á¤é¤Ë½ñ¤¤¤Æ¤¢¤ê¤Þ¤¹
¡¡ - ¡¡2.¥½¡¼¥¹¤«¤é¥³¥ó¥Ñ¥¤¥ë¡õ¥¤¥ó¥¹¥È¡¼¥ë
¡¡- ɬ¿Ü¾ò·ï
GNU gcc, autoconf, flex, bison, gzip, tar ¤¬É¬ÍפǤ¹¡£
MySQL ¥³¥ó¥Ñ¥¤¥ëÁ°¤Ë ¥¤¥ó¥¹¥È¡¼¥ë¤·¤Æ¤ª¤¤Þ¤·¤ç¤¦¡£
¡¡- ¼èÆÀ
- ¡¦¥½¡¼¥¹ Download Àè
directory ¤Ï¡¢¥Ð¡¼¥¸¥ç¥ó̾¤¬ÉÕ¤¤¤Æ¤¤¤Þ¤¹¡£
Î㤨¤Ð¡¢3.22.25 ¤¬Íߤ·¤¤¤Ê¤é
ftp://ftp.softagency.co.jp/mysql/tcx/Downloads/MySQL-3.22/mysql-3.22.25.tar.gz
¤É¤Î¥Ð¡¼¥¸¥ç¥ó¤Î¥Õ¥¡¥¤¥ë¤òÁª¤Ö¤«¡©
°ÂÄêÈǤΰìÈֺǶá¤Îʪ¤òÁª¤Ó¤Þ¤¹¡£
¤É¤Î¥Ð¡¼¥¸¥ç¥ó¤¬°ÂÄêÈÇ(Àµ¼°¥ê¥ê¡¼¥¹)¤«¤Ï¡¢¤³¤Á¤é¤Ë½ñ¤¤¤Æ¤¢¤ê¤Þ¤¹
- Ÿ³«¡õcompile,install ¡¨ MySQL-3.22 °Ê²¼
gzip -dc mysql-3.22.25.tar.gz | tar -xvf -
cd mysql-3.22.25
./configure --with-charset=ujis
make
make install
MySQL ¤ò EUC ´Á»ú¤ËÂбþ¤µ¤»¤¿¤¤¤Ê¤é¡¢
--with-charset=ujis
¤È¤·¡¢SJIS ´Á»ú¤ËÂбþ¤µ¤»¤¿¤¤¤Ê¤é¡¢
--with-charset=sjis
¤ò¡¢./configure ¤Î¥ª¥×¥·¥ç¥ó¤Ë»ØÄꤷ¤Þ¤¹¡£
Ãí°Õ¡§ ¥Ð¡¼¥¸¥ç¥ó 3.23.15 °Ê¾å¤Î MySQL ¤Ç¤Ï¡¢
--with-extra-charsets=all
¤ò»ØÄꤹ¤ë¤È¡¢Æ±»þ¤Ë¾¤Îʸ»ú¤Ë¤âÂбþ¤µ¤»¤ë»ö¤¬²Äǽ¤Ç¤¹¡£
»²¹Í:
¡¦MySQL ¤ÎÆüËܸìÂбþ¤ËÉÕ¤¤¤Æ¤Î TIPS
¡¦¥³¥ó¥Ñ¥¤¥ë¤ËÉÕ¤¤¤Æ¤Î TIPS
- Ÿ³«¡õcompile,install ¡¨ MySQL-3.23
groupadd mysql
useradd mysql
gzip -dc mysql-3.23.24-beta.tar.gz | tar -xvf -
cd mysql-3.23.24-beta
./configure --with-charset=ujis --with-extra-charsets=all --with-mysqld-user=mysql
make
make install
- ¡¡3.DataBase¤Î½é´ü²½
- ¥Ç¡¼¥¿¤òÊݸ¤¹¤ë directory ¤òºîÀ®¤·¤Ê¤¯¤Æ¤Ï¤Ê¤ê¤Þ¤»¤ó¡£
¤³¤ì¤Ï¡¢MySQL ¤ò¤Ï¤¸¤á¤Æ¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿»þ¤Ë¡¢°ìÅÙ¤À¤±¡¢¹Ô¤¨¤Ð¤è¤¤¤³¤È¤Ç¤¹
´û¤Ë¥Þ¥·¥ó¾å¤Ë¥Ç¡¼¥¿ directory ¤¬Â¸ºß¤¹¤ë¾ì¹ç¤Ï¡¢¤³¤Îºî¶È¤ÏɬÍפ¢¤ê¤Þ¤»¤ó¡£
¥Ç¡¼¥¿ directory ¤òºîÀ®¤¹¤ë¤Ë¤Ï¡¢
/usr/local/bin/mysql_install_db
¥³¥Þ¥ó¥É¤ò¼Â¹Ô¤·¤Þ¤¹
3.23 °Ê¾å¤Î MySQL ¤Ç¤Ï¡¢
useradd mysql
/usr/local/bin/mysql_install_db --user=mysql
- ¡¡4.¼Â¹Ô
- /usr/local/bin/safe_mysqld &
3.23 °Ê¾å¤Î MySQL ¤Ç¤Ï¡¢
/usr/local/bin/safe_mysqld --user=mysql &
- ¡¡5.¥Ç¡¼¥¿¤Î¥Õ¥¡¥¤¥ë¤Ï¤É¤³¤Ë¡©
- /usr/local/var/
|
binary packages
a.Debian
¡¡
¡¡- ¡¡Debian 2.2 potato (glibc2.1), Debian 1.3 bo (libc5)
¡¡ - ¤³¤Á¤é
¡¡- Debian ¤Ë´û¤Ë MySQL ¤¬Æþ¤Ã¤Æ¤¤¤Þ¤¹¡£
¤¿¤À¤·¡¢±Ñ¸ì¥Ð¡¼¥¸¥ç¥ó¤Ç¤¹¡£
ÆüËܸì¤ò»ÈÍѤ·¤¿¤¤¾ì¹ç¤Ï¡¢
1. Debian ¤Î¥ß¥é¡¼¥µ¥¤¥È¤«¤é¥½¡¼¥¹¤ò»ý¤Ã¤ÆÍè¤Æ
--with-charset=ujis (¤â¤·¤¯¤Ï sjis)¤Çºî¤êľ¤¹¡£
¤«¡¢
2. ¤³¤Á¤é¤ÎÆüËܸìÂбþ¥Ñ¥Ã¥±¡¼¥¸¤òÍøÍѤ¹¤ë¡£
¤¿¤À¤·¡¢Àµ¼°¤Î Debian ¥Ñ¥Ã¥±¡¼¥¸¤Ë¤Ïź¤Ã¤Æ¤¤¤Þ¤»¤ó¡£
- ¡¡Debian 2.0 hamm, 2.1 slink
- ¤¢¤ê¤Þ¤»¤ó¡£
hamm, slink ¤Ï»ÈÍѤ·¤Ê¤¤¤è¤¦¤Ë¡£potato °Ê¾å¤ò¿ä¾©¤·¤Þ¤¹¡£
|
b.RPM
¡¡- ¡¡´Ý°æ»áºî¡¢MySQL-3.22 rpm
¡¡ - ¤³¤Á¤é¤Ï MySQL-3.22 ¤ÎÆüËܸ졣¤Æ¤Ã¤È¤ê¤Ð¤ä¤¯¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë¤Ê¤é¤³¤Á¤é¡£
ftp://ftp.softagency.co.jp/mysql/japan/rpm/MARUI/
ujis ¤¬¤Ä¤¤¤Æ¤¤¤ë¤Î¤Ï EUC japanese ÍÑ¥µ¡¼¥Ð¡¼
sjis ¤Ï Shift JIS ÍÑ¥µ¡¼¥Ð¡¼
¥Õ¥¡¥¤¥ë̾¤Î̿̾µ¬Â§¤Ï¡¢²¼¤Î TCX ¤Î¥Ð¥¤¥Ê¥ê¤Ë½àµò¤·¤Æ¤Þ¤¹¡£
0_README ¥Õ¥¡¥¤¥ë¤ò¤«¤Ê¤é¤ºÆÉ¤ß¤Þ¤¹
- ¡¡TCX binaries
¡¡ - TCX ¤Ï rpm ¥Ñ¥Ã¥±¡¼¥¸¤òÄ󶡤·¤Æ¤¤¤Þ¤¹¡£¤¿¤À¤· MySQL-3.22 ¤Ï±Ñ¸ì¤Ç¤¹¡£(3.23 °Ê¾å¤Ç¤Ï¡¢µ¯Æ°»þ¤Î¥ª¥×¥·¥ç¥ó¤ÇÆüËܸìʸ»ú¤ËÂбþ¤·¤Þ¤¹¡£)
¤·¤¿¤¬¤Ã¤Æ¡¢MySQL-3.22 ¤Î¾ì¹ç¤Ï¡¢src ¥Ñ¥Ã¥±¡¼¥¸¤ò¼èÆÀ¤·¤Æ --with-charset=ujis ¤Ç¥Ñ¥Ã¥±¡¼¥¸ºî¤êľ¤·¤Ç¤¹¡£
¥½¡¼¥¹ Download Àè
directory ¤Ï¡¢¥Ð¡¼¥¸¥ç¥ó̾¤¬ÉÕ¤¤¤Æ¤¤¤Þ¤¹¡£
Î㤨¤Ð¡¢3.22.25 ¤¬Íߤ·¤¤¤Ê¤é
ftp://ftp.softagency.co.jp/mysql/tcx/Downloads/MySQL-3.22/
MySQL-3.23 ¤Î¾ì¹ç¤Ë¤Ï¡¢TcX ¤Î¥Ð¥¤¥Ê¥ê¤¬¤½¤Î¤Þ¤Þ»ÈÍѤǤ¤Þ¤¹¡£
¤¿¤À¤·µ¯Æ°»þ¤Ë¥ª¥×¥·¥ç¥ó
--default-charset=ujis
¤òÍ¿¤¨¤ë¤«¡¢ /etc/my.cnf ¥Õ¥¡¥¤¥ë¤Ë¡¢
default-charset=ujis
¤Èµ½Ò¤¹¤ë»ö¤Ç¡¢ÆüËܸì¤ËÂбþ¤·¤Þ¤¹¡£
RPM ¤Î¥Õ¥¡¥¤¥ë̾¤Îµ¬Â§¤Ï¡§
|
ª¢II. Install¤Î¤¢¤È
¡¡
¡¡- ¡¡1.¥¤¥ó¥¹¥È¡¼¥ë¤Ï½ª¤ï¤Ã¤ÆÆ°¤¤¤Æ¤¤¤Þ¤¹¤¬¡¢¤½¤Î¤¢¤È¤Ï¡©
shell # mysql
¤È¤ä¤Ã¤Æ¤ß¤Þ¤·¤ç¤¦¡£¤Á¤ã¤ó¤ÈÀܳ¤Ç¤¤ì¤Ð¡¢
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3325 to server version: 3.22.25
Type 'help' for help.
mysql> |
¤Èɽ¼¨¤µ¤ì¤Þ¤¹¡£
¤³¤Î¤¢¤È¡¢»î¤·¤Ëtest¥Ç¡¼¥¿¥Ù¡¼¥¹¤ËÀܳ¤·¤Æ¤ß¤Þ¤¹
mysql> use test;
mysql> show tables;
mysql> create table t1 (a char(10));
mysql> insert into t1 values ('aaa');
mysql> insert into t1 values ('¤¢');
mysql> select * from t1;
ÆüËܸ줬¤Ï¤¤¤é¤Ê¤¤¾ì¹ç¤Ï¡©
¤½¤Î¾ì¹ç¤Ï kterm(rxvt) ¤Îʸ»ú¥³¡¼¥É(EUC ¤È¤«) ¤È MySQL ¤Îʸ»ú¥³¡¼¥É¤¬(--with-charset=ujis) Ʊ¤¸¤«³Îǧ¤·¤Þ¤·¤ç¤¦¡£
(üËö¤¬ EUC ¤Ê¤é MySQL ¤Î --with-charset ¤Ï ujis.
üËö¤¬ SJIS ¤Ê¤é MySQL ¤Î --with-charset ¤Ï sjis.)
Îɤ¯Ê¬¤«¤é¤Ê¤±¤ì¤Ð¡¢°Ê²¼¤Î¤è¤¦¤Ë¤·¤Æ¡¢Ê¸¤ò½ñ¤¤¤¿¥Õ¥¡¥¤¥ë¤ò¼Â¹Ô¤¹¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£
shell # mysql test < a.euc
¤³¤³¤Ç a.euc ¤Ï EUC ¥³¡¼¥É¤Î¥Õ¥¡¥¤¥ë¤Ç¡¢¤½¤ÎÃæ¿È¤Ï
insert into t1 values ('¤¢');
|
¡¡2.MySQL¤ò´ÉÍý¤¹¤ë¤Ë¤Ï¡©
mysqladmin ¥³¥Þ¥ó¥É¤ò»ÈÍѤ·¤Þ¤¹¡£
shell # mysqladmin --help
¤È¤¹¤ì¤Ð¡¢¤¿¤¯¤µ¤ó¡¢¥³¥Þ¥ó¥É¤¬É½¼¨¤µ¤ì¤Þ¤¹¡£
¤¿¤È¤¨¤Ð¡¢MySQL ¤ò¤È¤á¤Æ¤·¤Þ¤¦¤Ë¤Ï¡¢
shell # mysqladmin shutdown
¥æ¡¼¥¶¡¼¤¬¤É¤¦¤Î¤Èʸ¶ç¤ò¸À¤ï¤ì¤ë¾ì¹ç¤Ï¡©
¤½¤Î¾ì¹ç¤Ï¡¢
shell # mysqladmin -uroot shutdown
¤È¤ä¤Ã¤Æ¤ß¤Þ¤·¤ç¤¦¡£
¡¡¡¡3.MySQL¤¬¤â¤Ä`¥Ç¡¼¥¿¥Ù¡¼¥¹'¡©
MySQL ¤Î¥Þ¥Ë¥å¥¢¥ë¤ä¡¢¤¢¤ë¤¤¤Ï¤³¤Î Web page ¤Ç¤Ï¡¢
¡ÖMySQL ¤Î xx ¤È¤¤¤¦¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë...¡× ¤È¤¤¤¦¸ÀÍÕ¤ò»È¤¦¾ì¹ç¡¢
¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÍýÏÀ¡¢³µÇ°¤ò»Ø¤¹¤Î¤Ç¤Ï¤Ê¤¯¡¢
¸½¼Â¤Ë MySQL ¥µ¡¼¥Ð¡¼Æâ¤ËºîÀ®¤µ¤ì¤¿¡¢¥Ç¡¼¥¿¤òÊÝ»ý¤¹¤ëʪ¤ò»Ø¤·¤Þ¤¹¡£
¤³¤ì¤Ï¼ÂºÝ¤Ë¤Ï directory ¤Ç¤¹¡£
¤³¤Îdirectory ¤Ï¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÈƱ¤¸Ì¾Á°¤ÇºîÀ®¤µ¤ì¤Þ¤¹¡£
¤³¤ÎÃæ¤Ë¡¢"¥Æ¡¼¥Ö¥ë" ¤¬ºîÀ®¤µ¤ì¡¢¤½¤Î¥Æ¡¼¥Ö¥ë¤ÎÃæ¤Ë¡¢¥Ç¡¼¥¿¤¬Æþ¤ê¤Þ¤¹¡£
¥Æ¡¼¥Ö¥ë¤Ï¡¢¥Æ¡¼¥Ö¥ë̾¤ÈƱ¤¸Ì¾Á°¤Î¥Õ¥¡¥¤¥ë¤¬ºîÀ®¤µ¤ì¤Þ¤¹¡£
(windows ¤ä Macintosh ¤Ç¤Ï¡¢ÅùÉý¥Õ¥©¥ó¥È¤Ç¸«¤Æ¤¯¤À¤µ¤¤)
¥¤¥á¡¼¥¸¿Þ
+-- MySQL Server -----------------------------------------+
| +- mysql ¥Ç¡¼¥¿¥Ù¡¼¥¹ -+ +- test ¥Ç¡¼¥¿¥Ù¡¼¥¹ -+ |
| | user ¥Æ¡¼¥Ö¥ë | | a ¥Æ¡¼¥Ö¥ë | |
| | db ¥Æ¡¼¥Ö¥ë | | | |
| | host ¥Æ¡¼¥Ö¥ë | | | |
| | tables_priv ¥Æ¡¼¥Ö¥ë| | | |
| | column_priv ¥Æ¡¼¥Ö¥ë| | | |
| +----------------------+ +---------------------+ |
+---------------------------------------------------------+
|
¥Ç¡¼¥¿¥Ù¡¼¥¹¤òǼ¤á¤ë directory ¤Ï¡¢¥½¡¼¥¹¤«¤é¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿¾ì¹ç¤Ë¤Ï¡¢
(./configure »þ¤ËÆÃÊ̤ÊÃͤòÍ¿¤¨¤Æ¤¤¤Ê¤¤¾ì¹ç)
/usr/local/var/ ¤Ë¤Ê¤ê¤Þ¤¹¡£
¤³¤Î²¼¤Ë¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÈƱ̾¤Î directory ¤¬ºîÀ®¤µ¤ì¤Þ¤¹¡£
¡¡¡¡4.Database¤ò¿·¤·¤¯ºî¤ë¤Ë¤Ï¡©
mysqladmin ¥³¥Þ¥ó¥É¤ò»ÈÍѤ·¤Þ¤¹¡£
shell # mysqladmin create db_name
¤È¤¹¤ì¤Ð¡¢"db_name" ¤È¤¤¤¦¥Ç¡¼¥¿¥Ù¡¼¥¹¤¬¿·µ¬¤ËºîÀ®¤µ¤ì¤Þ¤¹¡£
¥æ¡¼¥¶¡¼¤¬¤É¤¦¤Î¡¢¥Ñ¥¹¥ï¡¼¥É¤¬¤É¤¦¤À¡¢¤È¥³¥Þ¥ó¥É¤Ëʸ¶ç¤ò¸À¤ï¤ì¤ë¾ì¹ç¤Ï¡©
¤½¤Î¾ì¹ç¤Ï
shell # mysqladmin -uroot create db_name
¤È¤ä¤Ã¤Æ¤ß¤Þ¤·¤ç¤¦¡£
¡¡¡¡5.MySQL¤Î¥æ¡¼¥¶¡¼¡©
MySQL ¤Ï¡¢MySQL ¤ËÂФ·¤Æ¥¢¥¯¥»¥¹¤¹¤ë¥æ¡¼¥¶¡¼¤ò¡¢
MySQL ¼«¿È¤¬, "mysql" ¥Ç¡¼¥¿¥Ù¡¼¥¹Æâ¤Ë, ÊÝ»ý¤·¤Æ¤¤¤Þ¤¹¡£
¤³¤Î¥æ¡¼¥¶¡¼¤Ï¡¢OS ¼«¿È¤¬´ÉÍý¤·¤Æ¤¤¤ë¥æ¡¼¥¶¡¼¤È¤Ï̵´Ø·¸¡¢ÆÈΩ¤·¤¿¤â¤Î¤Ç¤¹¡£
¤³¤Î¾ðÊó¤ò¤â¤È¤Ë¤·¤Æ¡¢client ¤«¤é¤ÎÀܳ¤òµñÈݤ·¤¿¤ê¤·¤Þ¤¹¡£
(windows ¤ä Macintosh ¤Ç¤Ï¡¢ÅùÉý¥Õ¥©¥ó¥È¤Ç¸«¤Æ¤¯¤À¤µ¤¤)
¥¤¥á¡¼¥¸¿Þ
+-- MySQL Server ---------------------+
| +- mysql ¥Ç¡¼¥¿¥Ù¡¼¥¹ ----------+ |
| | [ login ID: user1 | |
| | Password: pika | |
| | user1 ¤Î¥¢¥¯¥»¥¹À©¸Â¾ðÊó ] | |
| +-------------------------------+ |
+-------------------------------------+
^
| [ login ID: user1 ; Password: pika ¤ÇÀܳ¤ò»î¤ß¤ë ]
client1
¤³¤ÎÎã¤Ç¤Ï¡¢MySQL ¤Ë¤Ï¡¢ user1 (¥Ñ¥¹¥ï¡¼¥É¤Ï pika) ¤¬ÅÐÏ¿¤µ¤ì¤Æ¤¤¤ë
¤¢¤ë¿Í¤¬¡¢¤¢¤ë¥Þ¥·¥ó(client1) ¤«¤é, user1, ¥Ñ¥¹¥ï¡¼¥É pika ¤Ç MySQL ¤ËÀܳ¤ò»î¤ß¤ë
|
¤Ê¤ª¡¢¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿¤Ð¤«¤ê¤Î MySQL ¤Ë¤Ï¡¢
login ID : root
Password : ¤Ê¤·
¼Â¹Ô¤Ç¤¤ë¥³¥Þ¥ó¥É¤ÎÀ©¸Â: ¤Ê¤·
MySQL ¥µ¡¼¥Ð¡¼¤ËÀܳ¤Ç¤¤ë client ¤Î IP address : 127.0.0.1 (localhost)
¤Î¥æ¡¼¥¶¡¼¤¬ÅÐÏ¿¤µ¤ì¤Æ¤¤¤Þ¤¹¡£
¤³¤ì¤Ï¡¢MySQL ¥µ¡¼¥Ð¡¼¤¬¼Â¹Ô¤µ¤ì¤Æ¤¤¤ë¥Þ¥·¥ó¾å¤Ç,
shell# mysql -uroot
¤È¹Ô¤¦¤À¤±¤Ç¡¢Á´¤Æ¤ÎÁàºî¤¬¤Ç¤¤ë¤È¤¤¤¦»ö¤Ç¤¹¡£
¡¡¡¡6.MySQL¤Ë¥¢¥¯¥»¥¹¤¹¤ë¥æ¡¼¥¶¡¼¤òÄɲ乤ë¤Ë¤Ï¡©
shell # mysql -uroot mysql
mysql>
¤È¡¢"mysql" ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¥¢¥¯¥»¥¹¤·¤Þ¤¹¡£
¤³¤³¤Ç¡¢"god" ¤È¤¤¤¦¥æ¡¼¥¶¡¼¤òÄɲ䷤Ƥߤޤ·¤ç¤¦¡£
¤³¤Î¥æ¡¼¥¶¡¼¤ÏÁ´¤Æ¤Î¥Þ¥·¥ó¤«¤é¡¢Á´¤Æ¤Î databse ¤Ë¥¢¥¯¥»¥¹¤Ç¤¤ë¤è¤¦¤Ë¤·¤Æ¤ß¤Þ¤¹¡£
¥Ñ¥¹¥ï¡¼¥É¤Ï "speed" ¤Ç¤¹¡£
¤µ¤é¤Ë¤³¤Î¿Í¤ÏÁ´¤Æ¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ËÂФ·¤ÆÁ´¤Æ¤ÎÁàºî¤ò¤Ç¤¤ë¤è¤¦¤Ë¤·¤Æ¤ß¤Þ¤¹¡£
mysql> GRANT ALL PRIVILEGES ON *.* TO god IDENTIFIED BY 'speed';
mysql> GRANT ALL PRIVILEGES ON *.* TO god@localhost IDENTIFIED BY 'speed';
(Ãí°Õ¡§¤¢¤Þ¤ê¤³¤¦¤¤¤¦ god ¤µ¤ó¤Î¤è¤¦¤Ê¥æ¡¼¥¶¡¼¤Ïºî¤é¤Ê¤¤¤Û¤¦¤¬¤¤¤¤¤Ç¤¹¡£´·¤ì¤¿¤é¡¢À©¸Â¤·¤Þ¤·¤ç¤¦¡£)
¼¡¤Ë¡¢"lupin" ¤È¤¤¤¦¥æ¡¼¥¶¡¼¤òÄɲ䷤Ƥߤޤ·¤ç¤¦¡£
¤¿¤À¤·¡¢"lupin" ¤µ¤ó¤Ï¡¢¾¯¡¹°µº¿´¤¬¤¢¤ë¤Î¤Ç¡¢°Ê²¼¤ÎÀ©¸Â¤ò²Ã¤¨¤ë¤³¤È¤Ë¤·¤Þ¤·¤ç¤¦¡£
- ¥Û¥¹¥È '192.168.1.100' ¤«¤é¤·¤«, MySQL ¤Ë¥¢¥¯¥»¥¹¤Ç¤¤Ê¤¤
- "jigen" ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÃæ¤Î¡¢"goemon" ¤È¤¤¤¦¥Æ¡¼¥Ö¥ë¤·¤«¥¢¥¯¥»¥¹¤Ç¤¤Ê¤¤
- ¤·¤«¤â SELECT ʸ¤À¤±¤·¤«¼Â¹Ô¤Ç¤¤Ê¤¤
- ¥Ñ¥¹¥ï¡¼¥É¤Ï 'fujiko-chan'
mysql> GRANT SELECT ON jigen.goemon TO lupin@192.168.1.100 IDENTIFIED BY 'fujiko-chan';
¥æ¡¼¥¶¡¼¤òÅÐÏ¿¡¢Êѹ¹¤·¤¿¸å¤Ï¡¢
mysql> FLUSH PRIVILEGES ;
¤ò¹Ô¤¤¤Þ¤¹¡£¤¢¤ë¤¤¤Ï shell ¤«¤é
shell# mysqladmin reload
¤È¤·¤Þ¤¹¡£
¥æ¡¼¥¶¡¼ÄɲÃÊѹ¹¸å¤Î¤³¤ì¤é¤Î¥³¥Þ¥ó¥É¤òÊʤˤ·¤Æ¤ª¤¯¤È°ÂÁ´¤Ç¤¹¡£
(Ãí°Õ¡§ GRANT ¥³¥Þ¥ó¥É¤¬»ÈÍѤǤ¤ë¤Î¤Ï¡¢GRANT ¸¢¸Â¤ò¤â¤Ä¥æ¡¼¥¶¡¼¤À¤±¤Ç¤¹
¤³¤ÎÎã¤Ç¤Ï¡¢root ¤Ç¤¹)
¥æ¡¼¥¶¡¼¤ËÉÕ¤¤¤Æ¤Î¤µ¤é¤Ê¤ë ¾ðÊó¤Ï¡¢
MySQL ¤Î¥æ¡¼¥¶¡¼µö²ÄÅÐÏ¿¡©
MySQL ¤Î¿· GRANT ¤ÎƳÆþ (3.22.11°Ê¾å)
¥æ¡¼¥¶¡¼µö²ÄÅÐÏ¿¤¬»×¤¤Ä̤ê¤Ëư¤«¤Ê¤¤¾ì¹ç