blocks|key|3299232|text|也许吧|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3299233|E:\mysql-5.1.39-win32\bin>mysql+-u+root+-p|code-block|syntax|javascript|3299234|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

maybe 

<pre><code>E:\mysql-5.1.39-win32\bin&gt;mysql -u root -p
</code></pre>

blocks|key|3086155|text|您需要先运行服务器。您使用的命令(在问题中)启动一个客户端以连接到服务器，但是服务器不在那里，所以出现了错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3086156|由于我不是一个视窗用户(配备了Linux)，所以我可能不是最好的人来告诉你如何，但我可以指给你一个guide和另一个guide，向你展示如何在视窗中安装和运行MySQL服务器。|offset|length|3086157|运行之后，您可以使用命令(在问题中)来连接它。|3086158|注意:如果您计划使用MySQL进行web数据库开发，也可以尝试使用http://www.apachefriends.org/en/xampp.html。|3086159|希望这能有所帮助。|3086160|entityMap|0|LINK|mutability|MUTABLE|url|http://www.devside.net/guides/windows/mysql|1|http://dev.mysql.com/tech-resources/articles/4.1/installer.html|2|http://www.apachefriends.org/en/xampp.html^0|0|1D|5|0|1M|5|1|0|0|X|16|2|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Y|8|@]|9|@$D|Z|E|10|1|11]|$D|12|E|13|1|14]]|A|$]]|$1|F|3|G|5|6|7|15|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|16|8|@]|9|@$D|17|E|18|1|19]]|A|$]]|$1|J|3|K|5|6|7|1A|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]|T|$5|O|P|Q|A|$R|U]]|V|$5|O|P|Q|A|$R|W]]]]

You need to run the server first. The command you use (in the question) starts a client to connect to the server but the server is not there so there the error.

Since I am not a Windows user (Linux comes equipped) so I might not be the best person to tell you how but I can point to you to a <a href="http://www.devside.net/guides/windows/mysql" rel="nofollow noreferrer">guide</a> and another <a href="http://dev.mysql.com/tech-resources/articles/4.1/installer.html" rel="nofollow noreferrer">guide</a> that show you how to get MySQL server up and running in Windows.

After you get that running, you can use the command (in the question) to connect it.

NOTE: You may also try <a href="http://www.apachefriends.org/en/xampp.html" rel="nofollow noreferrer">http://www.apachefriends.org/en/xampp.html</a> if you plan to use MySQL for web database development.

Hope this helps.

blocks|key|328615|text|您还需要配置和启动MySQL服务器。This+will+probably+help|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|328616|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.1/en/windows-install-archive.html^0|I|N|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You also need to configure and start the MySQL server. <a href="http://dev.mysql.com/doc/refman/5.1/en/windows-install-archive.html" rel="nofollow noreferrer">This will probably help</a>

blocks|key|327044|text|该错误抱怨的是localhost而不是权限，MySQL中的当前做法是让绑定地址在配置文件中指定localhost+only。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|BOLD|entityRanges|data|327045|所以我不认为这是一个密码问题--除非你说你‘解压’了MySQL。|327046|这样的安装足够了吗？你下载了什么？|327047|是否有任何安装步骤允许您定义root密码？|327048|而且，正如NawaMan所说，服务器正在运行吗？|327049|entityMap^0|7|9|1B|9|1L|4|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|D]]|E|@]|F|$]]|$1|G|3|H|5|6|7|X|8|@]|E|@]|F|$]]|$1|I|3|J|5|6|7|Y|8|@]|E|@]|F|$]]|$1|K|3|L|5|6|7|Z|8|@]|E|@]|F|$]]|$1|M|3|N|5|6|7|10|8|@]|E|@]|F|$]]|$1|O|3|-4|5|6|7|11|8|@]|E|@]|F|$]]]|P|$]]

The error complains about <code>localhost</code> rather than permissions and the current practice in MySQL is to have a bind-address specifying <code>localhost</code> only in a configuration file.

So I don't think it's a password problem - except that you say you 'unzipped' MySQL.

Is that enough installation? What did you download? 

Was there any installation step which allowed you to define a root password?

