LinuxÏÂMysql°²×°ºÍÅäÖÃ2
LinuxÏÂmysqlµÄ°²×°²½Ö裨·Çrpm°²×°£©
1 ÏÂÔØmysql-standard-5.0.27-linux-i686-glibc23.tar.gz °ü
2 ½âѹµ½°²×°Ä¿Â¼£º tar -zxvf /edass/db/mysql-standard-5.0.27-linux-i686-glibc23.tar.gz
3 ½« mysql-standard-5.0.27-linux-i686-glibc23Á´½Óµ½mysql : ln –s mysql-standard-5.0.27-linux-i686-glibc23 mysql
4 Ϊmysql½¨Á¢ÈººÍÓû§£¨linuxÓû§£©
shell> groupadd mysql
shell> useradd -g mysql mysql
5 ³õʼ»¯Êý¾Ý¿â£ºscripts/mysql_install_db --user=mysql (mysql_install_db
ÒÔȱʡȨÏÞ´´½¨MySQLÊÚȨ±í¡£Õâͨ³£½ö±»Ö´ÐÐÒ»´Î¡£¾ÍÊÇÔÚϵͳÉϵÚÒ»´Î°²×°MySQLʱ¡£root@localhost
)
6 Æô¶¯mysqlÊý¾Ý¿â£ºbin/mysqld_safe --user=mysql &
7 ÓÃroot½øÈëmysqlÃüÁîÐÐģʽ£º./mysql -u root -p
// 8 Ϊroot·ÖÅäÃÜÂ룺mysql>grant all privilages on *.* to
// identified by 'password' with grant option
9ÊÚÓè rootÓû§¿ÉÒÔ´ÓÈκÎÖ÷»ú·¢Æð·ÃÎÊ£ºmysql>grant all privilages on *.* to root@"%" identified by 'password' with grant option;£¨"%"ÊÇͨÅä·û£¬ÊÚÓè admin Óû§¿ÉÒÔ´ÓÈκÎÖ÷»ú·¢Æð·ÃÎÊ£¬password ÊÇΪ admin Óû§ÉèÖõÄÃÜÂë¡£Ò»°ãÀ´½²£¬Root Ó¦Ö»ÓÃÓÚÊý¾Ý¿â±¾»úÉϵǼ MySQL£¬ÎÒÃÇ¿ÉÒÔÔö¼ÓÒ»¸öÓµÓг¬¼¶¹ÜÀíȨÏÞµÄÓû§ 'admin' À´ÊµÏÖÔ¶³ÌµÄά»¤¡£
£©
MysqlÆô¶¯ÃüÁ./bin/mysqld_safe –-user=mysql &
Mysql¹Ø±ÕÃüÁ./bin/mysqladmin –uroot –phkgt123 shutdown
MysqlÊý¾Ý½Å±¾µ¼³ö(Õû¸öÊý¾Ý¿â)£º./bin/mysqldump –-opt–uroot –phkgt123 test > /edass/db/dgflog.sql
MysqlÊý¾Ý½Å±¾µ¼Èë(Õû¸öÊý¾Ý¿â)£º./bin/mysql –uroot –phkgt123 dgflog < /edass/db/dgflog.sql
MysqlµÄ¶Ë¿ÚÐÞ¸Ä £ºvi etc/my.cnf port=3300 #Ð޸ijÉÄã×Ô¼ºÏëÒªµÄ¶Ë¿Ú
ÉèÖÃ×Ô¶¯Æô¶¯/etc/rc.d/rc.local Ìí¼Ó cd /edass/auditdb/mysql; bin/mysqld_safe --socket=/tmp/auditdb.sock --port=4406
--user=mysql &
ÐÞ¸ÄmysqlÃÜÂ룺
mysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
»ò½øÈëmysqlÃüÁîÐÐSET PASSWORD FOR root=PASSWORD("root");
10 mysqlÃüÁîÐг£ÓÃÃüÁ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£
Ïà¹ØÎĵµ£º
£¨L2CAPÐÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPÐÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼Á¬½Ó¿ØÖƺÍÊÊÅäÐÒé (L2CAP) ΪÉϲãÐÒéÌṩÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àÐÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãÐÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ L2CAP Ê ......
CentOSÏÂMysqlʵÏÖÊý¾Ý¿âÖ÷´Óͬ²½
Ò»¡¢»·¾³
¡¡¡¡A·þÎñÆ÷£º 192.168.10.42 Ö÷·þÎñÆ÷master¡¡¡¡CentOS 5¡¡¡¡Mysql 5.1.34
¡¡¡¡B·þÎñÆ÷£º 192.168.10.68 ¸±·þÎñÆ÷slave¡¡¡¡¡¡CentOS 5¡¡¡¡Mysql 5.0.56
¶þ¡¢ÉèÖÃMaster·þÎñÆ÷
¡¡¡¡1¡¢±à¼MasterÉϵÄ/etc/my.cnfÎļþ
¡¡¡¡¡¡ ......
ÓÅ»¯MySQL·þÎñÆ÷µÄÅäÖòÎÊý£¬¿ÉÒÔÌá¸ßMySQLÊý¾Ý¿âµÄÐÔÄÜ£¬µ«ÊǶÔÓÚÅäÖýϵ͵ķþÎñÆ÷À´Ëµ£¬ÄãÎÞÂÛÔõôÓÅ»¯ÅäÖ㬶¼²»»áµÃµ½ÀíÏëµÄЧ¹û£¬ÄǾÍÖ»ÄÜÌá¸ßÄãÓ²¼þÅäÖã¬À´³¹µ×ÓÐЧµØ¸ÄÉÆ·þÎñÆ÷µÄÐÔÄÜ¡£
¾ßÌåµÄ·½·¨ÈçÏ£º
Ò»¡¢ÔÚÉèÖÃMySQL ʱ£¬Ó¦¸ÃÅäÖÃÆäʹÓþ²Ì¬¿â¶ø²»Êǹ²Ïí¿â¡£Ê¹Óù²Ïí¿âµÄ¶¯Ì¬¶þ½øÖÆϵͳ¿É½ÚÊ¡´ÅÅ̿ռ䣬µ«¾² ......
±ä³ÉѧϰQTÁË...º¹.
ÖÆ×÷Hello World µ½ ʱÖÓ³ÌÐò ... ×î¶àµÄ»¹ÊÇÊìϤ×é¼þµÄʹÓã¬Ê¹ÓöøÒÑ£¬¹¤¾ß¶øÒÑ£¬´ó²¿·Ö¶¼ÊÇÀ×ͬµÄ£¬ÆäʵÎÒÃÇҪѧµÄ²»¶à£¬Ò²¾ÍÊǺÍVC++ »òÕßBC++²»Í¬µÄ»úÖÆ»òÕßеļ¼ÇÉ¡£×é¼þÓõ½Ê±ºò²é²é¾ÍOK£¬Ã»±ØҪϵͳµÄѧ£¬ÒòΪÎÒÃÇÓò»Ì«µ½¡£
  ......