• <legend id='xYtKd'><style id='xYtKd'><dir id='xYtKd'><q id='xYtKd'></q></dir></style></legend>

    1. <small id='xYtKd'></small><noframes id='xYtKd'>

    2. <tfoot id='xYtKd'></tfoot>
    3. <i id='xYtKd'><tr id='xYtKd'><dt id='xYtKd'><q id='xYtKd'><span id='xYtKd'><b id='xYtKd'><form id='xYtKd'><ins id='xYtKd'></ins><ul id='xYtKd'></ul><sub id='xYtKd'></sub></form><legend id='xYtKd'></legend><bdo id='xYtKd'><pre id='xYtKd'><center id='xYtKd'></center></pre></bdo></b><th id='xYtKd'></th></span></q></dt></tr></i><div id='xYtKd'><tfoot id='xYtKd'></tfoot><dl id='xYtKd'><fieldset id='xYtKd'></fieldset></dl></div>

          <bdo id='xYtKd'></bdo><ul id='xYtKd'></ul>

        XAMPP PhpMyAdmin 错误 1045,“拒绝用户 'root'@'localhost

        时间:2023-06-22

          <bdo id='U6AAC'></bdo><ul id='U6AAC'></ul>

            1. <small id='U6AAC'></small><noframes id='U6AAC'>

              • <i id='U6AAC'><tr id='U6AAC'><dt id='U6AAC'><q id='U6AAC'><span id='U6AAC'><b id='U6AAC'><form id='U6AAC'><ins id='U6AAC'></ins><ul id='U6AAC'></ul><sub id='U6AAC'></sub></form><legend id='U6AAC'></legend><bdo id='U6AAC'><pre id='U6AAC'><center id='U6AAC'></center></pre></bdo></b><th id='U6AAC'></th></span></q></dt></tr></i><div id='U6AAC'><tfoot id='U6AAC'></tfoot><dl id='U6AAC'><fieldset id='U6AAC'></fieldset></dl></div>

                    <tbody id='U6AAC'></tbody>
                1. <legend id='U6AAC'><style id='U6AAC'><dir id='U6AAC'><q id='U6AAC'></q></dir></style></legend>
                  <tfoot id='U6AAC'></tfoot>
                  本文介绍了XAMPP PhpMyAdmin 错误 1045,“拒绝用户 'root'@'localhost' 的访问的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我看到这个问题已经被问过很多次了,但我没有找到解决我的问题的方法.在 config.inc.php

                  I see this question has been asked many times, but I don't find a solution for my problem. Tried all possible combinations in config.inc.php

                  $cfg['Servers'][$i]['auth_type'] = 'http';
                  $cfg['Servers'][$i]['user'] = 'root';
                  $cfg['Servers'][$i]['password'] = 'root';
                  $cfg['Servers'][$i]['extension'] = 'mysql';
                  $cfg['Servers'][$i]['AllowNoPassword'] = true;
                  $cfg['Lang'] = '';
                  
                  /* Bind to the localhost ipv4 address and tcp */
                  $cfg['Servers'][$i]['host'] = 'localhost';
                  $cfg['Servers'][$i]['connect_type'] = 'tcp';
                  
                  /* User for advanced features */
                  $cfg['Servers'][$i]['controluser'] = 'pma';
                  $cfg['Servers'][$i]['controlpass'] = 'pmapass';
                  

                  我安装了 XAMPP.在 PhpMyAdmin 中,我修改了 root@localhost 的密码.我可以使用新密码登录 PhpMyAdmin.

                  I installed XAMPP. In PhpMyAdmin I modified the password of root@localhost. I am able to login to PhpMyAdmin using the new password.

                  但是,当我按照 drupal 安装步骤添加新用户 Drupal 时,出现此错误:

                  But when I Add a new user Drupal as per drupal installation steps, I get this error:

                  Error 1045, "Access denied for user 'root'@'localhost' (Password: YES)
                  

                  但是仍然创建了drupal用户,但没有创建mysql中的drupal数据库.

                  But still the drupal user gets created but the drupal database in mysql doesnt get created.

                  当我尝试单独创建 drupal 数据库时,我能够做到.

                  When I try to create drupal database separately I am able to do it.

                  除此之外,我尝试了 MySQL.exe -u root -p.它在那里工作正常,所以我不确定.

                  Apart from this I tried MySQL.exe -u root -p. It works fine there, so I am not sure.

                  推荐答案

                  在 config.inc.php

                  In the config.inc.php

                  编辑

                  $cfg['Servers'][$i]['auth_type'] = 'whatever_it_is'; 
                  

                  $cfg['Servers'][$i]['auth_type'] = 'cookie';
                  

                  然后重新启动.

                  一些魔法会发生!!

                  这篇关于XAMPP PhpMyAdmin 错误 1045,“拒绝用户 'root'@'localhost' 的访问的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:在php中更改检索日期的时区 下一篇:是否可以使用 Drupal api 来获取用户列表?

                  相关文章

                  <tfoot id='WIefx'></tfoot>

                    1. <i id='WIefx'><tr id='WIefx'><dt id='WIefx'><q id='WIefx'><span id='WIefx'><b id='WIefx'><form id='WIefx'><ins id='WIefx'></ins><ul id='WIefx'></ul><sub id='WIefx'></sub></form><legend id='WIefx'></legend><bdo id='WIefx'><pre id='WIefx'><center id='WIefx'></center></pre></bdo></b><th id='WIefx'></th></span></q></dt></tr></i><div id='WIefx'><tfoot id='WIefx'></tfoot><dl id='WIefx'><fieldset id='WIefx'></fieldset></dl></div>

                        <bdo id='WIefx'></bdo><ul id='WIefx'></ul>

                      <small id='WIefx'></small><noframes id='WIefx'>

                    2. <legend id='WIefx'><style id='WIefx'><dir id='WIefx'><q id='WIefx'></q></dir></style></legend>