blocks|key|2539008|text|将+config.sample.inc.php复制到config.inc.php。
在大多数情况下，您将找到配置文件。|type|ordered-list-item|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|2539009|-+on+linux:+`/etc/phpmyadmin/config.inc.php`
-+on+mac:+`/Library/WebServer/Documents/phpmyadmin/config.inc.php`+|code-block|syntax|javascript|2539010|​|unstyled|2539011|如果您试图以root身份登录，您的配置中应该有以下几行：
$cfg‘’Servers‘’user‘=+'root'；
$cfg‘’Servers‘’AllowNoPassword‘=真；|2539012|entityMap^0|0|1|2|L|Q|E|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|D]|$9|X|A|Y|B|D]]|E|@]|F|$]]|$1|G|3|H|5|I|7|Z|8|@]|E|@]|F|$J|K]]|$1|L|3|M|5|N|7|10|8|@]|E|@]|F|$]]|$1|O|3|P|5|6|7|11|8|@]|E|@]|F|$]]|$1|Q|3|-4|5|N|7|12|8|@]|E|@]|F|$]]]|R|$]]

<ol>
<li>Copy <code>config.sample.inc.php</code> to <code>config.inc.php</code>.

In most cases you will find the config file

<ul>
<li>on linux: <code>/etc/phpmyadmin/config.inc.php</code></li>
<li>on mac: <code>/Library/WebServer/Documents/phpmyadmin/config.inc.php
</code></li>
</ul></li>
<li>If you are trying to log in as root, you should have the following lines in your config:

<blockquote>
 $cfg['Servers'][$i]['user'] = 'root'; 
 $cfg['Servers'][$i]['AllowNoPassword'] = true;
</blockquote></li>
</ol>

blocks|key|2539207|text|根据这一点：https://www.simplified.guide/phpmyadmin/enable-login-without-password|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2539208|这个$cfg['Servers'][$i]['AllowNoPassword']+=+TRUE;应该在/etc/phpmyadmin/config.inc.php中添加两次|style|CODE|2539209|if+(!empty($dbname))+{
++++//+other+configuration+options
++++$cfg['Servers'][$i]['AllowNoPassword']+=+TRUE;
++++//+it+should+be+placed+before+the+following+line
++++$i%2B%2B;
}

//+other+configuration+options
$cfg['Servers'][$i]['AllowNoPassword']+=+TRUE;|code-block|syntax|javascript|2539210|entityMap|0|LINK|mutability|MUTABLE|url|https://www.simplified.guide/phpmyadmin/enable-login-without-password^0|6|1X|0|0|2|1A|1F|U|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@$A|Z|B|10|F|G]|$A|11|B|12|F|G]]|9|@]|C|$]]|$1|H|3|I|5|J|7|13|8|@]|9|@]|C|$K|L]]|$1|M|3|-4|5|6|7|14|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

According to this: <a href="https://www.simplified.guide/phpmyadmin/enable-login-without-password" rel="nofollow noreferrer">https://www.simplified.guide/phpmyadmin/enable-login-without-password</a>

This <code>$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;</code> should be added twice in <code>/etc/phpmyadmin/config.inc.php</code>

<pre><code>if (!empty($dbname)) {
 // other configuration options
 $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
 // it should be placed before the following line
 $i++;
}

// other configuration options
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
</code></pre>

blocks|key|1342561|text|我检验了这份声明：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1342562|$cfg['Servers'][$i]['AllowNoPasswordRoot']+=+true;+|code-block|syntax|javascript|1342563|对我来说不管用。|1342564|相反，|1342565|$cfg['Servers'][$i]['AllowNoPassword']+=+true;+|1342566|起作用了。|1342567|谢谢!|1342568|entityMap^0|0|0|0|0|0|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|@]|A|$]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|W|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|X|8|@]|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|$]]

I tested the statement:

<pre><code>$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true; 
</code></pre>

It did not work out for me.

Instead 

<pre><code>$cfg['Servers'][$i]['AllowNoPassword'] = true; 
</code></pre>

worked. 

Thanks!

