SoftAgency Index NEW MySQL Company PressRelease Link




¤Ê¤Ë¤«¤é¼ê¤ò¤Ä¤±¤ì¤Ð¤è¤¤¤Î¤«¤·¤é¡©

Ìܼ¡
  1. Install
    1. ¥½¡¼¥¹¤Î¥À¥¦¥ó¥í¡¼¥ÉÀè¤È¥Õ¥¡¥¤¥ë̾
    2. ¥½¡¼¥¹¤«¤é¤Î¥³¥ó¥Ñ¥¤¥ë¤È¥¤¥ó¥¹¥È¡¼¥ë
    3. ¥Ð¥¤¥Ê¥ê¤«¤é¤Î¥¤¥ó¥¹¥È¡¼¥ë
      1. Debian ¤Ç¤¢¤ë¤Ê¤é¤³¤Á¤é
      2. RPM ¤Ç¤¢¤ë¤Ê¤é¤³¤Á¤é
      3. Slackware ¤Ç¤¢¤ë¤Ê¤é¤³¤Á¤é
      4. FreeBSD ¤Ê¤é¤³¤Á¤é
      5. ¤½¤ì°Ê³°¤Ï¤³¤Á¤é
  2. Install¤Î¤¢¤È
    1. ¥¤¥ó¥¹¥È¡¼¥ë¤Ï½ª¤Ã¤ÆÆ°¤¤¤Æ¤Þ¤¹¤¬¡¢¤½¤Î¤¢¤È¤Ï¡©
    2. MySQL¤ò´ÉÍý¤¹¤ë¤Ë¤Ï¡©
    3. ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ã¤Æ¤¤¤ï¤ì¤Æ¤â?
    4. Databse ¤ò¿·¤·¤¯ºîÀ®¤¹¤ë¤Ë¤Ï¡©
    5. MySQL ¤Î¥æ¡¼¥¶¡¼¤Ã¤Æ¤¤¤ï¤ì¤Æ¤â???
    6. MySQL ¤Ë¥¢¥¯¥»¥¹¤¹¤ë¥æ¡¼¥¶¡¼¤òÄɲ乤ë¤Ë¤Ï¡©
  3. »²¹Í»ñÎÁ¡¢¾ðÊó¸»
    1. ÆüËܸì¥Þ¥Ë¥å¥¢¥ë¤Ï¤³¤Á¤é
    2. ÆüËܸì 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 ¤Î¥Õ¥¡¥¤¥ë̾¤Îµ¬Â§¤Ï¡§
MySQL-%{version}-%{release}.i386.rpmMySQL¥µ¡¼¥Ð¡¼ ɬ¿Ü
MySQL-client-%{version}-%{release}.i386.rpmMySQL client ɬ¿Ü
MySQL-devel-%{version}-%{release}.i386.rpmMySQL ³«È¯ÍÑ ¿ä¾©
MySQL-bench-%{version}-%{release}.i386.rpmbench mark test. ¤¤¤é¤Ê¤¤


c.¥Ï¥Þ»áºî¡¢Slackware MySQL-3.21 package
¡¡
¤³¤Á¤é¤Ç¤¹
¡¡
ftp://ftp.softagency.co.jp/mysql/japan/slackware/HAMA/


d.FreeBSD

°ìÉô¤Î¥Ð¡¼¥¸¥ç¥óÍѤΥХ¤¥Ê¥ê¤Ï¤³¤Á¤é
¤â¤·¥Ð¥¤¥Ê¥ê¥Ñ¥Ã¥±¡¼¥¸¤Î¤Ê¤¤ ¥Ð¡¼¥¸¥ç¥ó¤Î¾ì¹ç¡¢ports ¤¬¤¢¤ë¤Î¤Ç¤½¤Á¤é¤ò¤Ä¤«¤¤¤Þ¤·¤ç¤¦¡£
--with-charset=ujis ¤« --with-charset=sjis ¤ò ports ¤Î Makefile ¤ËÉÕ¤±¤Þ¤¹¡£

ports ¤¬Ê¬¤«¤é¤Ê¤±¤ì¤Ð¡¢ÉáÄ̤Τä¤êÊý¤Ç
¤¿¤À¤· gcc, gmake ¤ò»ÈÍѤ·¤Þ¤¹¡£



ª¢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" ¤µ¤ó¤Ï¡¢¾¯¡¹°­µº¿´¤¬¤¢¤ë¤Î¤Ç¡¢°Ê²¼¤ÎÀ©¸Â¤ò²Ã¤¨¤ë¤³¤È¤Ë¤·¤Þ¤·¤ç¤¦¡£

  1. ¥Û¥¹¥È '192.168.1.100' ¤«¤é¤·¤«, MySQL ¤Ë¥¢¥¯¥»¥¹¤Ç¤­¤Ê¤¤
  2. "jigen" ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÃæ¤Î¡¢"goemon" ¤È¤¤¤¦¥Æ¡¼¥Ö¥ë¤·¤«¥¢¥¯¥»¥¹¤Ç¤­¤Ê¤¤
  3. ¤·¤«¤â SELECT ʸ¤À¤±¤·¤«¼Â¹Ô¤Ç¤­¤Ê¤¤
  4. ¥Ñ¥¹¥ï¡¼¥É¤Ï '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°Ê¾å)
  • ¥æ¡¼¥¶¡¼µö²ÄÅÐÏ¿¤¬»×¤¤Ä̤ê¤Ëư¤«¤Ê¤¤¾ì¹ç

    TIPS¥È¥Ã¥×¤ËÌá¤ë
    MySQL¤Î¥Ú¡¼¥¸
    Copyright (c) 1997-2000 SoftAgency Co., Ltd. All rights reserved.