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

MySQL FOR LINUX


MySQL FOR LINUX
Ïȼì²éϵͳÊÇ·ñ×°ÉÏÁËmysql£¬Èç¹ûÓн«ÆäжÔصô
rpm -qa | grep mysql
×¢ÒâmysqlµÄ´óСд£¬´óСд¶¼ÓпÉÄÜ
rpm -e --nodeps mysql*
Ò»¶¨ÒªÓÃ--nodepsжÔØ£¬²»¼ì²éÒÀÀµÐÔ¹Øϵ¡£
´´½¨Óû§mysql
groupadd mysql
useradd -g mysql mysql
passwd mysql
ÔÚ/usr/localϽ¨Á¢ mysql Îļþ¼Ð
È»ºó½«°²×°ÎļþÉÏ´«µ½·þÎñÆ÷ÉÏ£¬ÕâÀïÓõÄÊÇtar.gzµÄÎļþ£¬Ò²ÓÐrpm°ü¿ÉÒÔÓ㬵«ÊÇrpm°ü²»ÄÜÖ¸¶¨°²×°Ä¿Â¼£¬¹Ê²»²ÉÓÃ
tar zxvf mysql-5.0.45.tar.gz 
cd mysql-5.0.45
./configure --prefix=/usr/local/mysql --with-charset=gb2312
Ö¸¶¨°²×°Ä¿Â¼Îª/usr/local/mysql£¬×Ö·û¼¯Îªgb2312
make 
make install
°²×°Íê³É
ÖØÆô
cp /usr/local/mysql/share/mysql/mysql.server
/etc/init.d/mysqld
copyÆô¶¯µÄmysqldÎļþ
ÏÂÃæÈ·±£mysqlÓû§ÓÐÏàÓ¦µÄȨÏÞ
chmod 700 /etc/init.d/mysqld
cd /usr/local
chmod 750 mysql -R
chgrp mysql mysql -R 
chown mysql mysql/var -R
cd /usr/local/mysql/libexec
cp mysqld mysqld.old
strip mysqld 
chkconfig --add mysqld 
chkconfig --level 345 mysqld on
service mysqld start 
Æô¶¯·þÎñ
/usr/local/mysql/bin/mysqld_safe
¿´¿´mysqlÄÜ·ñÕý³£¹¤×÷
mysql -uroot mysql
»òÕß netstat -atln 
¿´¿´ÓÐûÓÐ3306µÄ¶Ë¿Ú´ò¿ª,£¨Èç¹ûmysqld²»ÄÜÆô¶¯,¿´¿´/web/mysql/varϵijö´íÈÕÖ¾,Ò»°ã¶¼ÊÇĿ¼ȨÏÞûÓÐÉèÖúõÄÎÊÌâ £©
¹þ¹þ£¬Ã»ÓÐÎÊÌâ¡£Æô¶¯Õý³£¡£
/usr/local/mysql/bin/mysql_install_db --user=mysql
´´½¨Êý¾Ý¿âmysql£¬Óû§Îªmysql
½ÓÏÂÀ´×ö¸öÁ´½Ó£¬¾õµÃ·½±ãһЩ¡££¨×öÁ´½ÓÇ°È·±£Óû§PATH·¾¶ÀïÓÐsbin£©
ln -s /usr/local/mysql/bin/mysql /sbin/mysql
ln -s /usr/local/mysql/bin/mysqladmin /sbin/mysqladmin
ºÃÁË£¬Ã»ÓÐʲôÎÊÌâ¾ÍÖØÐÂÆô¶¯Ò»Ï¡£
½ÓÏÂÀ´×öһЩ¸üºÃµÄÉèÖðɡ£ÈÃmysql¸üºÃµÄÔËÐаɡ£
cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf
copyÅäÖÃÎļþ,ÓÐlarge,medium,smallÈý¸ö»·¾³ÏµÄ,¸ù¾Ý»úÆ÷ÐÔÄÜÑ¡Ôñ,Èç¹û¸ººÉ±È½Ï´ó,¿ÉÐÞ¸ÄÀïÃæµÄһЩ±äÁ¿µÄÄÚ´æʹÓÃÖµ
ÉèÖÃ×Ô¶¯Æô¶¯mysql
É趨¿ª»ú×ÔÆô¶¯mysql
#cd /usr/local/mysql/share/mysql
#cp mysql.server /etc/init.d/mysql
#cd /etc/rc3.d
#ln -s ../init.d/mysql S100mysql
#ln -s ../init.d/mysql K100mysql
#cd /etc/rc5.d
#ln -s ../init.d/mysql S10


Ïà¹ØÎĵµ£º

