linux yum°²×°mysqlºóҪעÒâµÄһЩ³õʼ»¯ÎÊÌâ
zz linux yum°²×°mysqlºóҪעÒâµÄһЩ³õʼ»¯ÎÊÌâ
ÎҵķþÎñÆ÷×°µÄÊÇcentos 5.3,ÓÉÓÚ×ʼ°²×°×öÁËÏêϸµÄ¼Ç¼,ËùÒÔÕû¸ö¹ý³ÌÒ²ÊÇÇá³µÊì·,һ·yumÏÂÀ´£¬¾Í¸ã¶¨ÁË£¬È»ºó¾ÍÊÇÊý¾Ý¿â¡¢ÍøÕ¾µÄ°á¼Ò£¬ÇáËɸ㶨~
¿ÉÊǽñÌìÔÚ¼Ò¿´ÁËϹ«Ë¾µÄÍøÕ¾£¬ÎÊÌâ³öÀ´ÁË~ ÓÐЩ²úÆ·µã»÷²é¿´ÏêϸÐÅÏ¢µÄʱºò£¬ÕÒ²»µ½ÍøÒ³~¾¹ýÒ»·¬Ë¼¿¼£¬·¢ÏÖÊÇmysqlĬÈÏ×Ö·û¼¯µÄÎÊÌ⣬°ÑÔÀ´·þÎñÆ÷ÉϵÄmy.cnfÒ»¿´£¬»¹¹ûÕæÊÇ~~ÔÎÁË~~~
ÏÂÃæÐ´³ömysql×°ÍêºóÐèҪעÒâµÄһЩ³õʼ»¯ÉèÖÃ~
1. ÅäÖÿª»úÆô¶¯·þÎñ
/sbin/chkconfig httpd on [ÉèÖÃapache·þÎñÆ÷httpd·þÎñ¿ª»úÆô¶¯]
/sbin/chkconfig –add mysqld [ÔÚ·þÎñÇåµ¥ÖÐÌí¼Ómysql·þÎñ]
/sbin/chkconfig mysqld on [ÉèÖÃmysql·þÎñ¿ª»úÆô¶¯]
/sbin/service httpd start [Æô¶¯httpd·þÎñ,Ó뿪»úÆô¶¯ÎÞ¹Ø]
/sbin/service mysqld start [Æô¶¯mysql·þÎñ,Ó뿪»úÎÞ¹Ø]
2. ÉèÖÃmysqlÊý¾Ý¿ârootÕʺÅÃÜÂ롣ĬÈϵijõʼ»¯ÃÜÂëΪ¿Õ~~~
mysqladmin -u root password ‘new-password’ [ÒýºÅÄÚÌîÃÜÂë]
3. ÈÃmysqlÊý¾Ý¿â¸ü°²È«
mysql -u root -p
mysql> DROP DATABASE test; [ɾ³ýtestÊý¾Ý¿â]
mysql> DELETE from mysql.user WHERE user = ”; [ɾ³ýÄäÃûÕÊ»§]
mysql> FLUSH PRIVILEGES; [ÖØÔØÈ¨ÏÞ]
4.°²×°ÉÏmysqlÀ©Õ¹
yum -y install mysql-connector-odbc mysql-devel libdbi-dbd-mysql
5.ÉèÖÃĬÈϱàÂëµÈһЩ³õʼ²ÎÊý£¨my.cnf£©
vi /etc/my.cnf
[mysqld]
da
Ïà¹ØÎĵµ£º
step 1)ÏÂÔØÔ´´úÂë°üµ½±¾µØLinuxÖ÷»ú£¬È»ºó½âѹËõ£¬½øÈë¸ÃĿ¼£¬½øÐÐÅäÖ㬱àÒëºÍ°²×°
ÏÂÔØmysql5Ô´Âëmysql-5.0.18.tar.gzµ½Ä¿Â¼/usr/local
cd /usr/local
tar xzvf mysql-5.0.18.tar.gz
cd mysql-5.0.18
./configure --prefix=/usr/local/mysql
make && make install
make¹ý³Ì»¨µÄʱ¼ä±È½Ï³¤
step 2)ÅäÖÃ
......
Ò». ÉèÖò½Ö裺1¡¢ÓÒ¼üµã»÷ÎҵĵçÄÔ£¬Ñ¡ÔñÊôÐÔ£¨¼ûͼ-1£©
1¡¢µã»÷¸ß¼¶£¬ÔÚ¶Ô»°¿òµÄϲ¿µã»÷»·¾³±äÁ¿
3¡¢ÔÚϵͳ±äÁ¿¶Ô»°¿òÖУ¬µã»÷н¨½øÐÐÉèÖÃ.
±äÁ¿Ãû£ºJAVA_HOME
±äÁ¿Öµ£ºC:\Program Files\Java\jdk1.6.0_05£¨ÔÚ´ËʹÓõÄÊÇĬÈϰ²×°Â·¾¶£©
ϵͳ±äÁ¿->±à¼->±ä ......
1. Êý¾Ý¿â
Çл»Êý¾Ý¿â£º use mydb
2. ʼþ
²é¿´Ê¼þ£º show events
Æô¶¯µ÷¶ÈÆ÷: set global event_scheduer = 1;
²é¿´ÊÇ·ñÆô¶¯£º show variables like 'event_scheduler';
3. ±¸·Ý
ÔÚadministatorÖеÄbackupÖÐÎÞ·¨±¸·ÝÊý¾Ý¿âµÄʼþ¡£ÐèÒªÊÖ¶¯½«´´½¨Ê¼þµÄ½Å±¾Ìí¼Óµ½sql±¸ ......
Ò». yumÊÇʲô
yum = Yellow dog Updater, Modified
Ö÷Òª¹¦ÄÜÊǸü·½±ãµÄÌí¼Ó/ɾ³ý/¸üÐÂRPM°ü.
ËüÄÜ×Ô¶¯½â¾ö°üµÄÒÐÀµÐÔÎÊÌâ.
ËüÄܱãÓÚ¹ÜÀí´óÁ¿ÏµÍ³µÄ¸üÐÂÎÊÌâ
¶þ. yumÌØµã
*¿ÉÒÔͬʱÅäÖöà¸ö×ÊÔ´¿â(Repository)
*¼ò½àµÄÅäÖÃÎļþ(/etc/yum.conf
*×Ô¶¯½â¾öÔö¼Ó»òɾ³ýrpm°üʱÓöµ½µÄÒÐÀµÐÔÎÊÌâ
*ʹÓ÷½±ã
*± ......