And, as NawaMan said, is the server running?

blocks|key|3299460|text|您需要做的第一件事是启动mysql，以便您可以使用E:\mysql-5.1.39-win32\bin>net+start+mysql+(只有当mysql作为服务运行时)，然后才能执行E:\mysql-5.1.39-win32\bin>mysql+-u+root。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3299461|entityMap^0|P|15|2J|13|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

first thing you need to do is to start the mysql
for that you can use
<code>E:\mysql-5.1.39-win32\bin&gt;net start mysql</code> (only when there a mysql running as service)
then you can execute
<code>E:\mysql-5.1.39-win32\bin&gt;mysql -u root</code>

blocks|key|3086278|text|类型|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3086279|C:\>+"C:\Program+Files\MySQL\MySQL+Server+5.1\bin\mysqld"+--console|code-block|syntax|javascript|3086280|启动sql服务器，然后测试客户端连接。|3086281|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Type

<pre><code>C:\&gt; "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --console
</code></pre>

to start the sql server and then test the client connection.

blocks|key|3086390|text|可以从命令行手动启动MySQL服务器。这可以在任何版本的Windows上完成。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3086391|要从命令行启动mysqld服务器，您应该启动一个控制台窗口(或“DOS窗口”)并输入以下命令：|3086392|shell>+"C:\Program+Files\MySQL\MySQL+Server+5.0\bin\mysqld"
The+path+to+mysqld+may+vary+depending+on+the+install+location+of+MySQL+on+your+system.|code-block|syntax|javascript|3086393|您可以通过执行以下命令停止MySQL服务器：|3086394|shell>+"C:\Program+Files\MySQL\MySQL+Server+5.0\bin\mysqladmin"+-u+root+shutdown|3086395|**注意：**|3086396|如果mysqladmin用户帐户有密码，则需要使用-p选项调用MySQL，并在出现提示时提供密码。|3086397|这个命令调用MySQL管理实用程序mysqladmin来连接到服务器并告诉它关闭。该命令以MySQL根用户身份连接，该用户是MySQL授权系统中的默认管理帐户。请注意，MySQL授权系统中的用户完全独立于任何登录用户。|3086398|如果mysqld没有启动，请检查错误日志，查看服务器是否在其中写入了任何消息，以指明问题的原因。错误日志位于C:\Program+Files\MySQL\MySQL+Server+5.0\data目录中。它是后缀为.err的文件。您还可以尝试以mysqld+--console启动服务器；在这种情况下，您可能会在屏幕上获得一些有用的信息，这些信息可能有助于解决问题。|3086399|最后一个选项是使用--standalone和--debug选项启动mysqld。在这种情况下，mysqld会写入一个日志文件C:\mysqld.trace，其中应该包含mysqld无法启动的原因。请参阅MySQL内部:移植到其他系统。|3086400|通过MySQL+Official+Page|offset|length|3086401|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/windows-start-command-line.html^0|0|0|0|0|0|0|0|0|0|0|2|J|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|19|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1A|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|1B|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|1C|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|1D|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1E|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1F|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1G|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1H|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1I|8|@]|9|@$Y|1J|Z|1K|1|1L]]|A|$]]|$1|10|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|17]]]]

The MySQL server can be started manually from the command line. This can be done on any version of Windows.

To start the mysqld server from the command line, you should start a console window (or “DOS window”) and enter this command:

<pre><code>shell&gt; "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld"
The path to mysqld may vary depending on the install location of MySQL on your system.
</code></pre>

You can stop the MySQL server by executing this command:

<pre><code>shell&gt; "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqladmin" -u root shutdown
</code></pre>

**Note : **

If the MySQL root user account has a password, you need to invoke mysqladmin with the -p option and supply the password when prompted.

This command invokes the MySQL administrative utility mysqladmin to connect to the server and tell it to shut down. The command connects as the MySQL root user, which is the default administrative account in the MySQL grant system. Note that users in the MySQL grant system are wholly independent from any login users under Windows.