java µ÷ÓÃmysql¿Í»§¶Ëµ¼È룬µ¼³öÊý¾Ý

 ×î½üÓöµ½Ò»¸öÐèÇóÒªÔÚlinuxÏÂÓÃjava µ÷ÓÃmysql¿Í»§¶ËÔ¶³ÌµÇ½mysql·þÎñÆ÷£¬´Ó¿Í»§¶Ë»úÆ÷µ¼Èëmysql½Å±¾£¬´Ómysql·þÎñÆ÷¶Ëµ¼³ö±íÖеÄÊý¾Ý¡£ÒÔÏÂÊÇÓõ½µÄÖ÷Òª·½·¨£º
Java ´úÂë 
/**  
 * µ¼ÈëÊý¾Ý  
  * @param  ½Å±¾µÄµØÖ·ºÍÃû³Æ  
 * @return ÊÇ·ñ³ ......

×î¿ìµÄMySqlÊý¾Ý¿â±¸·Ý·½·¨

ʹÓÃMYSQL½øÐÐÊý¾Ý¿â±¸·Ý£¬ÓÖºÜÕý¹æµÄÊý¾Ý¿â±¸·Ý·½·¨£¬Í¬ÆäËûµÄÊý¾Ý¿â·þÎñÆ÷ÓÐÏàͬµÄ¸ÅÄµ«ÓÐûÓÐÏë¹ý£¬MySQL»áÓиü¼ò½ÝµÄʹÓÃÎļþĿ¼µÄ±¸·Ý·½·¨£¬¶øÇÒÓÖ¿ìÓкá£
¡¡¡¡Ò»¡¢Êý¾Ý±¸·Ý½Ý¾¶
¡¡¡¡ÒòΪÕâ¸ö·½·¨Ã»Óеõ½¹Ù·½ÕýʽÎĵµµÄÑéÖ¤£¬ÎÒÃÇÔݳÆΪÊÔÑé°É¡£
¡¡¡¡Ä¿µÄ£º±¸·ÝhostAÖ÷»úÖÐÒ»¸ömysqlÊý¾Ý¿âTestA£¬²¢»Ö¸´µ½µ½h ......

MySQL¿É¿¿ÐÔ·½°¸·ÖÎöÓë±È½Ï

ÒýÓÃhttp://bbs.yahunet.com/thread-9946-1-1.html
´Ó»ù±¾Çé¿ö¡¢³É±¾¡¢ÓÅȱµãºÍÓ¦Óó¡ºÏµÈ·½Ãæ¶Ô5ÖÖMySQLµÄ¿É¿¿ÐÔ·½°¸
½øÐÐÁË·ÖÎö
ºÍ±È½Ï£¬¶ÔMySQLµÄ¿ª·¢ºÍ¹ÜÀí
ÓÐÒ»¶¨µÄ½è¼ø×÷Óá£
1£®MySQL Clustering(ndb-cluster stogare)
¼ò½é£º
MySQL¹«Ë¾ÒÔ´æ´¢ÒýÇ淽ʽÌṩµÄ¸ß¿É¿¿ÐÔ·½°¸£¬ÊÇÊÂÎñ°²È«µÄ£¬ÊµÊ±¸´ÖÆÊý¾Ý
£¬¿ÉÓ ......

mysqlÈÕÆÚºÍʱ¼ä¸ñʽת»»

¶ÔÓÚÿ¸öÀàÐÍÓµÓеÄÖµ·¶Î§ÒÔ¼°²¢ÇÒÖ¸¶¨ÈÕÆÚºÎʱ¼äÖµµÄÓÐЧ¸ñʽµÄÃèÊö¼û7.3.6 ÈÕÆÚºÍʱ¼äÀàÐÍ¡£
ÕâÀïÊÇÒ»¸öʹÓÃÈÕÆÚº¯ÊýµÄÀý×Ó¡£ÏÂÃæµÄ²éѯѡÔñÁËËùÓмǼ£¬Æädate_colµÄÖµÊÇÔÚ×îºó30ÌìÒÔÄÚ£º
mysql> SELECT something from table
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30;
DAYOFWEEK(date)
·µ»ØÈÕÆ ......

mysql»ù±¾ÃüÁî

 Æô¶¯£ºnet start mySql;
  ½øÈ룺mysql -u root -p/mysql -h localhost -u root -p databaseName;
  ÁгöÊý¾Ý¿â£ºshow databases;
  Ñ¡ÔñÊý¾Ý¿â£ºuse databaseName;
  Áгö±í¸ñ£ºshow tables£»
  ÏÔʾ±í¸ñÁеÄÊôÐÔ£ºshow columns from tableName£»
  ½¨Á¢Êý¾Ý¿â£ºsource fileNam ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