å¨æ¬å°è®¡ç®æºæ æ³å¯å¨MYSQLæå¡é误1067è¿ç¨æå¤ç»æ¢ è¿ç§æ
åµä¸è¬æ¯my.iniæ件é
ç½®åºéäºï¼
ä½ å¯ä»¥å é¤ç³»ç»ç®å½ä¸çmy.iniæ件ï¼
æä¸é¢çå
容éæ°åå
¥my.iniæ件è¯è¯ï¼
è¦éå½å°æ¹åä¸ä¸æ件路å¾
æçmy.ini 2007å¹´12æ31æ¥
[WinMySQLAdmin]
Server=C:/MYSQL/mysql/bin/mysqld-opt.exe
user=root
[mysqld]
basedir=C:/MYSQL/mysql
datadir=C:/MYSQL/mysql/data
#bind-address=192.168.0.2
#language=D:/MYSQL/share/chinese
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
[WinMySQLAdmin]
Server=D:/MYSQL/bin/mysqld-opt.exe
user=root
[mysqld]
basedir=D:/MYSQL
datadir=D:/MYSQL/data
#bind-address=192.168.0.2
#language=D:/MYSQL/share/chinese
ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï¼
æ¥æ¾Windowsç®å½ä¸çmy.iniæ件ï¼ç¼è¾å
容ï¼å¦æ没æ该æ件ï¼åæ°å»ºä¸ä¸ªï¼ï¼è³å°å
å«basedirï¼datadirè¿ä¸¤ä¸ªåºæ¬çé
ç½®ã
[mysqld]
# set basedir to installation path, e.g., c:/mysql
# 设置为MYSQLçå®è£
ç®å½
basedir=D:/www/WebServer/MySQL
# set datadir to location of data directory,
# e.g., c:/mysql/data
# 设置为MYSQLçæ°æ®ç®å½
datadir=D:/www/WebServer/MySQL/dataãã
å¦å¤ï¼è¦æ³¨æï¼
[WinMySQLadmin]
Server=D:/www/WebServer/MySQL/bin/mysqld-nt.exe
user=root
password=xxxxxxxx
#以ä¸æ¯è®¾ç½®WinMySQLadminçé
ç½®
[Client]
user=root
password=xxxxxxxx
å°Mysqlæ·»å å°Windowsç³»ç»æå¡ä¸ï¼
1.ã å®è£
æå¡ã
å¨Windows2000ä¸ï¼å®è£
å®æåï¼å¹¶æ²¡ææMySQLå®è£
ææå¡ï¼æ们å¿
é¡»æ§è¡ä¸é¢çè¯å¥æMySQL注å为æå¡ï¼installdir\mysql\bin\mysqld-nt â-installã
Windows98ä¸æ²¡ææå¡çæ¦å¿µï¼æ以ä¸ç¨å®è£
æå¡ã
2.ã å¯å¨æå¡
å¨Windows2000ä¸ï¼å®è£
æå¡åå¯ä»¥å¯å¨MySQLæå¡ï¼net start mysqlã
å¨Windows98ä¸ï¼å¯ä»¥ç¨ä¸é¢çå½ä»¤å¯å¨æå¡ï¼c:\mysql\bin\mysqldï¼æå¡å¯å¨åå¨åå°è¿è¡ï¼å¹¶æ²¡æçé¢ã
3.ã åæ¢æå¡
å¨Windows2000ä¸ï¼å¯ä»¥éè¿ä¸é¢çå½ä»¤åæ¢MySQLæå¡ï¼net stop mysqlã
å¨Windows98ä¸ï¼å¯ä»¥éè¿ä¸é¢å½ä»¤åæ¢æå¡ï¼C:\> C:\mysql\bin\mysqladmin -u root shutdown
温馨提示:答案为网友推荐,仅供参考