If mysqld doesn't start, check the error log to see whether the server wrote any messages there to indicate the cause of the problem. The error log is located in the C:\Program Files\MySQL\MySQL Server 5.0\data directory. It is the file with a suffix of .err. You can also try to start the server as mysqld --console; in this case, you may get some useful information on the screen that may help solve the problem.

The last option is to start mysqld with the --standalone and --debug options. In this case, mysqld writes a log file C:\mysqld.trace that should contain the reason why mysqld doesn't start. See MySQL Internals: Porting to Other Systems.

Via <a href="http://dev.mysql.com/doc/refman/5.0/en/windows-start-command-line.html" rel="noreferrer">MySQL Official Page</a>

blocks|key|3086497|text|将命令提示符|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3086498|Run为administrator.#|unordered-list-item|offset|length|style|BOLD|3086499|3086500|我们可以使用下面的命令从windows命令行启动MySQL服务。|3086501|3086502|net+start+mysql|CODE|3086503|3086504|用于停止MySql服务的命令：|3086505|3086506|net+stop+mysql|3086507|3086508|禁用MySql服务：|3086509|3086510|sc+config+mysql+start=+disabled|3086511|3086512|启用MySql服务的命令(系统启动时自动启动MySQL服务)：|3086513|3086514|sc+config+mysql+start=+auto|3086515|3086516|命令将启动类型设置为手动：|3086517|3086518|sc+config+mysql+start=+manual|3086519|3086520|如何重启MySql服务？没有用于重新启动服务的直接命令。您可以像下面这样组合停止和启动命令。|3086521|3086522|net+stop+mysql+&+net+start+mysql|3086523|3086524|entityMap^0|0|0|I|0|0|0|0|0|F|0|F|0|0|0|0|0|E|0|E|0|0|0|0|0|V|0|V|0|0|0|0|0|R|0|R|0|0|0|0|0|T|0|T|0|0|0|0|0|W|0|W|0|0^^$0|@$1|2|3|4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1N|8|@$E|1O|F|1P|G|H]]|9|@]|A|$]]|$1|I|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1R|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|1T|8|@$E|1U|F|1V|G|H]|$E|1W|F|1X|G|O]]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|20|8|@]|9|@]|A|$]]|$1|T|3|U|5|D|7|21|8|@$E|22|F|23|G|H]|$E|24|F|25|G|O]]|9|@]|A|$]]|$1|V|3|-4|5|6|7|26|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|27|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|28|8|@]|9|@]|A|$]]|$1|Z|3|10|5|D|7|29|8|@$E|2A|F|2B|G|H]|$E|2C|F|2D|G|O]]|9|@]|A|$]]|$1|11|3|-4|5|6|7|2E|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|2F|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|2G|8|@]|9|@]|A|$]]|$1|15|3|16|5|D|7|2H|8|@$E|2I|F|2J|G|H]|$E|2K|F|2L|G|O]]|9|@]|A|$]]|$1|17|3|-4|5|6|7|2M|8|@]|9|@]|A|$]]|$1|18|3|19|5|6|7|2N|8|@]|9|@]|A|$]]|$1|1A|3|-4|5|6|7|2O|8|@]|9|@]|A|$]]|$1|1B|3|1C|5|D|7|2P|8|@$E|2Q|F|2R|G|H]|$E|2S|F|2T|G|O]]|9|@]|A|$]]|$1|1D|3|-4|5|6|7|2U|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|6|7|2V|8|@]|9|@]|A|$]]|$1|1G|3|-4|5|6|7|2W|8|@]|9|@]|A|$]]|$1|1H|3|1I|5|D|7|2X|8|@$E|2Y|F|2Z|G|H]|$E|30|F|31|G|O]]|9|@]|A|$]]|$1|1J|3|-4|5|6|7|32|8|@]|9|@]|A|$]]|$1|1K|3|-4|5|6|7|33|8|@]|9|@]|A|$]]]|1L|$]]

<ul>
<li>Run your command prompt as administrator.#</li>
</ul>

We can start MySQL service from windows command line using the below command.

<ul>
<li><code>net start mysql</code></li>
</ul>

Command to stop MySql service:

<ul>
<li><code>net stop mysql</code></li>
</ul>

Disable MySql service:

<ul>
<li><code>sc config mysql start= disabled</code></li>
</ul>

