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
Ïà¹ØÎĵµ£º
Ò» »ù±¾µÄÎļþ²Ù×÷¼°ÏµÍ³²Ù×÷
н¨Ä¿Â¼ mkdir –Ŀ¼Ãû
½«¹¤×÷Ŀ¼¸Ä±äµ½Dir   ......
¼¤¶¯°¡£¬½ñÌìÏÂÎç·ÅѧÀíÍê·¢»ØÀ´ÎÒ°Ö¸æËßÎÒ˵¼ÄÀ´Ñù¶«Î÷£¬»¹ÊÇ´Ó¹úÍâ¼ÄÀ´µÄ£¡ÕâÊÇÎÒµÚÒ»´Î´Ó¹úÍâ±ðÈ˸øÎҼĶ«Î÷¡£·Ï»°²»¶à˵£¬ÉÏͼ²ÅÊÇÍõµÀ¡£ÓÉÓÚÅÄÉãÌõ¼þ¹ýÓÚ¼òª£¨ÁªÏëI398ÊÖ»ú+ÊÖµçͲ£©£¬Óе㱾ßÁË¡£
°ü¹üÕýÃæµÄÍâ°ü×°
°ü¹ü±³Ã棨Ϊ·ÀÖ¹¸öÈËÐÅϢй¶ÄÃÅçÆáºÍгÁËһϣ©
°ü¹ü×îÉÏÃæ£¬ÓÉÓÚÓ¢ÓïˮƽÓÐÏÞÿ̫¿´¶®ÊÇÊ²Ã´Ò ......
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)ÅäÖÃ
......