ITeye博客

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

east_java · 2008-08-25 22:36 · database · Markdown

其实这些错误都是因为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 有这些就够了.

评论(0)

暂无评论。

评论功能维护中,当前仅展示历史评论。