blocks|key|2539376|text|是的，不行！我和这个愚蠢的phpMyAdmin呆了一整天。只需使用密码添加新用户即可。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2539377|1-登录到mysql或mariadb+mysql+-u+root+-p|offset|length|style|CODE|2539378|2-运行这些SQL命令创建具有所有权限的新用户(或授予您的自定义权限)。|2539379|CREATE+USER+'someone'@'localhost'+IDENTIFIED+BY+'password';
GRANT+ALL+PRIVILEGES+ON+*.*+TO+'someone'@'localhost';
FLUSH+PRIVILEGES;|code-block|syntax|javascript|2539380|2-转到/etc/phpMyAdmin/config.inc.php并更改如下：|2539381|$cfg['Servers'][$i]['user']++++++++++=+'someone';
$cfg['Servers'][$i]['password']++++++=+'password';|2539382|警告:此配置仅用于本地主机开发服务器，如果您正在运行生产服务器，则必须使用强凭据，而不应在config.inc.php中设置用户传递。|2539383|entityMap^0|0|J|G|0|0|0|4|U|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|10|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|11|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|12|8|@$D|13|E|14|F|G]]|9|@]|A|$]]|$1|Q|3|R|5|L|7|15|8|@]|9|@]|A|$M|N]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|V|$]]

Yes not working! I spent whole day with this stupid phpMyAdmin. Just add a new user with a password

1 - Login to mysql or mariadb <code>mysql -u root -p</code>

2 - Run these SQL commands to create a new user with all permissions (or grant your custom permissions)

<pre><code>CREATE USER 'someone'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'someone'@'localhost';
FLUSH PRIVILEGES;
</code></pre>

2 - Go to <code>/etc/phpMyAdmin/config.inc.php</code> and change this:

<pre class="lang-php prettyprint-override"><code>$cfg['Servers'][$i]['user'] = 'someone';
$cfg['Servers'][$i]['password'] = 'password';
</code></pre>

WARNING: This config is for localhost development server only, If you're running a production server you must use strong credentials and not setting user pass in config.inc.php

blocks|key|2539045|text|您可能犯了与我相同的愚蠢错误，没有删除//使其成为评论。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2539046|这一行应该是这样的，但不是作为评论。|2539047|$cfg['Servers'][$i]['AllowNoPassword']+=+TRUE;|code-block|syntax|javascript|2539048|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You might have made the same silly mistake that I did, by not removing the // making it a comment.

The line should be like this, but not as a comment.

<pre><code>$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
</code></pre>

blocks|key|2897948|text|确保没有在$i%2B%2B行之后添加或取消对AllowNoPassword选项的注释。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2897949|在注意到相关的安全风险之后，/*取消注释下面的内容，以启用登录到无密码帐户。*/|2897950|+$cfg['Servers'][$i]['AllowNoPassword']+=+TRUE;|code-block|syntax|javascript|2897951|entityMap^0|0|13|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

Make sure you don't add or uncomment the AllowNoPassword option after the $i++ line.

/* Uncomment the following to enable logging in to passwordless accounts,
 * after taking note of the associated security risks. */

<pre><code> $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
</code></pre>

blocks|key|2897991|text|仅在文件/etc/phpmyadmin/config.inc.php中，取消注释或添加行(如果没有)，|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2897992|$cfg['Servers'][$i]['AllowNoPassword']+=+TRUE;|code-block|syntax|javascript|2897993|真是太棒了！|2897994|如果您有任何疑问，请重新启动apache。|2897995|sudo+/etc/init.d/apache2+restart|2897996|干杯！|2897997|entityMap^0|4|U|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|Z|8|@]|D|@]|E|$]]|$1|O|3|P|5|H|7|10|8|@]|D|@]|E|$I|J]]|$1|Q|3|R|5|6|7|11|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|T|$]]

Just in file <code>/etc/phpmyadmin/config.inc.php</code>, uncomment or add the line(if not there),

<pre><code>$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
</code></pre>

It works just Awesome!

if you have any doubt restart apache.

<pre><code>sudo /etc/init.d/apache2 restart
</code></pre>

Cheers!!!

