mysql服务1067错误多种解决方案分享

复制代码 代码如下:

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=d:/MySQL5.0/
#bind-address=127.0.0.1
datadir=d:/MySQL5.0/data
#language=D:/usr/local/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=d:/MySQL5.0/bin/mysqld-nt.exe
user=root
password=
然后在bin目录下
mysqld-nt -remove
mysqld-nt -install
net start mysql
ok!

复制代码 代码如下:

# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB
将"INNODB“修改"MYISAM"为：
default-storage-engine=MYISAM

复制代码 代码如下:

basedir=C:/mysql-5.1.11-beta-win32
datadir=C:/mysql-5.1.11-beta-win32data

复制代码 代码如下:

C:/mysql-5.1.11-beta-win32bin>net start mysql

复制代码 代码如下:

C:/mysql-5.1.11-beta-win32bin>mysqld-nt --remove
Service successfully removed.
C:/mysql-5.1.11-beta-win32bin>mysqld-nt --install
Service successfully installed.
C:/mysql-5.1.11-beta-win32bin>net start mysql

复制代码 代码如下:

C:/mysql-5.1.11-beta-win32bin>net stop mysql

复制代码 代码如下:

# set basedir to installation path, e.g., c:/mysql
# 设置为MYSQL的安装目录
basedir=D:/Program Files/mysql-5.0.45-win32
# set datadir to location of data directory,
# e.g., c:/mysql/data or d:/mydata/data
# 设置为MYSQL的数据目录
datadir=D:/Program Files/mysql-5.0.45-win32/data

复制代码 代码如下:

[WinMySQLServer]
server=c:Program FilesMySQLMySQL Server 5.0binmysqld-nt.exe
CMD下运行：
c:Program FilesMySQLMySQL Server 5.0binmysqld-nt.exe remove
c:Program FilesMySQLMySQL Server 5.0binmysqld-nt.exe install
net mysql start

复制代码 代码如下:

%MySQLInstallPath%bin/MySQLInstanceConfig.exe