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

MySQL 5.0°²×°Í¼½â

ÏÂÃæµÄÊÇMySQL°²×°µÄͼ½â:¡¡¡¡
Ë«»÷ÔËÐГsetup.exe”£¬³öÏÖÈçϽçÃæ£º 
mysql°²×°Ïòµ¼Æô¶¯£¬°´“Next”¼ÌÐø
Ñ¡Ôñ°²×°ÀàÐÍ£¬ÓГTypical£¨Ä¬ÈÏ£©”¡¢“Complete£¨ÍêÈ«£©”¡¢“Custom£¨Óû§×Ô¶¨Ò壩”Èý¸öÑ¡ÏÎÒÃÇÑ¡Ôñ“Custom”£¬Óиü¶àµÄÑ¡ÏҲ·½±ãÊìϤ°²×°¹ý³Ì
ÔÚ“Developer Components£¨¿ª·¢Õß²¿·Ö£©”ÉÏ×ó¼üµ¥»÷£¬Ñ¡Ôñ“This feature, and all subfeatures, will
be installed on local hard drive.”£¬¼´“´Ë²¿·Ö£¬¼°ÏÂÊô×Ó²¿·ÖÄÚÈÝ£¬È«²¿°²×°ÔÚ±¾µØÓ²ÅÌÉÏ”¡£ÔÚÉÏÃæµÄ“MySQL
Server£¨mysql·þÎñÆ÷£©”¡¢“Client
Programs£¨mysql¿Í»§¶Ë³ÌÐò£©”¡¢“Documentation£¨Îĵµ£©”Ò²Èç´Ë²Ù×÷£¬ÒÔ±£Ö¤°²×°ËùÓÐÎļþ¡£µãÑ¡“Change...”£¬ÊÖ¶¯Ö¸¶¨°²×°Ä¿Â¼¡£
ÌîÉϰ²×°Ä¿Â¼£¬ÎÒµÄÊÇ“F:\Server\MySQL\MySQL Server
5.0”£¬Ò²½¨Òé²»Òª·ÅÔÚÓë²Ù×÷ϵͳͬһ·ÖÇø£¬ÕâÑù¿ÉÒÔ·Àֹϵͳ±¸·Ý»¹Ô­µÄʱºò£¬Êý¾Ý±»Çå¿Õ¡£°´“OK”¼ÌÐø¡£
·µ»Ø¸Õ²ÅµÄ½çÃæ£¬°´“Next”¼ÌÐø¡£
È·ÈÏÒ»ÏÂÏÈǰµÄÉèÖã¬Èç¹ûÓÐÎ󣬰´“Back”·µ»ØÖØ×ö¡£°´“Install”¿ªÊ¼°²×°¡£
ÕýÔÚ°²×°ÖУ¬ÇëÉÔºò£¬Ö±µ½³öÏÖÏÂÃæµÄ½çÃæ
ÕâÀïÊÇѯÎÊÄãÊÇ·ñҪע²áÒ»¸ömysql.comµÄÕ˺ţ¬»òÊÇʹÓÃÒÑÓеÄÕ˺ŵǽmysql.com£¬Ò»°ã²»ÐèÒªÁË£¬µãÑ¡“Skip
Sign-Up”£¬°´“Next”ÂÔ¹ý´Ë²½Öè¡£
ÏÖÔÚÈí¼þ°²×°Íê³ÉÁË£¬³öÏÖÉÏÃæµÄ½çÃæ£¬ÕâÀïÓÐÒ»¸öºÜºÃµÄ¹¦ÄÜ£¬mysqlÅäÖÃÏòµ¼£¬²»ÓÃÏòÒÔǰһÑù£¬×Ô¼ºÊÖ¶¯ÂÒÆß°ËÔãµÄÅäÖÃmy.iniÁË£¬½« “Configure
the Mysql Server now”Ç°ÃæµÄ¹´´òÉÏ£¬µã“Finish”½áÊøÈí¼þµÄ°²×°²¢Æô¶¯mysqlÅäÖÃÏòµ¼¡£
mysqlÅäÖÃÏòµ¼Æô¶¯½çÃæ£¬°´“Next”¼ÌÐø¡£
Ñ¡ÔñÅäÖ÷½Ê½£¬“Detailed Configuration£¨ÊÖ¶¯¾«È·ÅäÖã©”¡¢“Standard
Configuration£¨±ê×¼ÅäÖã©”£¬ÎÒÃÇÑ¡Ôñ“Detailed Configuration”£¬·½±ãÊìϤÅäÖùý³Ì¡£
Ñ¡Ôñ·þÎñÆ÷ÀàÐÍ£¬“Developer Machine£¨¿ª·¢²âÊÔÀ࣬mysqlÕ¼ÓúÜÉÙ×ÊÔ´£©”¡¢“Server
Machine£¨·þÎñÆ÷ÀàÐÍ£¬mysqlÕ¼Óý϶à×ÊÔ´£©”¡¢“Dedicated MySQL Server
Machine£¨×¨ÃŵÄÊý¾Ý¿â·þÎñÆ÷£¬mysqlÕ¼ÓÃËùÓпÉÓÃ×ÊÔ´£©”£¬´ó¼Ò¸ù¾Ý×Ô