blocks|key|2898534|text|我也有同样的问题。编辑config.inc.php没有工作，类似于重新安装phpmyadmin、apache或mysql。唯一的方法是使用密码登录到phpmyadmin。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2898535|如何设置密码：|2898536|从下面的脚本中做所有事情：|ordered-list-item|2898537|sudo+mysql_secure_installation|offset|length|style|CODE|2898538|运行：|2898539|sudo+mysql|2898540|更改根用户密码的身份验证方法，并设置密码：|2898541|mysql>+SELECT+user,authentication_string,plugin,host+FROM+mysql.user;|2898542|2898543|mysql>+FLUSH+PRIVILEGES;|2898544|exit+mysql.|2898545|现在您可以正确地登录到phpmyadmin。|2898546|entityMap^0|0|0|0|0|U|0|0|0|A|0|0|0|1X|0|0|0|O|0|0|4|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|15|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|16|8|@$I|17|J|18|K|L]]|9|@]|A|$]]|$1|M|3|N|5|F|7|19|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1A|8|@$I|1B|J|1C|K|L]]|9|@]|A|$]]|$1|Q|3|R|5|F|7|1D|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1E|8|@$I|1F|J|1G|K|L]]|9|@]|A|$]]|$1|U|3|N|5|F|7|1H|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1I|8|@$I|1J|J|1K|K|L]]|9|@]|A|$]]|$1|X|3|Y|5|F|7|1L|8|@$I|1M|J|1N|K|L]]|9|@]|A|$]]|$1|Z|3|10|5|6|7|1O|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]]|12|$]]

I had the same problem.
Edit config.inc.php didn't work, similary as reinstall phpmyadmin, apache or mysql.
Only way is using password to log in to phpmyadmin.
How to set password:
<ol>
<li>Do everything from below script:</li>
</ol>
<code>sudo mysql_secure_installation</code>
<ol start="2">
<li>Run:</li>
</ol>
<code>sudo mysql</code>
<ol start="3">
<li>Change authentication method of password for root and set password:</li>
</ol>
<code>mysql&gt; SELECT user,authentication_string,plugin,host FROM mysql.user;</code>
<ol start="4">
<li>Run:</li>
</ol>
<code>mysql&gt; FLUSH PRIVILEGES;</code>
<ol start="5">
<li><code>exit</code> mysql.</li>
</ol>
Now you can log to phpmyadmin correctly.

blocks|key|2539096|text|我在这里也有同样的问题，然后我重新安装了mysql，它成功了。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2539097|sudo+apt-get+install+mysql-server+mysql-common+mysql-client|code-block|syntax|javascript|2539098|entityMap^0|K|5|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

I have the same problem here, then I reinstalled <code>mysql</code> and it worked.

<pre><code>sudo apt-get install mysql-server mysql-common mysql-client
</code></pre>

blocks|key|2898182|text|我也有同样的问题，我解决了我的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2898183|先去config.default.php换车|offset|length|style|CODE|2898184|$cfg['Servers'][$i]['AllowNoPassword']+=+false;|code-block|syntax|javascript|2898185|至|2898186|$cfg['Servers'][$i]['AllowNoPassword']+=+true;|2898187|entityMap^0|0|2|I|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@$D|U|E|V|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|W|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|Y|8|@]|9|@]|A|$K|L]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

I had a same problem, and I solved my problem. First go to <code>config.default.php</code> and change

<pre><code>$cfg['Servers'][$i]['AllowNoPassword'] = false;
</code></pre>

to 

<pre><code>$cfg['Servers'][$i]['AllowNoPassword'] = true;
</code></pre>

