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

¹ØÓÚMySQLµÄ1067´íÎó½â¾ö·½·¨

 
ÄÚÈÝ£º
*************
1
°²×°£Í£Ù£Ó£Ñ£Ìºó¸ü¸ÄÁˣңϣϣԵÄÃÜÂëºóÓÃ
net startmysql
Æô¶¯Ê±ÎÒ¾ÍÓöµ½ÁËÕâÑùµÄÎÊÌ⣮ʹÓÃÒÔÏÂÃüÁîºó
c:\mysql\bin\mysqladmin-u root -p shutdown
ÔÙnet start mysql¾ÍûÓÐÕâ¸ö´íÎóÌáʾÁË!
*************
2
MySQLµÄ1067´íÎó
Q£ºÎÒµÄMysqlÅöµ½ÁË 1067 ´íÎó
´íÎóÐÅϢΪ£º
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.
A£ºÔÚÎҵĻúÉϵĽâ¾ö°ì·¨ÊÇ£º
ÐÞ¸Ä%windir%\my.ini£¬Ôö¼Ó
[mysqld]
#ÉèÖÃbasedirÖ¸ÏòmysqlµÄ°²×°Â·¾¶
basedir=D:\Program\Tools\mysql
datadir=D:\Program\Tools\mysql\data
*************
3
ÒѾ­ÅªºÃÁË!!!
ºÃÏñÊÇÕâÑù……
mysql_install_db½Å±¾Ö»ÊÇ
ÔÚ³õ´Î°²×°Ê±²ÅÐèÒªÔËÐÐÒ»´Î,Ö®ºó¾Í²»ÓÃÔÙÔËÐÐÁË,²»ÖªµÀÊDz»ÊÇÕâô»ØÊÂ.ÎÒ°Ñmysql.server¿½±´ÖÁ/etc/rc.d/init.d/ÖÐ,ÔË
ÐÐchkconfig mysql.server,ÖÁ´Ëmysql·þÎñÆ÷ÿ´Î¿ª»ú×Ô¶¯Æô¶¯,Ö»ÒªÉèÖúÃPATH,ÔÚÃüÁîÐÐÉÏÊäÈëmysql¾ÍÒ»Çи㶨!
¿´À´ÃþË÷µÄ¹ý³ÌʵÔÚÊÇÍ´¿à°¡,ÕâÒѾ­ÕÛÄ¥ÎҺü¸ÌìÁË……
*************
4
ÎÊ£ºÎÒµÄMysqlÅöµ½ÁË 1067 ´íÎó
´íÎóÐÅϢΪ£º
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.
´ð£º
½â¾ö°ì·¨£º
1.¼ì²éÄãµÄMysqlĿ¼ÓÐûÓиøϵͳµÄSystemÓû§È¨ÏÞ¡£
2.ɾ³ýµôÄãµÄ %WINDOWS%/my.ini Îļþ¡£
3.¼ì²éÄãµÄ c:/my.cnf ÎļþÅäÖÃÊÇ·ñÕýÈ·¡£
*************
5
¡¾¡î¡î¡î¡¡MySql¸ÅҪ˵Ã÷¡¡¡î¡î¡î¡¿
MySqlµÄĬÈÏ°²×°Ä¿Â¼ÊÇc:mysql£¬°²×°½áÊøºóûÓÐÈκÎÌáʾÐÅϢ˵°²×°½áÊø£¬Çë
µãFinish°´Å¥Ö®ÀàµÄ»°£¬Ö±½Ó¾ÍÍ˳öÁË¡£Èç¹ûÐèÒª°²×°µ½ÆäËûĿ¼£¬½¨ÒéÏÈ°²×°µ½c:mysql£¬È»ºóÔÙÕû¸öĿ¼moveµ½×Ô¼ºÏ£ÍûµÄµØ·½£¬ÀýÈçÒƶ¯µ½
d:mysql Ö®ºó£¬ÐèÒª±à¼­ d:mysqlmy-example.cnf £¨*.cnfµÄÎļþÔÚWindows 2000Öлᱻע²á³ÉΪ
SpeedDialÎļþ£¬ÔÚ×ÊÔ´¹ÜÀíÆ÷ÖÐÎÞ·¨²Ù×÷£¬ÒªÓÃÃüÁîÐÐÀ´Æô¶¯notepad±à¼­£¬ÀýÈçÔËÐÐnotepadd:mysqlmy-
example.cnf £¬µ«ÊÇÕâ¸öÎļþÊÇUNIXϵͳϵÄÎı¾Îļþ¸ñʽ£¬ÔÚnotepadÖв»ÄÜÕýÈ·»»ÐУ¬¿ÉÒÔÓÃwrite´ò¿ª±à¼­£¬
»òÕßÓÃwrite´ò¿ªºó±£´æÒ»´Î£¬ÔÙÓÃnotepad¾Í¿ÉÒԱ༭ÁË¡££©ÕÒµ½basedirÒ»ÐУ¬È¥µôÇ°ÃæµÄ“#”ºÅ×¢ÊÍ£¬½«ºóÃæµÄ·¾¶¸ÄΪÒƶ¯ºóµÄĿ¼£¨Ä¿Â¼·Ö¸ô·ûÒªÓÃбÏ߶ø²»ÊÇ·´Ð±Ïߣ©£¬È»ºóÁí´æΪ£ºc:my.cnf
Ó÷þÎñ·½Ê½Æô¶¯µÄMy


