不能连接 [英] Cant't connect

问题描述

我有问题连接到我的本地服务器


完成之后：


c：\ mysql \ bin> mysqld --standalone


我试试：


C：\ mysql \ bin> mysql

ERROR 2003：无法连接到''localhost'上的MySQL服务器'（10061）


问题是什么，我在哪里可以获得帮助。


mvh

Curt

Hi, I have a problem to connect to my local server

After I have done:

c:\mysql\bin>mysqld --standalone

I try:

C:\mysql\bin>mysql
ERROR 2003: Can''t connect to MySQL server on ''localhost'' (10061)

Whats the problem, and where can I get help.

mvh
Curt

推荐答案

Curt Larsson写道：

Curt Larsson wrote:

你好，我有一个问题要连接到我的本地服务器

我完成后：

c：\ mysql \bin> mysqld --standalone

Hi, I have a problem to connect to my local server

After I have done:

c:\mysql\bin>mysqld --standalone

服务器正在运行吗？你在进程列表中看到它了吗？

Is the server running? Do you see it in the process list?

没有。

my.cnf文件中可能有问题。


＃示例mysql配置文件。

＃将此文件复制到c：\ my.cnf以设置全局选项

＃

＃可以使用程序支持的所有长选项。

＃使用--help运行程序以获取可用选项列表


＃这将传递给所有mysql客户端

[客户端]

＃password = my_password

port = 3306

＃socket = MySQL


＃这是一些特定程序的条目

＃以下值假设您至少有32M ram


#MySQL服务器

[mysqld]

port = 3306

＃socket = MySQL

跳过锁定

set-variable = key_buffer = 16K

set-variable = max_allowed_pa​​cket = 1M

set-variable = thread_stack = 64K

set-variable = table_cache = 4

set-variable = sort_buffer = 64K

set-variable = net_buffer_length = 2K

server-id = 1


＃如果要记录更新，请取消注释以下内容

＃log-bin


＃location

#basedir = d：/ mysql /

#dadadir = d：/ mysql / data /

＃取消评论如果您不使用BDB表，请执行以下操作

#skip -bdb


＃如果您使用的是Innobase表，请取消注释以下内容

#innodb_data_file_path = ibdata1：100M

#innodb_data_home_dir = c：\ibdata

#innodb_log_group_home_dir = c：\iblogs

#innodb_log_arch_dir = c：\iblogs

#set-variable = innodb_mirrored_log_groups = 1

＃set-variable = innodb_log_files_in_group = 3

＃set-variable = innodb_log_file_size = 5M

#set-variable = innodb_log_buffer_size = 8M

#innodb_flush_log_at_ trx_commit = 1

＃innodb_log_archive = 0

＃set-variable = innodb_buffer_pool_size = 16M

＃set-variable = innodb_additional_mem_pool_size = 2M
#set-variable = innodb_file_io_threads = 4

＃set-variable = innodb_lock_wait_timeout = 50

[mysqldump]

快

set-variable = max_allowed_pa​​cket = 16M

[mysql]

no-auto-rehash

＃如果您不熟悉SQL，请删除下一个注释字符

＃safe-updates


[isamchk]

set-variable = key_buffer = 8M

set-variable = sort_buffer = 8M

[myisamchk]

set-variable = key_buffer = 8M

set-variable = sort_buffer = 8M

[mysqlhotcopy]

interactive-timeout

Aggro < SP ********** @ yahoo.com> skrev i meddelandet

新闻：tP ************ @ read3.inet.fi ...

No.
Maybe something can be wrong in my.cnf file.

# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options

# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
set-variable = key_buffer=16K
set-variable = max_allowed_packet=1M
set-variable = thread_stack=64K
set-variable = table_cache=4
set-variable = sort_buffer=64K
set-variable = net_buffer_length=2K
server-id = 1

# Uncomment the following if you want to log updates
#log-bin

# Uncomment the following rows if you move the MySQL distribution to another
# location
#basedir = d:/mysql/
#datadir = d:/mysql/data/
# Uncomment the following if you are NOT using BDB tables
#skip-bdb

# Uncomment the following if you are using Innobase tables
#innodb_data_file_path = ibdata1:100M
#innodb_data_home_dir = c:\ibdata
#innodb_log_group_home_dir = c:\iblogs
#innodb_log_arch_dir = c:\iblogs
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M

[myisamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M

[mysqlhotcopy]
interactive-timeout
"Aggro" <sp**********@yahoo.com> skrev i meddelandet
news:tP************@read3.inet.fi...

Curt Larsson写道：

Curt Larsson wrote:

我有问题要连接到我的本地服务器

我完成后：

c：\ mysql \ bin> mysqld - 独立

Hi, I have a problem to connect to my local server

After I have done:

c:\mysql\bin>mysqld --standalone

服务器是否正在运行？你是否在进程列表中看到了它？

Is the server running? Do you see it in the process list?

Curt Larsson写道：

Curt Larsson wrote:

没有。
也许可以有什么东西可以my.cnf文件中有错误。

No.
Maybe something can be wrong in my.cnf file.

你有没改变它还是原创的？


你有什么后到底发生了什么？完成：


c：\ mysql \ bin> mysqld --standalone


是否打印任何消息？ error.log上有什么东西吗？

Have you changed it or is it original?

What exactly happens after you have done:

c:\mysql\bin>mysqld --standalone

Does it print any messages? Is there anything at the error.log?

这篇关于不能连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！