blocks|key|2898490|text|在没有密码的情况下登录是被配置所禁止的(请参阅allownopassword)|type|blockquote|depth|inlineStyleRanges|entityRanges|data|2898491|在ubuntu+20.04和MYSQL+8.0.x中，我也遇到了同样的问题，我试图允许PHPMyAdmin不使用密码。|unstyled|offset|length|style|CODE|2898492|为此，可以使用以下命令打开配置文件：|ordered-list-item|2898493|sudo+nano+/etc/phpmyadmin/config.inc.php+|code-block|syntax|javascript|2898494|然后使用CTRL%2Bw在PHPMyAdmin`s的配置文件中查找$cfg['Servers'][$i]['AllowNoPassword']：|BOLD|2898495|/*+Uncomment+the+following+to+enable+logging+in+to+passwordless+accounts,
+++++*+after+taking+note+of+the+associated+security+risks.+*/
//$cfg['Servers'][$i]['AllowNoPassword']+=+TRUE;|2898496|删除如下所示的//，从而取消对行的注释：|2898497|$cfg['Servers'][$i]['AllowNoPassword']+=+TRUE;|2898498|使用CTRL%2Bo保存文件，然后使用CTRL%2Bx退出文件。|2898499|在此之后，通过以下命令重新启动MySQL：|2898500|sudo+service+mysql+restart|2898501|尝试访问本地http://127.0.0.1/phpmyadmin/中的http://127.0.0.1/phpmyadmin/|2898502|entityMap^0|0|1|C|E|B|0|0|0|4|6|V|12|0|0|7|2|0|0|2|6|H|6|0|0|0|6|S|10|S|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1A|8|@$E|1B|F|1C|G|H]|$E|1D|F|1E|G|H]]|9|@]|A|$]]|$1|I|3|J|5|K|7|1F|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|1G|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|K|7|1H|8|@$E|1I|F|1J|G|S]|$E|1K|F|1L|G|H]]|9|@]|A|$]]|$1|T|3|U|5|N|7|1M|8|@]|9|@]|A|$O|P]]|$1|V|3|W|5|K|7|1N|8|@$E|1O|F|1P|G|H]]|9|@]|A|$]]|$1|X|3|Y|5|N|7|1Q|8|@]|9|@]|A|$O|P]]|$1|Z|3|10|5|K|7|1R|8|@$E|1S|F|1T|G|S]|$E|1U|F|1V|G|S]]|9|@]|A|$]]|$1|11|3|12|5|K|7|1W|8|@]|9|@]|A|$]]|$1|13|3|14|5|N|7|1X|8|@]|9|@]|A|$O|P]]|$1|15|3|16|5|K|7|1Y|8|@$E|1Z|F|20|G|H]|$E|21|F|22|G|H]]|9|@]|A|$]]|$1|17|3|-4|5|D|7|23|8|@]|9|@]|A|$]]]|18|$]]

<blockquote>
<h2 id="login-without-a-password-is-forbidden-by-configuration-see-allownopassword-lpdm">login without a password is forbidden by configuration (see allownopassword)</h2>
</blockquote>
In <code>ubuntu 20.04</code> and <code>MYSQL 8.0.x</code> I had the same problem and I tried to allow PHPMyAdmin not to using passwords.
<ol>
<li>So for this you can open the config file by using this command:</li>
</ol>
<pre><code>sudo nano /etc/phpmyadmin/config.inc.php 
</code></pre>
<ol start="2">
<li>Then use CTRL+w to find <code>$cfg['Servers'][$i]['AllowNoPassword']</code> in PHPMyAdmin`s config file:</li>
</ol>
<pre><code>/* Uncomment the following to enable logging in to passwordless accounts,
 * after taking note of the associated security risks. */
//$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
</code></pre>
<ol start="3">
<li>Uncomment the line by removing the <code>//</code> like this:</li>
</ol>
<pre><code>$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
</code></pre>
<ol start="4">
<li>Use CTRL+o to save the file and then CTRL+x to exit from the file.
</li>
<li>After that restart the MySQL by this command:
</li>
</ol>
<pre><code>sudo service mysql restart
</code></pre>
<ol start="6">
<li>Try to access PHPMyAdmin in your local <code>http://127.0.0.1/phpmyadmin/</code></li>
</ol>

blocks|key|1342585|text|经过多次试验，我找到了以下解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1342586|如果您在/var/www中复制了所有phpmyadmin文件，这将有效。|1342587|转到/var/www中phpmyadmin文件夹的复制位置|1342588|copy+the+config.sample.inc.php+file+as+config.inc.php|code-block|syntax|javascript|1342589|在config.inc.php中编辑以下行：|1342590|$cfg['Servers'][$i]['AllowNoPassword']+=+true;|1342591|(在原始文件中，它是false，将其更改为true并保存它。)|1342592|然后，您将能够登录phpmyadmin没有密码。|1342593|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|Z|8|@]|9|@]|A|$I|J]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

