在 MySQL 工作台中,连接的用户名/密码是什么?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/3983064/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
In MySQL workbench what is username/password for connection?
提问by agezna
I'm new to MySQL. I'm doing the tutorial and trying to create a connection. I need to have a username and password. I get an error each time saying it can't connect to username@localhost using password YES . I'm just trying to set this up locally.
我是 MySQL 的新手。我正在做教程并尝试创建连接。我需要一个用户名和密码。每次说它无法使用密码 YES 连接到 username@localhost 时,我都会收到一条错误消息。我只是想在本地设置它。
What is the username and password supposed to be? How is the account created, where can I find it, etc. I am using Windows.
用户名和密码应该是什么?帐户是如何创建的,我在哪里可以找到它等。我使用的是 Windows。
Thanks,
谢谢,
回答by Brad
You are being prompted for a username and password for your MySQL server. If this is a fresh server installation, as others have said, the username root with a blank password should get you in initially. If this doesn't work you can always reset the root password if you have shell access. There are instructions here:
系统会提示您输入 MySQL 服务器的用户名和密码。如果这是一个全新的服务器安装,正如其他人所说,用户名 root 和一个空白密码应该会让你一开始就进入。如果这不起作用,如果您有 shell 访问权限,您可以随时重置 root 密码。这里有说明:
http://www.cyberciti.biz/tips/recover-mysql-root-password.html
http://www.cyberciti.biz/tips/recover-mysql-root-password.html
回答by Fábio Antunes
Good day Agezna
美好的一天阿格兹纳
In MySql Workbench the username and password are the username and password of you MySql Server user. But once you don't know those as well.
在 MySql Workbench 中,用户名和密码是您的 MySql Server 用户的用户名和密码。但是一旦你不知道这些。
Have you installed MySql Server alone from MySql website?
您是否从 MySql 网站单独安装了 MySql Server?
Or MySql Server was included in some web server applications bundle like:
或者 MySql Server 包含在一些 Web 服务器应用程序包中,例如:
- Xampp. Default username is
rootand there is no password set. - Wampp. Default username is
rootand there is no password set. - other one? Try the same for Xampp if it doesn't work, specify the bundle name then i can help you.
- 赞普。默认用户名是
root,没有设置密码。 - 万普。默认用户名是
root,没有设置密码。 - 另一个?如果 Xampp 不起作用,请尝试相同的方法,指定包名称,然后我可以为您提供帮助。
If you installed MySql Server alone, the password was set at installation, if you need to change it, there is a executable in your MySql Server folder in your Start Menu in Windows where you can change the configuration of you server, including your default password.
如果您单独安装了 MySql Server,密码是在安装时设置的,如果您需要更改它,在 Windows 的开始菜单中的 MySql Server 文件夹中有一个可执行文件,您可以在其中更改服务器的配置,包括您的默认密码.
Regards.
问候。
回答by Phil
When you installed, did you set a root password? If so, use username "root" and the password you set. If not, leave "password" empty.
安装的时候有没有设置root密码?如果是这样,请使用用户名“root”和您设置的密码。如果没有,请将“密码”留空。

