blocks|key|542022|text|转到文件C:\wamp\apps\phpmyadmin3.2.0.1\config.inc.php|type|unstyled|depth|inlineStyleRanges|entityRanges|data|542023|找到$cfg‘’Servers‘’password‘=’‘行，并将其更改为|542024|$cfg['Servers'][$i]['password']='root'|code-block|syntax|javascript|542025|其中root是您在此实例中设置的密码的名称|offset|length|style|CODE|542026|希望这对某些人有帮助。|542027|entityMap^0|0|0|0|2|4|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|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@$K|W|L|X|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Go to the file C:\wamp\apps\phpmyadmin3.2.0.1\config.inc.php 

Find the line $cfg['Servers'][$i]['password']='' and change it to

<pre><code>$cfg['Servers'][$i]['password']='root'
</code></pre>

where <code>root</code> is the name of the password you had set in this instance

Hope this helps somebody.

blocks|key|324710|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|324711|1.+xampp/htdocs/xampp/cds.php

change+line+4+to:+mysql_connect("localhost","root","enter+password+here");
change+line+64+to:+if(!mysql_connect("localhost","root","enter+password+here"))|code-block|syntax|javascript|324712|From+here|offset|length|324713|entityMap|0|LINK|mutability|MUTABLE|url|http://www.apachefriends.org/f/viewtopic.php?p=152284^0|0|0|0|9|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

Try this:

<pre><code>1. xampp/htdocs/xampp/cds.php

change line 4 to: mysql_connect("localhost","root","enter password here");
change line 64 to: if(!mysql_connect("localhost","root","enter password here"))
</code></pre>

<a href="http://www.apachefriends.org/f/viewtopic.php?p=152284" rel="nofollow">From here</a>

blocks|key|541846|text|在xampp安全页面重置您的mysql密码。重新启动mysql服务，然后使用密码访问phpmyadmin页面。我试过了。这对我来说工作得很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|541847|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

reset your mysql password on xampp security page.
restart your mysql service and then access the phpmyadmin page using your password. i tried it. this is working fine for me.

blocks|key|542467|text|我在本文中使用的是Linux+Mint+18.2。我遇到了类似的问题；当我试图加载myphpadmin时，它显示："1045+-用户'root'@'localhost‘(使用密码:NO)的访问被拒绝“|type|unstyled|depth|inlineStyleRanges|entityRanges|data|542468|我在/opt/lampp/phpmyadmin+directory里找到了那个文件。我用文本编辑器打开了config.inc.php文件，并输入了正确的密码。已保存，并已成功启动。利润！|offset|length|style|CODE|542469|我在修改文件夹和文件时遇到了问题，我必须更改访问/opt/lampp/目录中所有文件的权限。我希望这对将来的某个人有所帮助。|542470|entityMap^0|0|2|V|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

I'm using Linux Mint 18.2 of this writing. I had a similar issue; when trying to load myphpadmin, it said: "1045 - Access denied for user 'root'@'localhost' (using password: NO)" 

I found the file in the <code>/opt/lampp/phpmyadmin directory</code>. I opened the config.inc.php file with my text editor and typed in the correct password. Saved it, and launched it successfully. Profit!

I was having problems with modifying folders and files, I had to change permission to access all my files in /opt/lampp/ directory. I hope this helps someone in the future.

blocks|key|324723|text|恐怕与端口号(80)有冲突。确保你没有运行像Skype这样的软件，它们使用相同的端口80|type|unstyled|depth|inlineStyleRanges|entityRanges|data|324724|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I'm afraid there's a conflict with the port number(80). Make sure you don't run some software like Skype that use the same port 80

blocks|key|541786|text|文件#password和#bind-address="127.0.0.1"中的根已注释，将密码更改为My.ini并取消注释bind-address="127.0.0.1"，并从文件cds.php中更改|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|541787|mysql_connect("localhost",+"root",+"");+to
mysql_connect("localhost",+"root",+"root");|code-block|syntax|javascript|541788|停止Mysql服务，然后重新尝试登录，因为已登录。|541789|entityMap^0|2|9|C|P|1E|6|1P|O|2I|7|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|N|$]]

<code>My.ini</code> from the file <code>#password</code> and <code>#bind-address="127.0.0.1"</code> are commented change the password to root and uncomment <code>bind-address="127.0.0.1"</code> and from the file <code>cds.php</code> change the 

<pre><code>mysql_connect("localhost", "root", ""); to
mysql_connect("localhost", "root", "root");
</code></pre>