Command to enable MySql service(to automatically start MySQL service when the system starts up):

<ul>
<li><code>sc config mysql start= auto</code></li>
</ul>

Command to set the startup type to manual:

<ul>
<li><code>sc config mysql start= manual</code></li>
</ul>

How to restart MySql service?
There is no direct command to restart a service. You can combine stop and start commands like below.

<ul>
<li><code>net stop mysql &amp; net start mysql</code></li>
</ul>

blocks|key|3299696|text|通过命令提示符启动mysql服务器|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3299697|C:>+"C:\Program+Files\MySQL\MySQL+Server5.5\bin\mysqld“--控制台|3299698|或者可选择地伸手到垃圾箱|3299699|mysqld+--控制台|3299700|它将启动您的服务器。|3299701|如果您有可用的mysql命令行客户端|3299702|点击它|3299703|它会显示输入您的密码：|3299704|请输入您的密码。|3299705|然后你就可以访问它了。|3299706|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|10|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|11|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|12|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|13|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|14|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|U|$]]

Start mysql server by command prompt

C:> "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --console

Or alternative reach up to bin then 

mysqld --console

It will start your server.

If you have mysql command line client available

click on it

it show enter your password : 

Please enter your password.

Then you can access it.

blocks|key|327178|text|​|type|unstyled|depth|inlineStyleRanges|entityRanges|data|327179|📷|atomic|offset|length|327180|我在启动MySql服务器时也遇到了问题，但运行图片中提到的正确标记的命令。它工作得很好。|327181|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/42329787e3ae82df22fbfe5ba9213ac6.jpeg|imageAlt^0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|S|8|@]|9|@$E|T|F|U|1|V]]|A|$]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P|Q|-4]]]]

<img src="https://i.stack.imgur.com/EtnXm.jpg" alt="probably this will help you">
I was also having problem with starting MySql server but run command as mention right mark in picture . Its working fine .

blocks|key|3299748|text|我尝试了以下步骤，在我的windows8上运行mysql+server+5.6。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3299749|3299750|作为administrator|ordered-list-item|3299751|go+mysql+Server+5.6安装目录运行命令提示符(在我的示例中为:+C:\Program+Files+(x86)\MySQL\MySQL+Server5.6\bin)将位置|3299752|复制到命令提示符中运行"cd+C:\Program+Files+(x86)\MySQL\MySQL+Server5.6\bin“|3299753|+run+"mysql+-u+|3299754|”|3299755|3299756|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|R|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|T|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|U|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|V|8|@]|9|@]|A|$]]|$1|L|3|M|5|E|7|W|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

I tried following steps to run mysql server 5.6 on my windows 8.

<ol>
<li>Run command prompt as an administrator</li>
<li>go mysql server 5.6 installation directory (in my case: C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin) copy that location</li>
<li>In Command prompt run "cd C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin"</li>
<li>run "mysql -u root"</li>
</ol>

blocks|key|328786|text|下面是我下载的ZIP文件:+mysql-5.7.15-winx64.zip|type|unstyled|depth|inlineStyleRanges|entityRanges|data|328787|以下是在Windows上首次启动MYSQL+Server+(mysql-5.7.15-winx64)的步骤：|328788|328789|在MYSQL安装目录下新建一个名为data的文件夹(即与bin目录的位置相同)。对我来说是:+C:\programs\mysql-5.7.15-winx64\mysql-5.7.15-winx64.这个位置将根据您解压MYSQL压缩文件的位置而有所不同)|ordered-list-item|328790|从这里我将使用我的MYSQL文件夹位置作为参考。转到:+C:\programs\mysql-5.7.15-winx64\mysql-5.7.15-winx64\bin并执行命令：mysqld+--initialize-insecure或mysqld+--initialize，具体取决于您是否希望服务器为‘C:\programs\mysql-5.7.15-winx64\mysql-5.7.15-winx64\bin’@‘localhost’帐户生成一个随机的初始密码。要启动数据库，请转到：mysqld+--initialize-insecure并执行mysqld+--console您可以看到正在打印启动日志。|offset|length|style|CODE|328791|要连接到数据库，转到:+C:\programs\mysql-5.7.15-winx64\mysql-5.7.15-winx64\bin并执行mysql+-u+root+-p。出现提示时，如果已设置密码，请输入密码，否则只需点击"+Enter“按钮即可连接|328792|328793|entityMap^0|0|0|0|0|2H|S|3A|J|6U|S|7P|G|0|1Y|G|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|V|8|@]|9|@]|A|$]]|$1|H|3|I|5|G|7|W|8|@$J|X|K|Y|L|M]|$J|Z|K|10|L|M]|$J|11|K|12|L|M]|$J|13|K|14|L|M]]|9|@]|A|$]]|$1|N|3|O|5|G|7|15|8|@$J|16|K|17|L|M]]|9|@]|A|$]]|$1|P|3|-4|5|6|7|18|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|R|$]]