Ïà¹ØÎĵµ£º

mysqlĬÈÏÊÇÖ»ÄÜ´Ólocalhost·ÃÎÊ

 ËùÒÔ³ýÁ˸øÕË»§È¨ÏÞÒÔÍâ »¹ÓÐÐÞ¸Ä /etc/mysql/my.cnf
ÕÒµ½ bind-address = 127.0.0.1 ÐÞ¸ÄΪ bind-address = 0.0.0.0
ÖØÆômysql : sudo /etc/init.d/mysql restart
·ñÔò»á±¨ ERROR 2003 (HY000): Can't connect to MySQL server on 'x.x.x.x' (111)
ºÃ°É ÎÒÊÇmysql²ËÄñ ÒÔÇ°¶¼ÊÇ×ßlocalhostµÄ
......

java£¨jsp)ʹÓÃMySqlÊý¾Ý¿â,ÖÐÎÄÂÒÂëµÄÍêÕû½â¾ö·½°¸

 java£¨jsp)ʹÓÃMySqlÊý¾Ý¿â,ÖÐÎÄÂÒÂëµÄÍêÕû½â¾ö·½°¸
mysqlÊÇÒ»¸öСÐ͵ĿªÔ´µÄÊý¾Ý¿â£¬ÓÃÀ´×ÔѧһЩ¼¼ÊõÊÇÊ®·Ö·½±ãµÄ¡£µ«Ê¹ÓÃmysql´æ´¢Êý¾Ý£¬Ò²»áÓöµ½Ò»Ð©·Ç³£¶ñÐĵÄÎÊÌ⣬È磺ÖÐÎÄÂÒÂëÎÊÌâ¡¢javaÇý¶¯³ÌÐòÎÞ·¨Ê¹ÓõÄÎÊÌ⣨ÒѾ­½â¾ö£¬Ïê¼û£ºhttp://hi.baidu.com/lauo1988/blog/item/ff0da655bd3e2eceb745ae0b.html)¡£ ......

·ÖÏíÒ»¸ömysqlÀà~

 
<?php
/**
* ²Ù×÷mysql
µÄ»ù´¡À࣬ÆäËüÓëmysqlÓйصÄÀ඼¼Ì³ÐÓÚ´Ë»ùÀà
*
* ´ËclassÖеÄ$table¶¼ÊÇÒѾ­°üº¬±íǰ׺µÄÍêÕû±íÃû
*
* ver 20090717
* ʹÓ÷¶Àý
* $db = new DB('localhost','root','password','database','utf8');
* $db->debug = true;
* $db->primaryKeys = array (
* 'table_1 ......

Ô¶³ÌÁ¬½Ómysql

½â¾ö·½·¨(ת)£º---µ«Ö´ÐеÚÒ»Öְ취ʱ³öÏÖ´íÎ󣬵ڶþÖÖ°ì·¨³É¹¦
1¡£¸Ä±í·¨¡£¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
mysql -u root -pvmwaremysql>use mysql;mysql>update use ......

ÖØа²×°mysqlµÄÐĵÃ

Ôø¾­Ê§°Ü¹ýn´Î£¬ÈÃÎÒÏ൱ÎÞÄÎ×îºóÖÕÓÚÕÒµ½ÁËÒ»¸ö½â¾ö·½°¸£¬¹©´ó¼Ò·ÖÏí
ɾµô×¢²á±íµÄ·½·¨£¬ÎÒÒ²Ôø¾­Óùý£¬µ«×ÜÊÇʧ°Ü£¬½¨ÒéÈçÏÂ
Ò»£ºÏÈжÔØÈí¼þmysql
¶þ£ºÏÈɾע²á±íµÄ¶«Î÷£»
Èý£º×îºóÔÚÄãµÄµ±Ç°Óû§ÀïcÅÌÏÂC:\Documents and Settings\All Users\Application Data\ÕÒµ½mysqlµÄĿ¼£¬É¾µô£¬ÍüÁ˸æËßÒ»¾ä£»
ÄÇÊÇÒþ²ØÎļþ£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