mysql使用常见的错误解决方法

其实这些错误都是因为my.ini文件的问题

一.1067错误,说连接不上
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
[color=red]#设置basedir指向mysql的安装路径[/color]basedir=E:\eclipse\MySQL\mysql-5.1.6-alpha-win32
datadir=E:\eclipse\MySQL\mysql-5.1.6-alpha-win32\data

二.乱码

[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
#设置basedir指向mysql的安装路径
basedir=E:\eclipse\MySQL\mysql-5.1.6-alpha-win32
datadir=E:\eclipse\MySQL\mysql-5.1.6-alpha-win32\data
[color=red]default-character-set=utf8[/color]

三.服务启动了又自动关闭

[mysqld]
basedir=E:\eclipse\MySQL\mysql-5.0.22-win32
datadir=E:\eclipse\MySQL\mysql-5.0.22-win32\data
default-character-set=utf8
[color=red][WinMySQLadmin]
Server=E:\eclipse\MySQL\mysql-5.0.22-win32\bin\mysqld-nt.exe[/color]


my.ini文件
[mysqld]
basedir=E:\eclipse\MySQL\mysql-5.0.22-win32
datadir=E:\eclipse\MySQL\mysql-5.0.22-win32\data
default-character-set=utf8
[WinMySQLadmin]
Server=E:\eclipse\MySQL\mysql-5.0.22-win32\bin\mysqld-nt.exe
有这些就够了.