Here is the ZIP file that I had downloaded: mysql-5.7.15-winx64.zip

Here are the steps to start MYSQL Server (mysql-5.7.15-winx64) for the first time on Windows:

<ol>
<li>Create a new folder named "data" in MYSQL installation directory (i.e. in the same location as where "bin" directory is located. For me it is: C:\programs\mysql-5.7.15-winx64\mysql-5.7.15-winx64. This location will vary as per the location where you have extracted the MYSQL zip file)</li>
<li>From here I will use my MYSQL folder location as reference. Go to: C:\programs\mysql-5.7.15-winx64\mysql-5.7.15-winx64\bin and execute the command: <code>mysqld --initialize-insecure</code> or <code>mysqld --initialize</code> depending on whether you want the server to generate a random initial password for the 'root'@'localhost' account.</li>
<li>To start the DB, go to: C:\programs\mysql-5.7.15-winx64\mysql-5.7.15-winx64\bin and execute <code>mysqld --console</code> You can see the start-up logs being printed.</li>
<li>To connect to DB, go to: C:\programs\mysql-5.7.15-winx64\mysql-5.7.15-winx64\bin and execute <code>mysql -u root -p</code>. When prompted, Enter password if it has been set or else just hit "Enter" button to connect</li>
</ol>

blocks|key|3299784|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3299785|以admin和cd身份运行命令提示符，进入MySQL的bin目录|ordered-list-item|3299786|3299787|通常是(C:\Program+Files\MySQL\mysql-5.6.36-winx64\bin)|3299788|安装运行命令:+mysqld+--|3299789|。(此命令将安装MySQL服务，如果已安装服务，则会提示。)|3299790|3299791|3299792|运行以下命令来启动和停止服务器|3299793|3299794|开始：net+start+mysql|offset|length|style|BOLD|3299795|要停止：net+stop+mysql|3299796|3299797|运行mysql命令。|3299798|3299799|3299800|享受!!|3299801|3299802|entityMap^0|0|0|0|0|0|0|0|0|0|0|3|F|0|4|E|0|0|2|5|0|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|17|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|18|7|@]|8|@]|9|$]]|$1|D|3|-4|4|5|6|19|7|@]|8|@]|9|$]]|$1|E|3|F|4|5|6|1A|7|@]|8|@]|9|$]]|$1|G|3|H|4|5|6|1B|7|@]|8|@]|9|$]]|$1|I|3|J|4|C|6|1C|7|@]|8|@]|9|$]]|$1|K|3|-4|4|5|6|1D|7|@]|8|@]|9|$]]|$1|L|3|-4|4|5|6|1E|7|@]|8|@]|9|$]]|$1|M|3|N|4|C|6|1F|7|@]|8|@]|9|$]]|$1|O|3|-4|4|5|6|1G|7|@]|8|@]|9|$]]|$1|P|3|Q|4|5|6|1H|7|@$R|1I|S|1J|T|U]]|8|@]|9|$]]|$1|V|3|W|4|5|6|1K|7|@$R|1L|S|1M|T|U]]|8|@]|9|$]]|$1|X|3|-4|4|5|6|1N|7|@]|8|@]|9|$]]|$1|Y|3|Z|4|C|6|1O|7|@$R|1P|S|1Q|T|U]]|8|@]|9|$]]|$1|10|3|-4|4|5|6|1R|7|@]|8|@]|9|$]]|$1|11|3|-4|4|5|6|1S|7|@]|8|@]|9|$]]|$1|12|3|13|4|C|6|1T|7|@]|8|@]|9|$]]|$1|14|3|-4|4|5|6|1U|7|@]|8|@]|9|$]]|$1|15|3|-4|4|5|6|1V|7|@]|8|@]|9|$]]]|16|$]]

