wampÈçºÎÐÞ¸ÄmysqlĬÈÏ¿ÕÃÜÂë
cmdÏÂÇл»µ½ mysql °²×°Ä¿Â¼
Àý
d:/mysql/bin
(Èç¹ûÓÃWAMP°²×°ÔòÊÇD:\wamp\bin\mysql\mysql5.1.30\bin)
Ç°Ì᣺mysqlÓû§rootÃÜÂëΪ¿Õ.
Êä
Èë mysql -u root mysql
mysql> ״̬ÏÂÊäÈë
update user set password=password('ÐÂÃÜÂë') where user='root';
ȯ
ÏÔ
Query OK, 0 rows affected (0.00 sec)
Rows
matched: 2 Changed: 0 Warnings: 0
mysql> ״̬ÏÂÊäÈë FLUSH PRIVILEGES;
ȯ
ÏÔ
Query OK, 0 rows affected (0.00 sec)
mysql> ״̬ÏÂÊäÈë quit
Í˳ö sql
×¢Òâÿ¸öÃüÁîºó¶¼Òª¼ÓÉÏÒ»¸ö·ÖºÅ ";"
mysql ²Å¿ªÊ¼Ö´ÐиÃÐÐÃüÁî
¶ø
µÚ¶þ¸öÖ¸Áî»áÈÃÒÑÔØÈë¼ÇÒäÌåµÄ mysql ϵͳ×ÊÁÏ¿â¸üÐÂ
ÖØÆð mysql .
ÔÚ¸üРroot ÃÜÂëºó£¬ÒÔºóÒªÓë
MySQL Á¬½ÓµÄ·½·¨Îª£º
mysql -u root -p ÐÂÃÜÂë
¶þ¡¢ÐÞ¸ÄphpmyadminÖÐ
mysql¡¡rootµÄ¿Õ¸ÄΪÐÂÃÜÂë
Àý£ºD:\wamp\apps\phpmyadmin3.0.1.1ϵÄ
config.incÎļþÖÐ
$cfg['Servers'][$i]['password']
= ''¸ÄΪ
$cfg['Servers'][$i]['password']
= 'newpassword'
Ïà¹ØÎĵµ£º
×òÌìÉè¼ÆÊý¾Ý¿â±íµÄʱºò£¬ÒòΪʹÓÃvarchar²úÉúÁËÒìÒ飬½á¹ûÒ»²é·¢ÏÖÎÒÃÇÁ½¸ö˶¼Ã»´í¡£
MySQLÊý¾Ý¿âµÄvarcharÀàÐÍÔÚ4.1ÒÔϵİ汾ÖеÄ×î´ó³¤¶ÈÏÞÖÆΪ255£¬ÆäÊý¾Ý·¶Î§¿ÉÒÔÊÇ0~255»ò1~255£¨¸ù¾Ý²»Í¬°æ±¾Êý¾Ý¿âÀ´
¶¨£©¡£
ÔÚMySQL5.0ÒÔÉϵİ汾ÖУ¬varcharÊý¾ÝÀàÐ͵ij¤¶ÈÖ§³Öµ½ÁË65535£¬Ò ......
Óà OPTIMIZE TABLE ÓÅ»¯ mysql ±í
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:gangzhong
REPAIR TABLE `table_name` ÐÞ¸´±í OPTIMIZE TABLE `table_name` ÓÅ»¯±í myisamchk table.MYI ÐÞ¸´Ë÷Òý REPAIR TABLE ÓÃÓÚÐÞ¸´±»ÆÆ»µµÄ±í¡£ myisamchk TABLE.MYI ÓÃÓÚÐÞ¸´±»ÆÆ»µµÄË÷ÒýÎļþ¡£ OPTIMIZE TABLE ÓÃÓÚ»ØÊÕÏÐÖõÄÊý¾Ý ......
# cd /home/tmp (½øÈëѹËõ°üËùÔÚĿ¼)
# groupadd mysql (½¨Á¢mysql×é)
# useradd -g mysql mysql (ÔÚmysql×éÖн¨Á¢mysqlÓû§)
# tar -zxvf mysql-5.0.37.tar.gz (½âѹmysqlÔ´Âë,bz2ѹËõ°üÇëÓÓtar -jvxf ÎļþÃû”Ö¸Áî)
# cd mysql-5.0.37 (½øÈë½âѹĿ¼)
# ./configure --prefix=/usr/local/mysql (p ......
ÔÚphpmyadminµÄ¸ùĿ¼Ï½¨Á¢config.inc.php
дÈëÈçÏ´úÂ룺
<?php
//phpmyadmin ÅäÖÃÎļþ
//±¾µØMySQLÊý¾Ý¿â
$i=1;
$cfg['Servers'][$i]['host'] =
'localhost';
$cfg['Servers'][$i]['user'] ......
1¡¢Ð½¨¶¯Ì¬webÏîÄ¿¡£
2¡¢Ìí¼Ójar°ü
½«mysql jdbcÇý¶¯Ìí¼Óµ½tomcat°²×°Ä¿Â¼ÏµÄlibĿ¼¡£
3¡¢ÔÚMETA-INFÏÂÌí¼Ócontent.xmlÎļþ¡£ÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable="true" crossContext="true">
<!-- Default set of monitored resources - ......