Stop the Mysql services and try login again it got logged in.

blocks|key|325252|text|1045+-拒绝访问用户'root'@'localhost‘(使用密码:+NO)解决方案:步骤1:打开您的wamp/xamp第2步:转到phpmyadmin步骤3:打开config.inc.php步骤4:将密码更改为为MySql服务器设置的密码，而不是其中的任何其他内容：$cfg’‘Servers+'’password‘=’‘第5步:重新启动所有服务/restart+wamp/xampp。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|325253|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

1045 - Access denied for user 'root'@'localhost' (using password: NO)
solution: 
Step 1: Open Location of you wamp/xampp 
Step 2: Go to phpmyadmin
Step 3: Open config.inc.php
Step 4: Change the password to the password set for the MySql server and not anything else in this: $cfg['Servers'][$i]['password'] = ''
Step 5: Restart all services /restart wamp/xampp.

blocks|key|325405|text|尝试重置您的密码，因为它似乎已更改。您可以转到|type|unstyled|depth|inlineStyleRanges|entityRanges|data|325406|C:\xampp\mysql|code-block|syntax|javascript|325407|然后单击resetroot.bat文件|325408|然后在php配置文件中将密码改回空白，您应该可以再次访问。|325409|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Try resetting your password since it seems it has changed you can reset your password by going to

<pre><code>C:\xampp\mysql
</code></pre>

and clicking on the resetroot.bat file

Then change in the php config file the password back to blank and you should have access again

blocks|key|324921|text|在我从MySQL中删除特殊的PhpMyAdmin控制用户帐户后，我也遇到了同样的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|324922|我必须更新config.inc.php文件，并将“控制用户”和“控制通过”的条目替换为“用户”和“密码”。|324923|所以我的文件是这样结束的：|324924|$cfg‘’Servers‘’user‘=+'root'；$cfg’‘Servers’‘password’=‘123456’；|324925|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I had this same problem after I dropped the special PhpMyAdmin controluser account from MySQL.

I had to update the config.inc.php file and replace the entries for 'controluser' and controlpass' with 'user' and 'password'.

So my file ended like this:

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password']='123456';

blocks|key|325161|text|如果您使用的是XAMPP而不是WAMP，则转到的路径为：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|325162|C:\xampp\phpMyAdmin\config.inc.php|code-block|syntax|javascript|325163|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|$]]

If you are using XAMPP rather than WAMP, the path you go to is:

<pre><code>C:\xampp\phpMyAdmin\config.inc.php
</code></pre>

blocks|key|325337|text|在OSX上，我遇到了同样的困难，但我想出了一个答案|type|unstyled|depth|inlineStyleRanges|entityRanges|data|325338|开放终端|325339|put+'cd+/Applications/XAMPP/xamppfiles'
put+'sudo+./xampp+security'|code-block|syntax|javascript|325340|然后输入您的root密码并回答以下问题|325341|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

On OSX 
I had same difficult, but a figure out a solucition

open terminal

<pre><code>put 'cd /Applications/XAMPP/xamppfiles'
put 'sudo ./xampp security'
</code></pre>

then put your root password and answer the questions

I installed xampp,but when I tried to run it I got an error as thus:
Error
MySQL said: Documentation
<h1>1045 - Access denied for user 'root'@'localhost' (using password: NO)</h1>
Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
I tried to search on internet for a solution, but I still can't fix my problem. I have already checked whether I used a password or not in <code>config.inc.php</code> file but i have not used any password.Also, when i try to access with a password, I still can't solve this problem.
I hope anyone can help me. .thank you

MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: NO)

Linux Mint

服务器

MySQL

Linux

我安装了xampp，但当我尝试运行它时，我得到了一个错误，如下所示：错误MySQL说:文档1045 -拒绝访问用户'root'@'localhost‘(使用密码: NO)按照配置中定义的方式连接controluser失败。phpMyAdmin尝试连接到MySQL服务器，但服务器拒绝了该连接。您应该检查配置中的主机、用户名和密码，并确保它们与MySQL服务器管理员提供的信息相对应。我试着在网上搜索解

问MySQL说:文档#1045 -拒绝用户'root'@'localhost‘的访问(使用密码: NO)
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL说:文档#1045 -拒绝用户'root'@'localhost‘的访问(使用密码: NO)EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL说:文档#1045 -拒绝用户'root'@'localhost‘的访问(使用密码: NO)
EN