<ol>
<li>Run the command prompt as admin and cd to bin directory of MySQL
<pre><code>Generally it is (C:\Program Files\MySQL\mysql-5.6.36-winx64\bin)
</code></pre>
</li>
<li>Run command : mysqld --install. (This command will install MySQL services and if services already installed it will prompt.)
</li>
<li>Run below commands to start and stop server
To start : net start mysql
To stop : net stop mysql
</li>
<li>Run mysql command.
</li>
<li>Enjoy !!
</li>
</ol>

blocks|key|327212|text|mysql+-u+root+-p|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|327213|在终端中输入此命令后，它会要求输入密码，然后您就可以开始使用了！|unstyled|327214|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>mysql -u root -p
</code></pre>

After entering this command in terminal, it will ask for password
Enter the password and you are ready to go!

blocks|key|332142|text|我使用的是MySQL+Server5.5，因此我错过了大多数答案提到的bin文件夹中的文件夹。相反，我所做的是：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|332143|332144|打开资源管理器，转到C:\Program+Files\MySQL\MySQL+Server+5.5\bin或MySQL安装目录。|ordered-list-item|332145|运行可执行应用程序MySQLInstanceConfig，然后按照下图操作。|332146|332147|​|332148|📷|atomic|332149|332150|332151|332152|332153|332154|332155|332156|332157|332158|332159|332160|332161|332162|332163|332164|332165|332166|332167|332168|这解决了我的问题，我能够毫无错误地访问数据库。|332169|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/0b76e3b0459dc25d80c4e6bad4212d87.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/68f15688ce6b34747b4387aa9fff841d.png|2|https://ask.qcloudimg.com/http-save/yehe-900000/13c704555b9a5b67e61c812eb9664c19.png|3|https://ask.qcloudimg.com/http-save/yehe-900000/6c32eee96d66c3e7054539acffad48af.png|4|https://ask.qcloudimg.com/http-save/yehe-900000/ecc67ee7b69990356e644aaea9e94e3c.png|5|https://ask.qcloudimg.com/http-save/yehe-900000/e8b50d2e411963262f5a0a8f8308c14a.png|6|https://ask.qcloudimg.com/http-save/yehe-900000/b7471dd921eb9617cbf0dda4bbbbd7b6.png^0|Z|3|0|0|A|17|0|9|J|0|0|0|0|1|0|0|0|0|0|1|1|0|0|0|0|1|2|0|0|0|0|1|3|0|0|0|0|1|4|0|0|0|0|1|5|0|0|0|0|1|6|0|0|0^^$0|@$1|2|3|4|5|6|7|1X|8|@$9|1Y|A|1Z|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|20|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|21|8|@$9|22|A|23|B|C]]|D|@]|E|$]]|$1|J|3|K|5|I|7|24|8|@$9|25|A|26|B|C]]|D|@]|E|$]]|$1|L|3|-4|5|6|7|27|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|28|8|@]|D|@]|E|$]]|$1|O|3|P|5|Q|7|29|8|@]|D|@$9|2A|A|2B|1|2C]]|E|$]]|$1|R|3|N|5|6|7|2D|8|@]|D|@]|E|$]]|$1|S|3|N|5|6|7|2E|8|@]|D|@]|E|$]]|$1|T|3|P|5|Q|7|2F|8|@]|D|@$9|2G|A|2H|1|2I]]|E|$]]|$1|U|3|N|5|6|7|2J|8|@]|D|@]|E|$]]|$1|V|3|N|5|6|7|2K|8|@]|D|@]|E|$]]|$1|W|3|P|5|Q|7|2L|8|@]|D|@$9|2M|A|2N|1|2O]]|E|$]]|$1|X|3|N|5|6|7|2P|8|@]|D|@]|E|$]]|$1|Y|3|N|5|6|7|2Q|8|@]|D|@]|E|$]]|$1|Z|3|P|5|Q|7|2R|8|@]|D|@$9|2S|A|2T|1|2U]]|E|$]]|$1|10|3|N|5|6|7|2V|8|@]|D|@]|E|$]]|$1|11|3|N|5|6|7|2W|8|@]|D|@]|E|$]]|$1|12|3|P|5|Q|7|2X|8|@]|D|@$9|2Y|A|2Z|1|30]]|E|$]]|$1|13|3|N|5|6|7|31|8|@]|D|@]|E|$]]|$1|14|3|N|5|6|7|32|8|@]|D|@]|E|$]]|$1|15|3|P|5|Q|7|33|8|@]|D|@$9|34|A|35|1|36]]|E|$]]|$1|16|3|N|5|6|7|37|8|@]|D|@]|E|$]]|$1|17|3|N|5|6|7|38|8|@]|D|@]|E|$]]|$1|18|3|P|5|Q|7|39|8|@]|D|@$9|3A|A|3B|1|3C]]|E|$]]|$1|19|3|N|5|6|7|3D|8|@]|D|@]|E|$]]|$1|1A|3|1B|5|6|7|3E|8|@]|D|@]|E|$]]|$1|1C|3|-4|5|6|7|3F|8|@]|D|@]|E|$]]]|1D|$1E|$5|1F|1G|1H|E|$1I|1J|1K|-4]]|1L|$5|1F|1G|1H|E|$1I|1M|1K|-4]]|1N|$5|1F|1G|1H|E|$1I|1O|1K|-4]]|1P|$5|1F|1G|1H|E|$1I|1Q|1K|-4]]|1R|$5|1F|1G|1H|E|$1I|1S|1K|-4]]|1T|$5|1F|1G|1H|E|$1I|1U|1K|-4]]|1V|$5|1F|1G|1H|E|$1I|1W|1K|-4]]]]

