MySQL¤Îroot¥Ñ¥¹¡¦E¼¥É¤ò˺¤¡¦E¿¾¡¦Eç¤ÎÂнè¤Ë¤Ä¤¤¤¡¦/h3>
¥¹¥Ý¥ó¥µ¡¼¥É¡¦E󥡦/p>
MySQL¤Ï¥ª¡¼¥×¥ó¥½¡¼¥¹¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¤Ë¤Ê¤ê¤Þ¤¹¡£
̵ÎÁ¤ÇÍøÍѤǤ¡¦EÇ¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¤È¤·¤¡¦ostgreSQL¤¬¤¢¤ê¤Þ¤¹¤¬¡¢
¤½¡¦Eȿ͵¤¤òÆóÊ¡¦¹¤¡¦EÇ¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¤Ç¤¹¡¡¦/p>
¿Íµ¤¤ÎÍýͳ¤Ï¹âÀǽ³ûÀĹ⮤ǡ¢¤·¤«¤âÁàºûÀ¬Èæ³ÓŪ´Êñ¤Ê¾å¡¢
Movable Type¤äXoops¤Ê¤É¿¤¯¤Î¥¦¥§¥Ö¥µ¥¤¥È¹½ÃÛ¥½¥Õ¥È¥¦¥§¥¢¤¬
¥µ¥Ý¡¼¥È¤·¤Æ¤¤¡¦E¿¤á¤Ç¤¹¡¡¦Þ¤¡¦ySQL¤òÍøÍѤ¹¡¦E¡¦¡¦AMP´Ä¶¤¬
¹½ÃÛ½ÐÍè¤Þ¤¹¡£
¢¨LAMP¤È¤ÏLinux¡¢Apache¡¢ MySQL¡¢ PHP¤Îά¾Î
º£²ó¤Ï¤½¤ÎMySQL¡¦EѤ¡¦oot¥Ñ¥¹¡¦E¼¥É¤ò˺¤¡¦EƤ·¤Þ¤Ã¤¿¾¡¦E礡¦br />
ÂнèÊýË¡¤ò¤´¾Ò²ð¤·¤Þ¤¹¡£
MySQL¤Îroot¥Ñ¥¹¡¦E¼¥É¤òºÆÀßÄꤹ¤¡¦E/strong>
£±.Mysql¤ÎÄä»ß¤Èµ¯Æ°¤ò¤¹¡¦E/strong>
[root@Tiger ~]# /etc/rc.d/init.d/mysql stop
Shutting down MySQL. [ OK ]
[root@Tiger ~]# /etc/rc.d/init.d/mysql start --skip-grant-tables
Starting MySQL.
¡Ö/etc/rc.d/init.d/mysql stop¡×¤ÇMySQL¤òÄä»ß¤·¡¢
¡Ö/etc/rc.d/init.d/mysql start --skip-grant-tables¡×¤Ç
MySQL¤ò¥»¡¼¥Õ¥â¡¼¥É¤Çµ¯Æ°¤·¤Þ¤¹¡£
¡Ö--skip-grant-tables¡×¥ª¥×¥·¥ç¥ó¤òÉÕÍ¿¤·¤ÆMySQL¤òÆ°¤¹¡¦EÇ¡¡¦br />
¥æ¡¼¥¶¡¼¸¢¸Â¤Î¥Á¥§¥Ã¥¯¤ò¥¹¥¥Ã¥×¤·¤¿¾õÂÖ¤ÇMySQL¥µ¡¼¥Ð¤¬µ¯Æ°¤·¤Þ¤¹¡£
£².MySQL¤ËÀܳ¤¹¡¦E/strong>
[root@Tiger ~]# /usr/local/mysql/bin/mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
MySQL¥æ¡¼¥¶¡¼¤Îroot¤ÇÀܳ¤·¤Þ¤¹¡£¡Ö--skip-grant-tables¡×¥ª¥×¥·¥ç¥ó¤Ç
µ¯Æ°¤·¤Æ¤¤¡¦E¿¤á¡¢¥Ñ¥¹¥¡¦E¼¥É¤¡¦á¤á¤é¤¡¦EÞ¤»¤ó¡¡¦/p>
£³.MySQL¤Îroot¥Ñ¥¹¡¦E¼¥É¤òÀßÄꤹ¤¡¦E/strong>
mysql> UPDATE user SET Password=PASSWORD('xxxxxxx') WHERE User='root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
¡ÖUPDATE user SET Password=PASSWORD('xxxxxxx') WHERE User='root';¡×¤Ç
root¤Î¥Ñ¥¹¡¦E¼¥É¤òºÆÀßÄꤷ¤Þ¤¹¡¡¦¡¦xxxxxx¡×¤Î²Õ½ê¤Ë¤Ï¿·¥Ñ¥¹¡¦E¼¥É¤¡¦Ebr />
ÀßÄꤷ¤Æ¤¯¤À¤µ¤¤¡£
¡ÖFLUSH PRIVILEGES;¡×¤ÇÀßÄê¤òÈ¿±Ç¤µ¤»¡¢¡Öexit¡×¤ÇMySQL¤ÎÀܳ¡¦Ebr />
ÀÚ¤ê¤Þ¤¹¡£
£´.MySQL¤òÄÌ¡¦E⡼¥É¤ÇºÆµ¡¦°¤·¤Þ¤¹¡¡¦/strong>
[root@Tiger ~]# /etc/rc.d/init.d/mysql restart
Shutting down MySQL.. [ OK ]
Starting MySQL. [ OK ]
MySQL¤òÄÌ¡¦E⡼¥É¤ÇºÆµ¡¦°¤·¤Þ¤¹¡¡¦/p>
£µ.¿·¥Ñ¥¹¡¦E¼¥É¤Ç¥úÁ°¥¤¥ó¤Ç¤¤¡¦E¡¦Îǧ¤ò¹Ô¤¡¦/strong>
[root@Tiger ~]# /usr/local/mysql/bin/mysql -u root -p
Enter password:¡¡¡¡¡¡¢«£³¤ÇÀßÄꤷ¤¿¥Ñ¥¹¡¦E¼¥É¤òÆ¡¦Ï¤·¤Þ¤¹¡¡¦/em>
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
¡ÖEnter password¡§¡×¤Ë£³¤Î¡Öxxxxxxx¡×¤ÇÀßÄꤷ¤¿¥Ñ¥¹¡¦E¼¥É¤òÆ¡¦Ï¤¡¦br />
¡¦Á°¥¤¥ó¤Ç¤¡¦EÐÀ¡¦ù¤Ç¤¹¡¡¦/p>
¢¨ Linux Web¥µ¡¼¥Ð¡¼¹½Ã۹ֺ¡ھåµéÊÔ¡Û¤ò¼õ¹Ö¤·¤Æ¤¤¡¦E¡¦¡¦br />
¡¡ crontab¤ÇÀßÄꤷ¤Æ¤¤¡¦E¡¦heck_process.pl¡×¥¹¥¯¡¦EץȤòºÇ½é¤¡¦br />
¡¡Ìµ¸ú¤Ë¤¹¡¦E³¤È¤ò¤¡¦º¤¡¦Eʤ¡¦¡¦br />
¡¡¾Ü¤·¤¯¤Ï¼õ¹ÖÀ¸¡¦EÑ¥µ¥Ý¡¼¥È¥Õ¥¡¦¼¥é¥à¤ËÌÀµ¤·¤Æ¤¤¤Þ¤¹¤Î¤¡¦br />
¡¡¤´³Îǧ¤¯¤À¤µ¤¤¡£
º£²ó¤´¾Ò²ð¤·¤¿´Ä¶¤ÏCentOS5.2 + MySQL 5.0.77¤Ë¤Ê¤ê¤Þ¤¹¡£
¥Ð¡¼¥¸¥ç¥ó¤äLinux¤¬°Û¤Ê¡¦E¡¦Ç¼ã´³Æ°ºûÀ˰㤤¤¡¦Ð¤¡¦EÄǽÀ¤¡¦br />
¤¢¤ê¤Þ¤¹¤Î¤Çͽ¤á¤´Î»¾µ¤¯¤À¤µ¤¤¡£
¤â¤·¤è¤«¤Ã¤¿¤é¤³¤Îµ¡²ñ¤Ë¡¦E¡¦E¡¦inux¤ò³Ø¤Ó¤Þ¤»¤ó¤«¡©
¤ª¿½¤·¹þ¤ß¤Ïº£¤¹¤°¢¤ò¥¯¡¦EÃ¥¡¦·¤Æ¤¡¦À¤µ¤¤¡¡¦/p>
¢£ Linux Web¥µ¡¼¥Ð¡¼¹½Ã۹ֺ¡ھåµéÊÔ¡Û
¡¡¡¡ ¢ª¡¡http://www.linuxexpert.biz/
¢£ Linux Web¥µ¡¼¥Ð¡¼¹½Ã۹ֺ¡ÚÄÌ¡¦EÔ¡¡¦br />
¡¡¡¡ ¢ª¡¡http://linuxweb.biz/top.html
¢¨MySQL¤Ï¡Ú¾åµéÊԡۤǤ·¤«°·¤Ã¤Æ¤Þ¤»¤ó¡£¡ÚÄÌ¡¦EԡۤǤϥ¡¦¡¦E¥å¥é¥à¤¡¦br />
¡¡´Þ¤Þ¡¦EƤ¡¦ê¤Þ¤»¤ó¤Î¤Ç¡¢¤´ÃúÌÕ¤¡¦À¤µ¤¤¡¡¦/p>
¢£CentOS6.3¥µ¡¼¥Ð¡¼¹½Ãۥޥ˥奢¡¦Eò̵ÎÁ¥×¥¡¦E¼¥ó¥¡¦/strong>
¡¡¡¡CenOS6.3¤Î¥µ¡¼¥Ð¡¼¹½ÃÛ¡¦Eç¡¡¦Mware Player4¤Î
¡¡¡¡¥À¥¦¥ó¡¦½¼¥É¤È¥¤¥ó¥¹¥È¡¼¡¦E¡¦Eç¤ò¤Þ¤È¤á¤¿¥Þ¥Ë¥å¥¢¥¡¦E¡¦Ebr>
¡¡¡¡ÌµÎÁ¤Ç¥×¡¦E¼¥ó¥È¤·¤Æ¤¤¤Þ¤¹¡¡¦/b>
¡¡¡¡¾Ü¤·¤¯¤Ï¢¤Î¥Ú¡¼¥¸¤ÇÀâÌÀ¤·¤Æ¤¤¤Þ¤¹¡£º£¤¹¤°¥¯¡¦EÃ¥¡¦·¤Æ¥À¥¦¥ó¥ú½¼¥É¤·¤Æ¤¡¦À¤µ¤¤¡¡¦br>
¡¡¡¡CentOS6.3¥µ¡¼¥Ð¡¼¹½Ãۥޥ˥奢¡¦Eò´¡¦EÖ¸ÂÄ¡¦E×¥¡¦E¼¥ó¥¡¦/a>
¥¹¥Ý¥ó¥µ¡¼¥É¡¦E󥡦/p>
[ ¥µ¡¼¥Ð¡¼´ÉÍý ]
LinuxºÇ¶¯Tips½¸¡§Åö¥µ¥¤¥È¤Ë¤Ä¤¤¤Æ
- LinuxºÇ¶¯Tips½¸¤Ï¸Ä¿Í¤Ç±¿±Ä¤·¤Æ¤¤¡¦Eµ¥¤¥È¤Ç¤¹¡¡¦/li>
- ¤´°Õ¸«¡¢¤´¼ÁÌä¤Ï¥á¡¼¡¦EǤ¡¦ê¤¤¤¤¤¿¤·¤Þ¤¹¡¡¦/li>
¥¹¥Ý¥ó¥µ¡¼¥É¡¦E󥡦/p>
MySQL¤Ï¥ª¡¼¥×¥ó¥½¡¼¥¹¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¤Ë¤Ê¤ê¤Þ¤¹¡£
̵ÎÁ¤ÇÍøÍѤǤ¡¦EÇ¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¤È¤·¤¡¦ostgreSQL¤¬¤¢¤ê¤Þ¤¹¤¬¡¢
¤½¡¦Eȿ͵¤¤òÆóÊ¡¦¹¤¡¦EÇ¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¤Ç¤¹¡¡¦/p>
¿Íµ¤¤ÎÍýͳ¤Ï¹âÀǽ³ûÀĹ⮤ǡ¢¤·¤«¤âÁàºûÀ¬Èæ³ÓŪ´Êñ¤Ê¾å¡¢
Movable Type¤äXoops¤Ê¤É¿¤¯¤Î¥¦¥§¥Ö¥µ¥¤¥È¹½ÃÛ¥½¥Õ¥È¥¦¥§¥¢¤¬
¥µ¥Ý¡¼¥È¤·¤Æ¤¤¡¦E¿¤á¤Ç¤¹¡¡¦Þ¤¡¦ySQL¤òÍøÍѤ¹¡¦E¡¦¡¦AMP´Ä¶¤¬
¹½ÃÛ½ÐÍè¤Þ¤¹¡£
¢¨LAMP¤È¤ÏLinux¡¢Apache¡¢ MySQL¡¢ PHP¤Îά¾Î
º£²ó¤Ï¤½¤ÎMySQL¡¦EѤ¡¦oot¥Ñ¥¹¡¦E¼¥É¤ò˺¤¡¦EƤ·¤Þ¤Ã¤¿¾¡¦E礡¦br />
ÂнèÊýË¡¤ò¤´¾Ò²ð¤·¤Þ¤¹¡£
MySQL¤Îroot¥Ñ¥¹¡¦E¼¥É¤òºÆÀßÄꤹ¤¡¦E/strong>
£±.Mysql¤ÎÄä»ß¤Èµ¯Æ°¤ò¤¹¡¦E/strong>
[root@Tiger ~]# /etc/rc.d/init.d/mysql stop
Shutting down MySQL. [ OK ]
[root@Tiger ~]# /etc/rc.d/init.d/mysql start --skip-grant-tables
Starting MySQL.
¡Ö/etc/rc.d/init.d/mysql stop¡×¤ÇMySQL¤òÄä»ß¤·¡¢
¡Ö/etc/rc.d/init.d/mysql start --skip-grant-tables¡×¤Ç
MySQL¤ò¥»¡¼¥Õ¥â¡¼¥É¤Çµ¯Æ°¤·¤Þ¤¹¡£
¡Ö--skip-grant-tables¡×¥ª¥×¥·¥ç¥ó¤òÉÕÍ¿¤·¤ÆMySQL¤òÆ°¤¹¡¦EÇ¡¡¦br /> ¥æ¡¼¥¶¡¼¸¢¸Â¤Î¥Á¥§¥Ã¥¯¤ò¥¹¥¥Ã¥×¤·¤¿¾õÂÖ¤ÇMySQL¥µ¡¼¥Ð¤¬µ¯Æ°¤·¤Þ¤¹¡£
£².MySQL¤ËÀܳ¤¹¡¦E/strong>
[root@Tiger ~]# /usr/local/mysql/bin/mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
MySQL¥æ¡¼¥¶¡¼¤Îroot¤ÇÀܳ¤·¤Þ¤¹¡£¡Ö--skip-grant-tables¡×¥ª¥×¥·¥ç¥ó¤Ç
µ¯Æ°¤·¤Æ¤¤¡¦E¿¤á¡¢¥Ñ¥¹¥¡¦E¼¥É¤¡¦á¤á¤é¤¡¦EÞ¤»¤ó¡¡¦/p>
£³.MySQL¤Îroot¥Ñ¥¹¡¦E¼¥É¤òÀßÄꤹ¤¡¦E/strong>
mysql> UPDATE user SET Password=PASSWORD('xxxxxxx') WHERE User='root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
¡ÖUPDATE user SET Password=PASSWORD('xxxxxxx') WHERE User='root';¡×¤Ç
root¤Î¥Ñ¥¹¡¦E¼¥É¤òºÆÀßÄꤷ¤Þ¤¹¡¡¦¡¦xxxxxx¡×¤Î²Õ½ê¤Ë¤Ï¿·¥Ñ¥¹¡¦E¼¥É¤¡¦Ebr />
ÀßÄꤷ¤Æ¤¯¤À¤µ¤¤¡£
¡ÖFLUSH PRIVILEGES;¡×¤ÇÀßÄê¤òÈ¿±Ç¤µ¤»¡¢¡Öexit¡×¤ÇMySQL¤ÎÀܳ¡¦Ebr /> ÀÚ¤ê¤Þ¤¹¡£
£´.MySQL¤òÄÌ¡¦E⡼¥É¤ÇºÆµ¡¦°¤·¤Þ¤¹¡¡¦/strong>
[root@Tiger ~]# /etc/rc.d/init.d/mysql restart
Shutting down MySQL.. [ OK ]
Starting MySQL. [ OK ]
MySQL¤òÄÌ¡¦E⡼¥É¤ÇºÆµ¡¦°¤·¤Þ¤¹¡¡¦/p>
£µ.¿·¥Ñ¥¹¡¦E¼¥É¤Ç¥úÁ°¥¤¥ó¤Ç¤¤¡¦E¡¦Îǧ¤ò¹Ô¤¡¦/strong>
[root@Tiger ~]# /usr/local/mysql/bin/mysql -u root -p
Enter password:¡¡¡¡¡¡¢«£³¤ÇÀßÄꤷ¤¿¥Ñ¥¹¡¦E¼¥É¤òÆ¡¦Ï¤·¤Þ¤¹¡¡¦/em>
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
¡ÖEnter password¡§¡×¤Ë£³¤Î¡Öxxxxxxx¡×¤ÇÀßÄꤷ¤¿¥Ñ¥¹¡¦E¼¥É¤òÆ¡¦Ï¤¡¦br /> ¡¦Á°¥¤¥ó¤Ç¤¡¦EÐÀ¡¦ù¤Ç¤¹¡¡¦/p>
¢¨ Linux Web¥µ¡¼¥Ð¡¼¹½Ã۹ֺ¡ھåµéÊÔ¡Û¤ò¼õ¹Ö¤·¤Æ¤¤¡¦E¡¦¡¦br />
¡¡ crontab¤ÇÀßÄꤷ¤Æ¤¤¡¦E¡¦heck_process.pl¡×¥¹¥¯¡¦EץȤòºÇ½é¤¡¦br />
¡¡Ìµ¸ú¤Ë¤¹¡¦E³¤È¤ò¤¡¦º¤¡¦Eʤ¡¦¡¦br />
¡¡¾Ü¤·¤¯¤Ï¼õ¹ÖÀ¸¡¦EÑ¥µ¥Ý¡¼¥È¥Õ¥¡¦¼¥é¥à¤ËÌÀµ¤·¤Æ¤¤¤Þ¤¹¤Î¤¡¦br />
¡¡¤´³Îǧ¤¯¤À¤µ¤¤¡£
º£²ó¤´¾Ò²ð¤·¤¿´Ä¶¤ÏCentOS5.2 + MySQL 5.0.77¤Ë¤Ê¤ê¤Þ¤¹¡£
¥Ð¡¼¥¸¥ç¥ó¤äLinux¤¬°Û¤Ê¡¦E¡¦Ç¼ã´³Æ°ºûÀ˰㤤¤¡¦Ð¤¡¦EÄǽÀ¤¡¦br />
¤¢¤ê¤Þ¤¹¤Î¤Çͽ¤á¤´Î»¾µ¤¯¤À¤µ¤¤¡£
¤â¤·¤è¤«¤Ã¤¿¤é¤³¤Îµ¡²ñ¤Ë¡¦E¡¦E¡¦inux¤ò³Ø¤Ó¤Þ¤»¤ó¤«¡©
¤ª¿½¤·¹þ¤ß¤Ïº£¤¹¤°¢¤ò¥¯¡¦EÃ¥¡¦·¤Æ¤¡¦À¤µ¤¤¡¡¦/p>
¢£ Linux Web¥µ¡¼¥Ð¡¼¹½Ã۹ֺ¡ھåµéÊÔ¡Û
¡¡¡¡ ¢ª¡¡http://www.linuxexpert.biz/
¢£ Linux Web¥µ¡¼¥Ð¡¼¹½Ã۹ֺ¡ÚÄÌ¡¦EÔ¡¡¦br /> ¡¡¡¡ ¢ª¡¡http://linuxweb.biz/top.html
¢¨MySQL¤Ï¡Ú¾åµéÊԡۤǤ·¤«°·¤Ã¤Æ¤Þ¤»¤ó¡£¡ÚÄÌ¡¦EԡۤǤϥ¡¦¡¦E¥å¥é¥à¤¡¦br /> ¡¡´Þ¤Þ¡¦EƤ¡¦ê¤Þ¤»¤ó¤Î¤Ç¡¢¤´ÃúÌÕ¤¡¦À¤µ¤¤¡¡¦/p>
¡¡¡¡CenOS6.3¤Î¥µ¡¼¥Ð¡¼¹½ÃÛ¡¦Eç¡¡¦Mware Player4¤Î
¡¡¡¡¥À¥¦¥ó¡¦½¼¥É¤È¥¤¥ó¥¹¥È¡¼¡¦E¡¦Eç¤ò¤Þ¤È¤á¤¿¥Þ¥Ë¥å¥¢¥¡¦E¡¦Ebr> ¡¡¡¡ÌµÎÁ¤Ç¥×¡¦E¼¥ó¥È¤·¤Æ¤¤¤Þ¤¹¡¡¦/b>
¡¡¡¡¾Ü¤·¤¯¤Ï¢¤Î¥Ú¡¼¥¸¤ÇÀâÌÀ¤·¤Æ¤¤¤Þ¤¹¡£º£¤¹¤°¥¯¡¦EÃ¥¡¦·¤Æ¥À¥¦¥ó¥ú½¼¥É¤·¤Æ¤¡¦À¤µ¤¤¡¡¦br> ¡¡¡¡CentOS6.3¥µ¡¼¥Ð¡¼¹½Ãۥޥ˥奢¡¦Eò´¡¦EÖ¸ÂÄ¡¦E×¥¡¦E¼¥ó¥¡¦/a>
¥¹¥Ý¥ó¥µ¡¼¥É¡¦E󥡦/p>
LinuxºÇ¶¯Tips½¸¡§Åö¥µ¥¤¥È¤Ë¤Ä¤¤¤Æ
- LinuxºÇ¶¯Tips½¸¤Ï¸Ä¿Í¤Ç±¿±Ä¤·¤Æ¤¤¡¦Eµ¥¤¥È¤Ç¤¹¡¡¦/li>
- ¤´°Õ¸«¡¢¤´¼ÁÌä¤Ï¥á¡¼¡¦EǤ¡¦ê¤¤¤¤¤¿¤·¤Þ¤¹¡¡¦/li>