MySQL°²×°ÓëÓ¦Óá¾LinuxϵݲװÓëÅäÖá¿
LinuxϵݲװÓëÅäÖÃ
Èç¹ûËù°²×°µÄLinuxϵͳûÓÐÄÚÖõÄMySQL£¬±ÊÕß½¨ÒéÔÚLinuxÖÐʹÓÃRPM°üÀ´°²×°MySQL£¬Í¬ÑùÕâÒ²ÊÇMySQL¹Ù·½ÌṩµÄ½¨Òé¡£±ÊÕß½Ó´¥×î¶àµÄLinuxϵͳÊÇRadhatµÄ“½üÇ×”£ºCentOS£¬ÓÉÓÚCentOS½Ïеİ汾¶¼ÄÚÖÃÁËMySQL£¬Òò´ËÔÚ°²×°ÏµÍ³Ê±¾Í½«MySQL°²×°²¢×¢²áΪϵͳ·þÎñ£¬Ê¡È¥Á˲»ÉÙ¹¤×÷Á¿£¬´Ë´¦Ò²¾Í²»¶ÔLinuxϵݲװ×öÌ«¶à³ÂÊö£¬½öÌṩ²¿·Ö×ÊÁϹ©²Î¿¼¡£
×¢Ò⣺
MySQLÖÁÉÙÐèÒªLinux 2.0°æ±¾¡£
ÒÔÏÂÊÇÍøÓÑÌṩµÄCentOS 5ϰ²×°MySQLµÄ²½Ö裨³ö´¦£ºhttp://wenda.tianya.cn/wenda/thread?tid=0c194eed74f2577b£©£¬½ö¹©²Î¿¼¡£
CentOS5ÏÂMySQLµÄ°²×°²½Öè
´´½¨mysqlÓû§×éºÍÓû§
[root@centos ]# groupadd mysql
[root@centos ]# useradd -g mysql mysql
[root@centos ]# cd homexule
[root@centos ]# chmod 755 mysql-5.0.22.tar.gz
±àÒë²¢°²×°MySQL
[root@centos ]# tar zxvf mysql-5.0.22.tar.gz
[root@centos ]#cd mysql-5.0.22
[root@centos mysql-5.0.22] .configure --prefix=usrlocalmysql
[root@centos mysql-5.0.22] make
[root@centos mysql-5.0.22] make install
ÅäÖò¢Æô¶¯MySQL
[root@centos mysql-5.0.22]# cp support-filesmy-medium.cnf etcmy.cnf
[root@centos mysql-5.0.22]# cd usrlocalmysql
[root@centos mysql]# binmysql_install_db --user=mysql
Installing all prepared tables
Fill help tables
To start mysqld at boot time you have to copy support-filesmysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands
usrlocalmysqlbinmysqladmin -u root password 'new-password'
usrlocalmysqlbinmysqladmin -u root -h centos.job100.com password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with
cd usrlocalmysql ; usrlocalmysqlbinmysqld_safe &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory
cd sql-bench ; perl run-all-tests
Please report any problems with the usrlocalmysqlbinmysqlbug script!
The latest information about MySQL is available on the web at
httpwww.mysql.com
Support MySQL by buying supportlicenses at httpshop.my
Ïà¹ØÎĵµ£º
tidy ÊÇÒ»¸ö·Ç³£°ïæµÄÍøÒ³´úÂë·ÖÎöºÍ¾À´íµÄ¹¤¾ß£¬Äܹ»Ö§³Ö¶àÖÖÒ³Ãæ±àÂ룬²¢ÇÒÖ§³ÖxhtmlÊä³ö¡£Èç¹ûÎÒÃÇ͵ÀÁ£¬ÉõÖÁ¿ÉÒÔ½«Õû¸öÒ³Ãæ»º´æ£¬×îºó²ÉÓÃtidy´¦Àí£¬×îºóÊä³öÍêÃÀµÄxhtml´úÂë¡£
linuxϰ²×°¹ý³ÌÈçÏ£º
Ê×ÏȰ²×°tidy £¬ÏÂÔØtidyÔ´´úÂ룺
cvs -d:pserver: anonymous@tidy.cvs.sourceforge.net Ϊ·À±¸µç×ÓÓʼþµØÖ·ÊÕ¼¯ ......
//µ¼³ö
String mysql="mysqldump -uroot -proot --opt databasename > d:/test.sql";
java.lang.Runtime.getRuntime().exec("cmd /c "+mysql);
//µ¼Èë
String mysql="mysqladmin -uroot -proot create databasename";
java.lang.Runt ......
mysql_affected_rows() ·µ»Ø±»×îеÄUPDATE, DELETE»òINSERT²éѯӰÏìµÄÐÐÊý¡£
mysql_close() ¹Ø±ÕÒ»¸ö·þÎñÆ÷Á¬½Ó¡£
mysql_connect() Á¬½ÓÒ»¸öMySQL·þÎñÆ÷¡£¸Ãº¯Êý²»ÍƼö£»Ê¹ÓÃmysql_real_connect()´úÌæ¡£
mysql_change_user() ¸Ä±äÔÚÒ»¸ö´ò¿ªµÄÁ¬½ÓÉϵÄÓû§ºÍÊý¾Ý¿â¡£
mysql_create_db() ´´½¨Ò ......
InnoDBÒ²Ö§³ÖÍâ¼üÔ¼Êø¡£InnoDBÖжÔÍâ¼üÔ¼Êø¶¨ÒåµÄÓï·¨¿´ÆðÀ´ÈçÏ£º
[CONSTRAINT symbol] FOREIGN KEY [id] (index_col_name, ...)
REFERENCES tbl_name (index_col_name, ...)
[ON DELETE {RESTRICT | CASCADE | SET NULL | NO ACTION}]
[ON UPDATE ......
mysql×Ö·û¼¯±àÂëÏòÀ´ÊÇÒ»¸öÄÑÌ⣬ÒòΪÓÐʱºòΪ´ó¶àÊýÈËÏëµÄUTF8¿ÉÒÔ½â¾öһЩÄÑÌ⣬²»¹ý²»ÒªÌ«ÀíÏ뻯ÁË£¬ÓÐʱºòÔÚwindow¿Í»§¶ËÏ Ð޸ijÉutf8£¬mysqlÊDz»Ö§³ÖµÄ£¬ËùÒÔ»¹µÃ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿ÉÊÇÕâ¸ö»¹ÕæµÃÐèÒªÄ㻨µãʱ¼äÀ´Ñо¿
ÏÂÃæÊÇһЩ±ðÈ˵ÄÎÄÕ£¬ÔÚ´ËÏÈлÁË
& ......