After a lot of trials I found the following solution.

This will work if you copied all phpmyadmin files in /var/www

go to your copied location of phpmyadmin folder in /var/www

<pre><code>copy the config.sample.inc.php file as config.inc.php
</code></pre>

edit in config.inc.php the following line:

<pre><code>$cfg['Servers'][$i]['AllowNoPassword'] = true;
</code></pre>

(In original file it was false, change it as true and save it.)

Then you will be able to login phpmyadmin without password.

blocks|key|1342755|text|$cfg['Servers'][$i]['AllowNoPassword']+=+TRUE;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1342756|是的，上面的答案是正确的，但是它是不安全的，您可以直接将根用户登录到phpMyAdmin。|unstyled|offset|length|style|BOLD|CODE|1342757|如果要创建具有密码的新用户并授予权限，请在终端上的MySQL中执行以下命令，登录到终端上的服务器，|1342758|++#+mysql

+mysql>+GRANT+ALL+PRIVILEGES+ON+*.*+TO++'user-name'@'%25'++IDENTIFIED+BY++'password'+++REQUIRE+NONE+WITH+GRANT+OPTION+MAX_QUERIES_PER_HOUR+0+MAX_CONNECTIONS_PER_HOUR+0+MAX_UPDATES_PER_HOUR+0+MAX_USER_CONNECTIONS+0;|1342759|entityMap^0|0|S|3|Y|A|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|S|8|@$G|T|H|U|I|J]|$G|V|H|W|I|K]]|9|@]|A|$]]|$1|L|3|M|5|F|7|X|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Y|8|@]|9|@]|A|$B|C]]|$1|P|3|-4|5|F|7|Z|8|@]|9|@]|A|$]]]|Q|$]]

<pre><code>$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
</code></pre>

yes the above answer is correct, but it's not secure, you can login root user directlyinto <code>phpMyAdmin</code>.

If you want to create new user with password and give grant permission, execute the below command in MySQL on terminal, 
Login into your server on terminal,

<pre><code> # mysql

 mysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'user-name'@'%' IDENTIFIED BY 'password' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
</code></pre>

blocks|key|1342954|text|对我来说，除了在config.inc.php文件中设置“允许没有密码”选项之外，我还必须将auth类型设置为config。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1342955|$cfg['Servers'][$i]['auth_type']+=+'config';
$cfg['Servers'][$i]['AllowNoPassword']+=+TRUE;|code-block|syntax|javascript|1342956|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|$]]

For me I had to set the auth type to config in addition to the setting the allow no password option in the config.inc.php file.
<pre><code>$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
</code></pre>

blocks|key|2898128|text|其他人可能会发现，像我一样(在OSX10.10.1中工作)，MAMP的情况(至少在当前版本3.0.7.3中是不同的)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2898129|我在这里提出的所有补救措施都以失败告终。在检查PHP日志时，我发现正在运行的index.php+(在/Libary/Application+Support/appsolute/MAMP+PRO/index.php中--在第43行)决定不转到这里讨论的config.inc.php+(at+/Applications/MAMP/bin/phpMyAdmin/config.inc.php)，而是转到/Library/Application+Support/appsolute/MAMP+PRO/phpMyAdmin/config.inc.php。|offset|length|style|CODE|2898130|此外，那里没有这样的文件(在“成功地”安装了MAMP之后)，所以我被错误困住了，而且，每次我试图将正确的文件放在那里时，当我重新启动MAMP时，它已经不在了--一些东西会自动刷新，以消除我在那里放置的config.inc.php。我现在的解决办法是在MAMP而不是MAMP中这样做。|2898131|entityMap^0|0|1E|1K|3H|E|40|1C|5I|21|0|2S|E|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]|$D|P|E|Q|F|G]|$D|R|E|S|F|G]|$D|T|E|U|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@$D|W|E|X|F|G]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$]]

