ÈÃMySQLÊý¾Ý¿â·þÎñÆ÷Ö§³ÖÔ¶³ÌÁ¬½Ó
1¡¢ÔÚ¿ØÖÆÌ¨Ö´ÐÐ mysql -u root -p mysql£¬ÏµÍ³ÌáʾÊäÈëÊý¾Ý¿ârootÓû§µÄÃÜÂ룬ÊäÈëÍê³Éºó¼´½øÈëmysql¿ØÖÆÌ¨£¬Õâ¸öÃüÁîµÄµÚÒ»¸ömysqlÊÇÖ´ÐÐÃüÁµÚ¶þ¸ömysqlÊÇϵͳÊý¾ÝÃû³Æ£¬²»Ò»ÑùµÄ¡£
2¡¢ÔÚmysql¿ØÖÆÌ¨Ö´ÐÐ GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyPassword' WITH GRANT OPTION;
3¡¢ÔÚmysql¿ØÖÆÌ¨Ö´ÐÐÃüÁîÖÐµÄ 'root'@'%' ¿ÉÒÔÕâÑùÀí½â: rootÊÇÓû§Ãû£¬%ÊÇÖ÷»úÃû»òIPµØÖ·£¬ÕâÀïµÄ%´ú±íÈÎÒâÖ÷»ú»òIPµØÖ·£¬ÄãÒ²¿ÉÌæ»»³ÉÈÎÒâÆäËüÓû§Ãû»òÖ¸¶¨Î¨Ò»µÄIPµØÖ·£»'MyPassword'ÊǸøÊÚȨÓû§Ö¸¶¨µÄµÇ¼Êý¾Ý¿âµÄÃÜÂ룻
Ïà¹ØÎĵµ£º
ΪÁ˸øG×¼±¸ÂÛÎÄ£¬ÏëÖ±½ÓÓÃÒ»¸öÏîÄ¿¡£
ÄǸöÏîÄ¿ÔÀ´ÓõÄÊý¾Ý¿âÊÇORACLE£¬µ«ËûµÄ»úÆ÷ÅäÖõͣ¬ÄÚ´æÖ»ÓÐ256M£¬ÅÜORALCEÁËÌ«³ÔÁ¦ÁË¡£ÓÚÊǾÍÏë°ÑÊý¾Ý¿â²¿·ÖÒÆÖ²µ½MYSQL¡£×Ô¼ºÏÈ
×öʵÑ飬Äêǰ¾Í×°ÁË£¬ÏÖÔÚÏë×öÒÆÖ²£¬ROOTÃÜÂë¸øÍüÁË¡£µ¹ÊÇ¿ÉÒÔ֨װ£¬¿ÉÄÇÒ»¶¨²»ÊÇ×î¼Ñ½â¾ö·½°¸¡£
UNIX°æ
1.ÏÈÍ£µômysql
# /etc/rc.d/init.d/mys ......
Linux°²×°Mysql+Apach+PHP+phpMyAdmin
¡¡¡¡ÎÒµÄϵͳÊÇredhat as5 ½¨Òé´ó¼ÒÍêÈ«°²×°£¬ÒÔÃⰲװʱȱÉÙÏà¹ØµÄ±àÒëÆ÷µÈµÈ¡£
Ò»¡¢°²×°mysql£¨mysql-5.0.21.tar.gz£©
# tar zxf mysql-5.0.21.tar.gz
# cd mysql-5.0.21
#./configure --prefix=/usr/local/mysql --sysconfdir=/etc --lo ......
mysql Ŀ¼Ï嵀 my.ini ÓÐÁ½´¦ÒªÐÞ¸Ä Ò»´¦ÊÇ [mysql] default-character-set=gbk »¹ÓÐÒ»´¦ÊÇ·ñÈϽ¨±íʱʹÓõÄ×Ö·û¼¯ default-character-set=gbk Á½´¦ÐÞ¸Äһϣ¬ÖØÐ½¨Á¢Êý¾Ý¿âºÍ±íºó¾Í²»»á³öÏÖÂÒÂëÁË¡£ ½¨±íʱҲ¿ÉÒÔÖ¸¶¨Êý¾Ý¿â»ò±íËùʹÓõÄ×Ö·û¼¯ Èç¹û²»ÄÜÖØ½¨Êý¾Ý¿âÔòÖ»ÄÜÔÚÖ¸¶¨µÄÊý¾Ý¿âĿ¼Ï°ѶÔÓ¦µÄ db.opt À ......
£¨1£©»ñÈ¡MysqlÊý¾Ý¿âµÄrootÓû§ÃÜÂëºÍÊý¾Ý¿âÓû§Ãû
£¨2£©ÉÏ´«ÌáȨphpľÂí£¬Í¨¹ýÁ¬½Ó3389¿ÉÒÔÖªµÀ·þÎñÆ÷ÊÇ2003ϵͳ
£¨3£©udf.dll¶ÔÓ¦²Ù×÷ϵͳ
C:\Winnt\udf.dll 2000
C:\Windows\udf.dll 2003
£¨4£©ÉèÖÃÏàÓ¦µÄ·¾¶ºóÖ±½Óµ¼³ö¡£
£¨5£©Ö´ÐÐÒÔÏÂÃüÁî
create function cmdshell returns string soname 'udf ......
½øÈëMySQL:mysql -u root -p password;
Í˳öMySQL:quit/exit;
´´½¨Êý¾Ý¿â£ºcreate database database-name;
ÏÔʾËùÓеÄÊý¾Ý¿â: show databases; ×¢ÒâÓиös;
ɾ³ýÊý¾Ý¿â£ºdrop database databasename;
lÁ¬½ÓÊý¾Ý¿â£ºuse databasename;Ìáʾ£ºdatabase changed;
Ñ¡Ôñµ±Ç°Êý¾Ý¿â£ºselect database();
µ±Ç°Êý¾Ý¿âËù°üº¬µÄ ......