Ïà¹ØÎĵµ£º

mysqlÖ÷´ÓÊý¾Ý¸´ÖÆ

Ò»¡¢Îª´ÓÊý¾Ý¿âÉèÖø´ÖÆÕ˺Å
grant REPLICATION SLAVE on *.* To 'backup'@'%' identified by 'backuppwd'
flush privileges
 
¶þ¡¢µ¼³öÊý¾Ý
(1)Ö±½Ó¸´ÖÆÊý¾ÝÎļþĿ¼·½·¨
a. Í£Ö¹Êý¾Ý¿âдÊý¾Ý
flush tables with read lock
b.ÏÔʾ´ËʱmasterµÄ״̬
show master status
¼ÆÏ´ËʱÖ÷Êý¾Ý¿âµÄbinlogµ ......

PHP mysqlÊÂÎñ´¦Àí »Ø¹ö²Ù×÷

MYSQLÖÐÖ»ÓÐINNODBºÍBDBÀàÐ͵ÄÊý¾Ý±í²ÅÄÜÖ§³ÖÊÂÎñ´¦Àí£¡ÆäËûµÄÀàÐÍÊDz»Ö§³ÖµÄ£¡
$lnk = mysql_connect("localhost", "root", "");
mysql_select_db("test");
mysql_query("BEGIN");
$query = mysql_query("INSERT INTO test VALUES(1, 'yangjun')&quo ......

Weblogic 9.1µÄdomainÅäÖÃmysqlÁ¬½Ó³Ø

 
Weblogic 9.1µÄdomainÅäÖÃmysqlÁ¬½Ó³Ø
¡¡¡¡±¾ÎĽéÉÜÔÚweblogic 9.1ϵÄdomainÅäÖÃmysqlÁ¬½Ó³Ø²½Ö裺
¡¡¡¡1.ÔÚweblogicĿ¼ÏµÄserverlibÏÂÌí¼ÓmysqlÇý¶¯
¡¡¡¡mysql-connector-java-3.1.11-bin.jar
¡¡¡¡2.ÔÚweblogicĿ¼ÏµÄcommoninÏÂÕÒµ½commEnv.cmd´ò¿ª
¡¡¡¡ÕÒµ½set weblogic_classpath= ºó±ß¼ÓÉÏmysqlÇý¶¯ ......

C#.NETÁ¬½Ómysql·½·¨


 mysql.data.dll¿½±´µ½binÏÂÃæ²¢ÒýÓÃÒ»ÏÂ
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string myConnectionString = "Database=test;Data Source=localhost;User Id=root;Password=admin" ......

ÁªÏëR520 °²×° AS4.4 +apache+mysql+php

 Õ⼸Ìì°²×°ÁËһ̨linux·þÎñÆ÷¡£±¾À´Ò»Î»Í¦¼òµ¥¸öÊ£¬Ã»Ïëµ½ÕÛÌÚÁ˺ü¸Ìì¡£
Ê×ÏÈÊÇ °²×° AS4.4
·þÎñÆ÷ÊÇÁªÏë R520 G6£¬±¾ÒÔΪŪ¸öаæµÄunbuntu¾ÍÄÜÇý¶¯ÆðÀ´£¬Ã»Ïëµ½ÉÏÀ´¾ÍÓöµ½ÁËÂé·³¡£Ð°æµÄlinux»¹ÊÇû°ì·¨Çý¶¯ÆðÀ´£¬ÁªÏëËæ»ú¸øµÄÇý¶¯×î¸ß¾Íµ½AS4.4£¬Ã»°ì·¨Ö»ºÃÕÒÕÒAS4.4 °²×°ÁË¡£
Ê×ÏȹâÅÌÆô¶¯ ÊäÈë linux dd&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