access for user root@localhost using password: yes
时间:2011-11-15
来源:互联网
怎么回事? 命令行 输入"\Program Files\EasyPHP 3.0\mysql\bin\mysql" -u root
提示 error 1045 <28000> access for user root@localhost using password: yes
我该如何输入密码?
这样输入错误还是一样:"\Program Files\EasyPHP 3.0\mysql\bin\mysql" -u root YES
谢谢
提示 error 1045 <28000> access for user root@localhost using password: yes
我该如何输入密码?
这样输入错误还是一样:"\Program Files\EasyPHP 3.0\mysql\bin\mysql" -u root YES
谢谢
作者: superwavelet 发布时间: 2011-11-15
官方解释为:
Only the root user (without password) has the rights to connect to the database. Either modify your scripts to use it, or add the user you need (phpMyAdmin/users and privileges: See phpMyAdmin's documentation for more information).
When you are using a port on your localhost, which you redirect via port-forwarding to another host, MySQL is not resolving the localhost as expected.
Erik Wasser explains: The solution is: if your host is "localhost" MySQL (the command line tool mysql as well) always tries to use the socket connection for speeding up things. And that doesn't work in this configuration with port forwarding.
If you enter "127.0.0.1" as hostname, everything is right and MySQL uses the TCP connection.
我的主页是:http://127.0.0.1:8080/
我难道不是root user?
Only the root user (without password) has the rights to connect to the database. Either modify your scripts to use it, or add the user you need (phpMyAdmin/users and privileges: See phpMyAdmin's documentation for more information).
When you are using a port on your localhost, which you redirect via port-forwarding to another host, MySQL is not resolving the localhost as expected.
Erik Wasser explains: The solution is: if your host is "localhost" MySQL (the command line tool mysql as well) always tries to use the socket connection for speeding up things. And that doesn't work in this configuration with port forwarding.
If you enter "127.0.0.1" as hostname, everything is right and MySQL uses the TCP connection.
我的主页是:http://127.0.0.1:8080/
我难道不是root user?
作者: superwavelet 发布时间: 2011-11-16
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28