I was using MySQL Server 5.5 as a result I was missing the folder which majority of the answers made mention of in the <code>bin</code> folder. What I did instead was the following:

<ol>
<li>Open Explorer and make your way to <code>C:\Program Files\MySQL\MySQL Server 5.5\bin</code> or your MySQL installation directory.</li>
<li>Run the executable application <code>MySQLInstanceConfig</code> and follow the images below.</li>
</ol>

<a href="https://i.stack.imgur.com/LmzUn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LmzUn.png" alt=""></a>

<a href="https://i.stack.imgur.com/AXoKu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AXoKu.png" alt=""></a>

<a href="https://i.stack.imgur.com/EBIze.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EBIze.png" alt=""></a>

<a href="https://i.stack.imgur.com/TyKpJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TyKpJ.png" alt=""></a>

<a href="https://i.stack.imgur.com/Jyh0F.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Jyh0F.png" alt=""></a>

<a href="https://i.gyazo.com/e06877a94134db0d5dad9f41310b5057.png" rel="nofollow noreferrer"><img src="https://i.gyazo.com/e06877a94134db0d5dad9f41310b5057.png" alt=""></a>

<a href="https://i.stack.imgur.com/h6J3h.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/h6J3h.png" alt=""></a>

This solved my issue and I was able to access the database without any errors.

blocks|key|328967|text|如果命令提示符在Windows中不起作用，请尝试以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|328968|1)在Windows中打开服务。|328969|2)然后检查Mysql的状态，如果发现状态为nothing或为空，则启动mysql服务。|328970|​|328971|📷|atomic|offset|length|328972|328973|3)然后查看mysql是否启动.If，然后尝试检查mysql是否正常工作。|328974|当cmd命令不起作用时，它已经对我起作用了。|328975|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/f2604a22a3b7b5df8c9d699629cbfc26.png|imageAlt^0|0|0|0|0|0|1|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|13|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|14|8|@]|9|@$K|15|L|16|1|17]]|A|$]]|$1|M|3|G|5|6|7|18|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|19|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1A|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y|Z|-4]]]]

