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

最新推荐文章于 2025-11-23 21:36:02 发布

最新推荐文章于 2025-11-23 21:36:02 发布 · 126 阅读

文章标签：

#MySQL #Eclipse #Socket #Cache #.net

database 专栏收录该内容

7 篇文章

订阅专栏

本文解决了MySQL服务启动过程中遇到的三个常见问题：1067错误、字符集乱码及服务自动关闭。通过调整my.ini文件中的配置项，如设置正确的端口、socket路径、字符集以及指定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
有这些就够了.