mysql使用常见的错误解决方法
其实这些错误都是因为my.ini文件的问题
一.1067错误,说连接不上
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
二.乱码
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 default-character-set=utf8
三.服务启动了又自动关闭
basedir=E:\eclipse\MySQL\mysql-5.0.22-win32 datadir=E:\eclipse\MySQL\mysql-5.0.22-win32\data default-character-set=utf8 Server=E:\eclipse\MySQL\mysql-5.0.22-win32\bin\mysqld-nt.exe
my.ini文件
basedir=E:\eclipse\MySQL\mysql-5.0.22-win32 datadir=E:\eclipse\MySQL\mysql-5.0.22-win32\data default-character-set=utf8
Server=E:\eclipse\MySQL\mysql-5.0.22-win32\bin\mysqld-nt.exe 有这些就够了.