If the command prompt does not work in Windows, try the following:

1) Open services in Windows.

2) Then check the status for Mysql and if you found status nothing or blank then start the mysql service.

<a href="https://i.stack.imgur.com/auhDZ.png" rel="noreferrer"><img src="https://i.stack.imgur.com/auhDZ.png" alt="MYSQL SERVICE STATUS ON Windows service manager "></a>

3) After then see whether the mysql is start or not .If it shows started then try to check mysql working.

It has worked for me when cmd commands were not working.

blocks|key|3087189|text|有一个最好的解决方案来解决这个问题，它将100%25地工作。因为我们知道服务器是一个进程，所以把它当做一个进程来处理，在windows中的任务管理器中查看服务的，在中查看任务管理器中的，在该服务中查看Mysql和MS80，并尝试通过单击它来手动启动它，然后说运行然后将需要一些时间。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|3087190|转到mysql工作台并单击start/shutdown，然后尝试刷新服务器状态选项中的服务器状态。它会加载的，就是这样。|3087191|entityMap^0|1V|5|23|3|28|A|2Q|5|2W|4|0|D|E|0^^$0|@$1|2|3|4|5|6|7|K|8|@$9|L|A|M|B|C]|$9|N|A|O|B|C]|$9|P|A|Q|B|C]|$9|R|A|S|B|D]|$9|T|A|U|B|D]]|E|@]|F|$]]|$1|G|3|H|5|6|7|V|8|@$9|W|A|X|B|D]]|E|@]|F|$]]|$1|I|3|-4|5|6|7|Y|8|@]|E|@]|F|$]]]|J|$]]

there is one of the best solution do resolve this problem and it is going to work 100%.
as we know that server is a process so treat it like a process go to the task manager
in windows and see for services in task manager in that service see for <code>Mysql</code> and <code>MS80</code> and try to start it manually by click on it and say run then will take some time.

<blockquote>
 go to your mysql workbench and click on <code>start/shutdown</code> then try to refresh the server status in server status option. it will load up thats it.
</blockquote>

blocks|key|3300325|text|在-u文件夹路径中使用命令"mysql+-u+root+-p“。并提供您之前设置的MY+SQL密码。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3300326|entityMap^0|E|G|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

use the command "mysql -u root -p" in the bin folder path.
and give the MY SQL password which you have set earlier.

blocks|key|330077|text|1.以管理员身份打开命令提示符。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|330078|2.转到程序文件中的MySQL+installed+bin目录。|330079|3.从windows资源管理器复制bin目录的位置。|330080|4.在命令提示符下键入cd+and+(粘贴位置)，然后按enter键。|330081|5.键入mysqld+--initialize|330082|6.从“窗口”菜单打开“服务”，并按名称对列表进行排序。|330083|7.右键单击Mysql，然后单击start。|330084|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|S|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

1.Open a command prompt as Administrator.
2.Go to MySQL installed bin directory in program files.
3.Copy the location of the bin directory from windows explorer.
4.In command prompt type cd and (paste the location) and do enter.
5.Type mysqld --initialize
6.Open services from the windows menu and sort the list by name.
7.Right-click Mysql and click start.

Whenever I try to start MySQL by typing

<pre><code>&gt; mysql -u root
</code></pre>

I get the error

<blockquote>
 ERROR 2003(HY000): Can't connect to MySQL server on 'localhost' (10061)
</blockquote>

How can I solve the problem above? I just downloaded MySQL and unzipped it in the E: drive. I have not done anything else. Do I have to make a connection first? If so, how can I do that?

How to start MySQL server on windows xp

日志文件

SQL Server

数据库

服务器

Windows

MySQL

Linux

每当我尝试通过输入以下命令来启动MySQL时> mysql -u root我得到了错误错误2003(HY000)：无法连接到'localhost‘上的MySQL服务器(10061)我如何解决上面的问题？我刚刚下载了MySQL并解压缩到了E:盘。我没有做任何其他的事情。我必须先转机吗？如果是这样，我如何做到这一点？

问如何在windows xp上启动MySQL服务器
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在windows xp上启动MySQL服务器EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在windows xp上启动MySQL服务器
EN