Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

LinuxÏÂMySQL¿ª·ÅrootµÄÔ¶³Ì·ÃÎÊȨÏÞ

»·¾³£ºRHEL 5.3
°²×°ÁËMySQLÖ®ºó£¬MySQLµÄrootÓû§Ä¬ÈÏÊDz»¿ª·ÅÔ¶³Ì·ÃÎÊȨÏ޵ġ£ÎªÁË¿ª·ÅËü£¬Ö»ÐèÒªÁ½²½£º
ÓÃLinuxϵͳµÄrootÓû§µÇ¼ϵͳ£¬È»ºó£º
£¨1£©¿ª·Å3306¶Ë¿ÚµÄÔ¶³ÌÁ¬½ÓȨÏÞ£º
ÔÚ“-A RH-Firewall-1-INPUT -j REJECT --reject-with icmp-host-prohibited”ÕâÒ»ÐеÄÉÏÃæ£¨×¢Ò⣬һ¶¨ÊÇÉÏÃæ£©£¬Ìí¼ÓÈçÏÂÒ»ÐУº
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
È»ºóÖØÆôiptables£º
[root@localhost ~]# service iptables restart
£¨2£©ÎªMySQLµÄrootÓû§Ìí¼ÓÔ¶³Ì·ÃÎÊȨÏÞ£º
[root@localhost ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.41-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> grant all on *.* to root@'%' identified by 'your_password';               
Query OK, 0 rows affected (0.01 sec)
mysql> exit
Bye
[root@localhost ~]# /etc/init.d/mysql restart
¸ã¶¨¡£


Ïà¹ØÎĵµ£º

LinuxÉ豸ģÐÍÖ®input×ÓϵͳÏê½â

Ò»£ºÇ°ÑÔ
×î½üÔÚÑо¿androidµÄsensor driver£¬Ö÷ÒªÊÇE-compass£¬ÆäÖÐÓõ½ÁËLinux input×Óϵͳ.ÔÚÍøÉÏÒ²¿´Á˺ܶàÕâ·½ÃæµÄ×ÊÁÏ£¬¸Ð¾õ»¹ÊÇÕâÆª·ÖÎöµÄ±È½ÏϸÖÂ͸³¹£¬Òò´Ë×ªÔØÒ»ÏÂÒÔ±ã×Ô¼ºÑ§Ï°£¬Í¬Ê±ºÍ´ó¼Ò·ÖÏí£¡
£¨ÕâÆª²©¿ÍÖ÷ÒªÊÇÒÔ¼üÅÌÇý¶¯ÎªÀýµÄ£¬²»¹ý½²½âµÄÊÇLinux Input Subsystem£¬¿ÉÒÔ×ÐϸµÄÑо¿Ò»Ï£¡£©
¼üÅÌÇý¶¯½«¼ì ......

MySQLѧϰ±Ê¼Ç£ºInnoDBºÍMyISAMµÄ²î±ð


InnoDB
ºÍMyISAM
ÊÇÔÚʹÓÃMySQL
×î³£ÓõÄÁ½¸ö±íÀàÐÍ£¬¸÷ÓÐÓÅȱµã£¬ÊÓ¾ßÌåÓ¦Óöø¶¨¡£»ù±¾µÄ²î±ðΪ£ºMyISAM
ÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDB
ÀàÐÍÖ§³Ö¡£MyISAM
ÀàÐ͵ıíÇ¿µ÷µÄÊÇÐÔÄÜ£¬ÆäÖ´ÐÐÊý¶È±ÈInnoDB
ÀàÐ͸ü¿ì£¬µ«ÊDz»ÌṩÊÂÎñÖ§³Ö£¬¶øInnoDB
ÌṩÊÂÎñÖ§³ÖÒѾ­Íⲿ¼üµÈ¸ß¼¶Êý¾Ý¿â¹¦ÄÜ¡£
MyIASMÊÇIASM± ......

MySQLµ¼³öµ¼ÈëÃüÁî

      ĬÈϵ¼³öµ½µ±Ç°Ä¿Â¼ÖÐ     
¡¡¡¡1.µ¼³öÕû¸öÊý¾Ý¿â
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
¡¡¡¡2.µ¼³öÒ»¸ö±í
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
¡¡¡¡mysqldum ......

linux ϵͳ°²×°ºÍÈí¼þÍÆ¼ö

1¡¢°²×°»ù±¾ÏµÍ³
ÕâÀﰲװʹÓõÄÊÇUbuntu 7.04 µÄ Alternate CD¡£Ê¹Óà Alternate CD Òýµ¼Æô¶¯£¬È»ºóÑ¡Ôñ “°²×°ÃüÁîÐÐϵͳ£¨Install Command Line£©” ½øÐÐ×îС»¯°²×°£¬ÔÚÕâÒ»²½£¬Òª×¢Ò⣬һ¶¨²»ÒªÑ¡ÔñÖÐÎÄÓïÑÔ»·¾³£¬·ñÔòÔÚÖÕ¶Ë´°¿Úϵĸ÷ÖÖÌáʾ£¬Óкܶ඼ÊÇÖÐÎĵġ£ÔÚûÓÐ×°ÔØÍê³ÉX Window֮ǰ£¬ÄãÖ»ÄÜ¿´µ½Ò»¶Ñ ......

ÔÚ linux ÏÂʹÓà CMake ¹¹½¨Ó¦ÓóÌÐò


CMake ÊÇÒ»¸ö¿çƽ̨µÄ×Ô¶¯»¯½¨¹¹ÏµÍ³,ËüʹÓÃÒ»¸öÃûΪ CMakeLists.txt µÄÎļþÀ´ÃèÊö¹¹½¨¹ý³Ì,¿ÉÒÔ²úÉú±ê×¼µÄ¹¹½¨Îļþ,Èç Unix µÄ Makefile »òWindows Visual C++ µÄ projects/workspaces ¡£Îļþ CMakeLists.txt ÐèÒªÊÖ¹¤±àд,Ò²¿ÉÒÔͨ¹ý±àд½Å±¾½øÐаë×Ô¶¯µÄÉú³É¡£CMake ÌṩÁË±È autoconfig ¸ü¼ò½àµÄÓï·¨¡£ÔÚ linux Æ½Ì¨Ï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