无法连接到mySQL数据库 [英] Can no connects to mySQL database

查看:133
本文介绍了无法连接到mySQL数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

phpMyAdmin 2.6.2问题:无法连接到mySQL数据库:每次

显示错误#1045 - 访问被拒绝用户''用户名''''''192.168.1.2''

(使用密码:是)

看来,这是mySOL和phpMyAdmin最常见的问题。

非常难看且不方便的程序。

phpMyAdmin 2.6.2 problem: can no connects to mySQL database: each time
shown error #1045 - Access denied for user ''username''@''192.168.1.2''
(using password: YES)
Is seems, this is most common problem for mySOL and phpMyAdmin.
Extremelly ugly and inconvenient program.

推荐答案

mistral写道:
mistral wrote:

phpMyAdmin 2.6.2问题:无法连接到mySQL数据库:每次

显示错误#1045 - 访问被拒绝用户''username''@''192.168.1.2''

(使用密码:是)

看来,这是mySOL和phpMyAdmin最常见的问题。

非常丑陋和不方便的程序。
phpMyAdmin 2.6.2 problem: can no connects to mySQL database: each time
shown error #1045 - Access denied for user ''username''@''192.168.1.2''
(using password: YES)
Is seems, this is most common problem for mySOL and phpMyAdmin.
Extremelly ugly and inconvenient program.



如果您正确设置了MySQL安全性并且使用

正确的用户ID和密码,则完全没有。


也许您可以做得更好?我相信SourceForge会喜欢这样的另一个

项目。


-

======= ===========

删除x来自我的电子邮件地址

Jerry Stuckle

JDS计算机培训公司
js ******* @ attglobal.net

==================

Not at all if you have MySQL security set up properly and use the
correct userid and password.

Perhaps you could do better? I''m sure SourceForge would love another
project like this.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================


mistral写道:
mistral wrote:

phpMyAdmin 2.6.2问题:无法连接到mySQL数据库:每次

显示错误#1045 - 访问被拒绝用户''username''@''192.168.1.2''

(使用密码:是)

看来,这是mySOL和phpMyAdmin最常见的问题。

非常难看和不方便的程序。
phpMyAdmin 2.6.2 problem: can no connects to mySQL database: each time
shown error #1045 - Access denied for user ''username''@''192.168.1.2''
(using password: YES)
Is seems, this is most common problem for mySOL and phpMyAdmin.
Extremelly ugly and inconvenient program.



为什么要使用它,如果你觉得它很臭?

去找一个更好的工具或者像Jerry建议的那样自己编写。

我个人认为抱怨给你的程序是非常蹩脚的

由严肃的程序员随意免费使用。

完全没问题你不喜欢他们,但不要向我们抱怨

。我知道很多快乐的mySQL和phpmyadmin用户。


但是,这是一个常见问题,但它只发生在某种类型的

用户身上。

我敢打赌,你是那些太高级程序员之一,没有什么需要阅读文档,并希望点并点击''以同样的方式

你启动你的前景。阅读文档是沉闷和尘土飞扬的

COBOL程序员,不是吗?


去RTFM,你的所有问题都将得到解决。

请不要侮辱制造商,称他们的软件很难看,而且b $ b不方便。他们不应该这样。


问候,

Erwin Moller

Why use it if you think it stinks?
Go find a better tool or write your own as Jerry suggested.
Personally I think it is very lame to complain about programs given to you
by serious programmers for free to do with as you like.
It is completely fine that you don''t like them, but don''t complain to us
about it. I know a lot of happy mySQL and phpmyadmin users.

But yes, it is a common problem, but it only happens to a certain kind of
user.
My bet is you are one of those ''too advanced programmers'' that don''t have
need to read the documentation, and want to ''point and click'' the same way
you start up your outlook. Reading documentation is for dull and dusty
COBOL programmers, isn''t it?

Go RTFM and all your problems will be solved.
And please don''t insult the makers by calling their software ugly and
inconvenient. They didn''t deserve that.

Regards,
Erwin Moller


" Jerry Stuckle写道:

"
"Jerry Stuckle wrote:
"

mistral写道:
mistral wrote:

phpMyAdmin 2.6.2问题:无法连接到mySQL数据库:每次

显示错误#1045 - 访问被拒绝用户''username''@''192.168.1.2''

(使用密码:是)

看来,这是mySOL和phpMyAdmin最常见的问题。

非常难看且不方便的程序。
phpMyAdmin 2.6.2 problem: can no connects to mySQL database: each time
shown error #1045 - Access denied for user ''username''@''192.168.1.2''
(using password: YES)
Is seems, this is most common problem for mySOL and phpMyAdmin.
Extremelly ugly and inconvenient program.


如果您正确设置了MySQL安全性并使用

正确的用户ID和密码,则完全没有。
Not at all if you have MySQL security set up properly and use the
correct userid and password.


也许你可以做得更好?我确定SourceForge会喜欢这样的另一个

项目。
Perhaps you could do better? I''m sure SourceForge would love another
project like this.


-

==================

删除x来自我的电子邮件地址

Jerry Stuckle

JDS计算机培训公司
js ******* @ attglobal.net

==================
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================



我可以确认这个mySql和phpMyAdmin异常

不舒服的东西。

设计不好,记录不好。很多逻辑错误..

更糟糕的是,开发人员*不知道*如何纠正

问题。

I can confirm that this mySql and phpMyAdmin is exceptionally
uncomfortable things.
Bad designed, bad documented. Plenty logic errors..
And what most worse thing, developers *do not know* how to correct an
issue.


>"如果您正确设置了MySQL安全性并使用

正确的用户ID和密码,则完全没有。
>"Not at all if you have MySQL security set up properly and use the
correct userid and password."



您是否曾尝试在共享虚拟主机上执行此操作,此时您没有

*任何*访问所有这些config文件?为什么用户需要关于这种毫无意义的配置设置?你会得到头脑和

可以花上几周甚至一个月来解决这个stupis安全问题

问题。为什么MySQL需要比FTP程序更高的安全性?(这可以工作

就好了)任何ftp工作都很好


很多用户无法访问它自己安装的MySQL数据库即便上它

自己的电脑。愚蠢的系统产生错误#1045 - 访问被拒绝。所以

称为''securiy settings issue''只是偏执狂。为什么不默认从任何IP设置访问

到phpmyadmin / mySQL?


你有没有真正的想法如何修复这个''错误#1045 - 访问被拒绝for

用户''远程虚拟主机?我怀疑你有什么想法。

Have you tried do this at shared virtual hosting, where you have no
*any* access to all this "config" files? Why user need to have headashe
about this senseless configuration settings? You will get headASHE and
can spend a weeks or even and month to solve this stupis security
issue. Why MySQL need have more security than FTP programs?( that works
just fine) Any ftp works wl

Plenty users can no access it own MySQL database installed even on it
own computer. Stupid system generate errors #1045 - Access denied. So
called ''securiy settings issue'' is just paranoidal. Why not set access
to phpmyadmin/mySQL from ANY IPs by default?

Have you real ideas how to repair this ''error #1045 - Access denied for
user'' remotely on virtual host? I doubt that you have any idea.


这篇关于无法连接到mySQL数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