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
Ïà¹ØÎĵµ£º
×î½üÓöµ½Ò»¸öÐèÇóÒªÔÚlinuxÏÂÓÃjava µ÷ÓÃmysql¿Í»§¶ËÔ¶³ÌµÇ½mysql·þÎñÆ÷£¬´Ó¿Í»§¶Ë»úÆ÷µ¼Èëmysql½Å±¾£¬´Ómysql·þÎñÆ÷¶Ëµ¼³ö±íÖеÄÊý¾Ý¡£ÒÔÏÂÊÇÓõ½µÄÖ÷Òª·½·¨£º
Java ´úÂë
/**
* µ¼ÈëÊý¾Ý
* @param ½Å±¾µÄµØÖ·ºÍÃû³Æ
* @return ÊÇ·ñ³ ......
ʹÓÃMYSQL½øÐÐÊý¾Ý¿â±¸·Ý£¬ÓÖºÜÕý¹æµÄÊý¾Ý¿â±¸·Ý·½·¨£¬Í¬ÆäËûµÄÊý¾Ý¿â·þÎñÆ÷ÓÐÏàͬµÄ¸ÅÄµ«ÓÐûÓÐÏë¹ý£¬MySQL»áÓиü¼ò½ÝµÄʹÓÃÎļþĿ¼µÄ±¸·Ý·½·¨£¬¶øÇÒÓÖ¿ìÓкá£
¡¡¡¡Ò»¡¢Êý¾Ý±¸·Ý½Ý¾¶
¡¡¡¡ÒòΪÕâ¸ö·½·¨Ã»Óеõ½¹Ù·½ÕýʽÎĵµµÄÑéÖ¤£¬ÎÒÃÇÔݳÆΪÊÔÑé°É¡£
¡¡¡¡Ä¿µÄ£º±¸·ÝhostAÖ÷»úÖÐÒ»¸ömysqlÊý¾Ý¿âTestA£¬²¢»Ö¸´µ½µ½h ......
ÒýÓÃhttp://bbs.yahunet.com/thread-9946-1-1.html
´Ó»ù±¾Çé¿ö¡¢³É±¾¡¢ÓÅȱµãºÍÓ¦Óó¡ºÏµÈ·½Ãæ¶Ô5ÖÖMySQLµÄ¿É¿¿ÐÔ·½°¸
½øÐÐÁË·ÖÎö
ºÍ±È½Ï£¬¶ÔMySQLµÄ¿ª·¢ºÍ¹ÜÀí
ÓÐÒ»¶¨µÄ½è¼ø×÷Óá£
1£®MySQL Clustering(ndb-cluster stogare)
¼ò½é£º
MySQL¹«Ë¾ÒÔ´æ´¢ÒýÇ淽ʽÌṩµÄ¸ß¿É¿¿ÐÔ·½°¸£¬ÊÇÊÂÎñ°²È«µÄ£¬ÊµÊ±¸´ÖÆÊý¾Ý
£¬¿ÉÓ ......
¶ÔÓÚÿ¸öÀàÐÍÓµÓеÄÖµ·¶Î§ÒÔ¼°²¢ÇÒÖ¸¶¨ÈÕÆÚºÎʱ¼äÖµµÄÓÐЧ¸ñʽµÄÃèÊö¼û7.3.6 ÈÕÆÚºÍʱ¼äÀàÐÍ¡£
ÕâÀïÊÇÒ»¸öʹÓÃÈÕÆÚº¯ÊýµÄÀý×Ó¡£ÏÂÃæµÄ²éѯѡÔñÁËËùÓмǼ£¬Æädate_colµÄÖµÊÇÔÚ×îºó30ÌìÒÔÄÚ£º
mysql> SELECT something from table
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30;
DAYOFWEEK(date)
·µ»ØÈÕÆ ......
Æô¶¯£º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 ......