Others may find, as I did, (working in OS X 10.10.1) that the situation for MAMP PRO (at least in the current release, 3.0.7.3, is different.

All my attempts to apply the remedies suggested here failed. Upon examining the PHP error log I discovered that the index.php that is operating (in <code>/Libary/Application Support/appsolute/MAMP PRO/index.php</code> -- at line 43, is deciding NOT to go to the <code>config.inc.php</code> that is discussed here (at <code>/Applications/MAMP/bin/phpMyAdmin/config.inc.php</code>) but rather to <code>/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin/config.inc.php</code>. 

Furthermore, there is no such file there (after a 'successful' install of MAMP PRO), so I'm stuck with the error, and furtherfuthermore, every time I try to put the correct file there, when I restart MAMP PRO, it is not there anymore - something is automatically refreshed to eliminate the <code>config.inc.php</code> I'm putting there. My workaround for now is to do this in MAMP instead of MAMP PRO.

blocks|key|2539317|text|我不得不安装MariaDB。我使用的是OpenSUSE+LINUX+15，必须执行以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2539318|sudo+zypper+update
sudo+zypper+install+mariadb+mariadb-client+mariadb-tools
sudo+systemctl+start+mysql
sudo+systemctl+enable+mysql+//enable+auto+start+at+boot+time3
sudo+mysql_secure_installation|code-block|syntax|javascript|2539319|来源。|offset|length|2539320|entityMap|0|LINK|mutability|MUTABLE|url|https://www.linuxbabe.com/opensuse/apache-mariadb-php7-lamp-opensuse-leap-42-2#null^0|0|0|0|2|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]]]]

I had to install MariaDB. I am using OpenSUSE LINUX Leap 15 and had to execute these commands:

<pre><code>sudo zypper update
sudo zypper install mariadb mariadb-client mariadb-tools
sudo systemctl start mysql
sudo systemctl enable mysql //enable auto start at boot time3
sudo mysql_secure_installation
</code></pre>

<a href="https://www.linuxbabe.com/opensuse/apache-mariadb-php7-lamp-opensuse-leap-42-2#null" rel="nofollow noreferrer">Source</a>.

blocks|key|1342842|text|这很管用，只是觉得这对将来的人会有帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1342843|如果您正在使用MAMP，作为一种安全措施，$cfg['Servers'][$i]['AllowNoPassword']+=+true;通常会丢失在config.inc.php文件中，因此如果您想要使用phpMyAdmin而没有根的密码，那么最好在$cfg['Servers'][$i]['AllowDeny']['rules']+=+array();语句之后添加它。|offset|length|style|CODE|BOLD|1342844|然后重新启动您的服务器只是为了确保，您将很好地走。|1342845|entityMap^0|0|L|1A|21|E|3F|1G|35|1|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@$D|O|E|P|F|G]|$D|Q|E|R|F|G]|$D|S|E|T|F|G]|$D|U|E|V|F|H]]|9|@]|A|$]]|$1|I|3|J|5|6|7|W|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|L|$]]

It works; just thought this would be helpful to someone in the future.

If you are working with MAMP, as a security measure, the <code>$cfg['Servers'][$i]['AllowNoPassword'] = true;</code> usually will be missing in the <code>config.inc.php</code> file so if you want to use phpMyAdmin without a password for root then simply add it preferably after the <code>$cfg['Servers'][$i]['AllowDeny']['rules'] = array();</code> statement. 

Then Restart your server just to be sure and you will be good to go.

blocks|key|1342911|text|经过了很多的挣扎，我在这里发现你：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1342912|打开文件夹->+xampp|ordered-list-item|1342913|然后打开->+phpmyadmin|1342914|最后打开->+config.inc|1342915|$cfg['blowfish_secret']+=+'';+/*+YOU+MUST+FILL+IN+THIS+FOR+COOKIE+AUTH!+*/|code-block|syntax|javascript|1342916|把SHA256放在像这个一样的单引号里|1342917|830bbca930d5e417ae4249931838e2c70ca0365044268fa0ede75e33aff677de|1342918|$cfg['blowfish_secret']+=+'830bbca930d5e417ae4249931838e2c70ca0365044268fa0ede75e33aff677de
';|1342919|我在下载phpmyadmin的更新版本时发现了这一点。我希望这个解决方案能帮助你。|1342920|📷|atomic|offset|length|1342921|​|1342922|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/590256add02d80c074e3845fb278e1c3.jpg|imageAlt^0|0|0|0|0|0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1C|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|1D|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|1E|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|1F|8|@]|9|@]|A|$L|M]]|$1|N|3|O|5|D|7|1G|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1H|8|@]|9|@]|A|$]]|$1|R|3|S|5|K|7|1I|8|@]|9|@]|A|$L|M]]|$1|T|3|U|5|6|7|1J|8|@]|9|@]|A|$]]|$1|V|3|W|5|X|7|1K|8|@]|9|@$Y|1L|Z|1M|1|1N]]|A|$]]|$1|10|3|11|5|6|7|1O|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]]|13|$14|$5|15|16|17|A|$18|19|1A|-4]]]]

After lots of struggle I found here you go:
<ol>
<li>open folder -&gt; xampp</li>
<li>then open -&gt; phpmyadmin</li>
<li>finally open -&gt; config.inc</li>
</ol>
<pre><code>$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
</code></pre>
<ol start="4">
<li>Put SHA256 inside single quotations like this one</li>
</ol>
830bbca930d5e417ae4249931838e2c70ca0365044268fa0ede75e33aff677de
<pre><code>$cfg['blowfish_secret'] = '830bbca930d5e417ae4249931838e2c70ca0365044268fa0ede75e33aff677de
';
</code></pre>
I found this when I was downloading updated version of phpmyadmin. I wish this solution help you. <a href="https://i.stack.imgur.com/9G0xs.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9G0xs.jpg" alt="enter image description here" /></a>

blocks|key|1342935|text|我的问题是config.inc.php+<?变成了<?php|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1342936|entityMap^0|K|2|P|5|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|$]]

My problem was in config.inc.php
<code>&lt;?</code> changed to <code>&lt;?php</code>

blocks|key|1342983|text|vim+/etc/phpmyadmin/config.inc.php|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1342984|或|unstyled|1342985|sudo+-H+gedit+/etc/phpmyadmin/config.inc.php|1342986|取消以下行的注释|1342987|$cfg['Servers'][$i]['AllowNoPassword']+=+TRUE;|1342988|然后，使用以下命令退出并保存该文件，|1342989|:wq|1342990|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|T|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$B|C]]|$1|M|3|N|5|F|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$B|C]]|$1|Q|3|-4|5|F|7|Z|8|@]|9|@]|A|$]]]|R|$]]

<pre><code>vim /etc/phpmyadmin/config.inc.php
</code></pre>
or
<pre><code>sudo -H gedit /etc/phpmyadmin/config.inc.php
</code></pre>
uncomment this below line
<pre><code>$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
</code></pre>
Then, exit and save the file using the following command,
<pre><code>:wq
</code></pre>

I have a version of phpMyAdmin located on my local Apache server.

I am trying to login without a password however phpMyAdmin keeps throwing the warning:

<blockquote>
 Login without a password is forbidden by configuration (see AllowNoPassword)
</blockquote>

However in my config.php file for phpMyAdmin I have set:

<pre><code>$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
</code></pre>

So I don't know why the message is still appearing.

Can anyone confirm that phpMyAdmin AllowNoPassword works with MySQL databases?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我的本地Apache服务器上有一个版本的phpMyAdmin。我试图在没有密码的情况下登录，但是phpMyAdmin一直在抛出警告：配置禁止无密码登录(请参阅AllowNoPassword)但是，在我的config.php文件phpMyAdmin中，我设置了：$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;所以我不知道为什么这个信息还会出现。

问有人能确认phpMyAdmin AllowNoPassword与MySQL数据库一起工作吗？
EN

回答 20

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有人能确认phpMyAdmin AllowNoPassword与MySQL数据库一起工作吗？EN

回答 20

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有人能确认phpMyAdmin AllowNoPassword与MySQL数据库一起工作吗？
EN