entityMap|blocks|key|3lahd|text|它现在起作用了。我不得不重新启动服务器。谢谢|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

It's working now. I had to restart server. 
Thanks

entityMap|blocks|key|62oit|text|我也面临着同样的问题。一切都很好，但是在|type|unstyled|depth|inlineStyleRanges|entityRanges|data|d8qcv|bootstrap/cache/config.php|blockquote|b1cbk|总是有不完整的密码。在进一步挖掘后，发现密码中有“#”字符，并且正在删除该字符。As+'#‘用于将一行标记为注释。^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$]]|$2|F|4|G|6|7|8|J|9|@]|A|@]|B|$]]]]

I was facing the same issue. Everything was fine but in 

<blockquote>
 bootstrap/cache/config.php
</blockquote>

always had the incomplete password. Upon digging further, realized that the password had '#' character in it and that was getting dropped. As '#' is used to mark a line as a comment.

entityMap|blocks|key|5cldo|text|我花了几个小时在这上面:-(最后，这真的很容易破解|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2vu13|之前|offset|length|style|BOLD|9e4se|DB_PASSWORD=#Root2020$|code-block|syntax|js|3mtlq|更新|9mhfj|DB_PASSWORD="#Root2020$"|bnj55|我认为问题在于密码中的#，这就是为什么我必须将密码写在引号中。^0|0|0|2|0|0|0|2|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|T|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|U|9|@$E|V|F|W|G|H]]|A|@]|B|$]]|$2|I|4|J|6|K|8|X|9|@]|A|@]|B|$L|M]]|$2|N|4|O|6|7|8|Y|9|@$E|Z|F|10|G|H]]|A|@]|B|$]]|$2|P|4|Q|6|K|8|11|9|@]|A|@]|B|$L|M]]|$2|R|4|S|6|7|8|12|9|@]|A|@]|B|$]]]]

I spent hours on this :-( and finally, it was really easy to hack
BEFORE
<pre><code>DB_PASSWORD=#Root2020$
</code></pre>
UPDATED
<pre><code>DB_PASSWORD=&quot;#Root2020$&quot;
</code></pre>
I think the problem was # in the password, that's why I had to write my password into quotation marks.

entityMap|blocks|key|34qr3|text|当我在共享主机上部署我的网站时，这些都不起作用，下面是我所做的工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|dp23e|在.env文件，我更改了|offset|length|style|CODE|86rrh|DB_HOST=127.0.0.1|code-block|syntax|js|2pq83|至|5r2fd|DB_HOST=localhost|cs3cb|还有中提琴，它的效果和预期的一样好。^0|0|1|4|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|T|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|U|9|@$E|V|F|W|G|H]]|A|@]|B|$]]|$2|I|4|J|6|K|8|X|9|@]|A|@]|B|$L|M]]|$2|N|4|O|6|7|8|Y|9|@]|A|@]|B|$L|M]]|$2|P|4|Q|6|K|8|Z|9|@]|A|@]|B|$L|M]]|$2|R|4|S|6|7|8|10|9|@]|A|@]|B|$]]]]

None of these worked for me when I deployed my website online on shared hosting, below is what I did that worked.

In the <code>.env</code> file, I changed 

<pre><code>DB_HOST=127.0.0.1
</code></pre>

to 

<pre><code>DB_HOST=localhost
</code></pre>

and viola, it worked well as expected.

entityMap|blocks|key|fbkgu|text|如果您以前使用过localhost和root，则会缓存您文件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|54pg9|删除/bootstap/cache/config.php^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

if you before use localhost and root your file be cached

remove /bootstap/cache/config.php

entityMap|blocks|key|39mho|text|这对我很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|59uoe|php+artisan+config:clear
php+artisan+cache:clear
php+artisan+config:cache|code-block|syntax|javascript|3a1pv|谢谢。^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|J|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|K|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|L|9|@]|A|@]|B|$]]]]

This works to me:

<pre><code>php artisan config:clear
php artisan cache:clear
php artisan config:cache
</code></pre>

Thanks.

entityMap|blocks|key|coh8d|text|我也有同样的问题，所以我意识到.env文件不接受特殊字符，因为我的密码包含这些字符，所以我将密码添加到config/database.php文件。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data^0|F|4|1F|J^^$0|$]|1|@$2|3|4|5|6|7|8|G|9|@$A|H|B|I|C|D]|$A|J|B|K|C|D]]|E|@]|F|$]]]]

I had the same problem, so I realized that the <code>.env</code> file does not accept special characters, as my password has these characters, I added the password in the <code>config/database.php</code> file.

entityMap|blocks|key|6b1st|text|天哪！多亏了下面的umair.ashfr答案，我终于遇到了一个正在吞噬我的神经元的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2r8e2|我有一个像DB这样的密码_我的.env上的PASSWORD=ffjdh5#fgr，MySQL连接很优雅地说"SQLSTATEHY000用户访问被拒绝...“，无论我尝试运行的是哪种风格的php+artisan。|etbdk|问题是密码中的"#“符号。当心！这意味着评论的开始，因此我的密码被默默地截断了！解决方案是像DB一样声明密码_PASSWORD="ffjdh5#fgr“|91jq6|问候^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|I|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|J|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|K|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|L|9|@]|A|@]|B|$]]]]

Jeez!
Thanks to umair.ashfr answer here below, I finally hit the nail with an issue that was eating my neurons.
I had a password like
DB_PASSWORD=ffjdh5#fgr
on my .env, and MySQL connection was gracefully saying that &quot;SQLSTATE[HY000] [1045] Access denied for user...&quot;, no matter what flavor of php artisan I was trying to run.
The problem was that &quot;#&quot; sign inside the password.
BEWARE! That means the start of a comment, thus my password was silently truncated!
The solution is to declare password like
DB_PASSWORD=&quot;ffjdh5#fgr&quot;
Regards

entityMap|blocks|key|cge80|text|我所做的事情也面临着同样的问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|ebmm9|php+artisan缓存:清除|ordered-list-item|b8d4j|php+artisan配置:缓存|2f0p0|但是发现了与我运行这个artisan命令相同的问题|50ncj|php工匠视图:清除|9c9pe|希望能有所帮助。^0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|N|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|O|9|@]|A|@]|B|$]]|$2|F|4|G|6|E|8|P|9|@]|A|@]|B|$]]|$2|H|4|I|6|7|8|Q|9|@]|A|@]|B|$]]|$2|J|4|K|6|7|8|R|9|@]|A|@]|B|$]]|$2|L|4|M|6|7|8|S|9|@]|A|@]|B|$]]]]

I Faced Same Problem what i did 

<ol>
<li>php artisan cache:clear </li>
<li>php artisan config:cache</li>
</ol>

but Same problem found than i run this artisan command

php artisan view:clear

Hope it will helpful.

entityMap|blocks|key|1ejek|text|而不是使用这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|78g2b|DB_HOST=localhost
DB_DATABASE=wdcollect
DB_USERNAME=root
DB_PASSWORD=|code-block|syntax|javascript|d1av5|使用这个|avh7i|DB_HOST=localhost
DB_DATABASE=wdcollect
DB_USERNAME=root
DB_PASSWORD=''^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|M|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|N|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|O|9|@]|A|@]|B|$F|G]]]]

Instead of using this

<pre><code>DB_HOST=localhost
DB_DATABASE=wdcollect
DB_USERNAME=root
DB_PASSWORD=
</code></pre>

USE this

<pre><code>DB_HOST=localhost
DB_DATABASE=wdcollect
DB_USERNAME=root
DB_PASSWORD=''
</code></pre>

entityMap|blocks|key|bnqhp|text|像DB一样声明密码_.env文件中的PASSWORD="2o0@#5TGR1NG“如果#+sign包含在您的密码中，则密码将在“”之间声明。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

Declare password like DB_PASSWORD=&quot;2o0@#5TGR1NG&quot; in .env file
If # sign include in your password then password will declare in between &quot; &quot;.

entityMap|blocks|key|dma21|text|您不需要在database.php文件中设置凭据。如果您在.env中有凭据，就足够了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4l3ji|如果您能够直接登录到数据库，则此密码必须有效。您的环境可能与此文件中定义的"local“不同。测试使用"php+artisan+env“^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

You do not need to set credentials in database.php file. It is enough if you have credentials in .env

If you are able to login to database directly then this password must work. It can be possible that you are having different environment than "local" which is defined in this file. Test is with "php artisan env"

entityMap|blocks|key|fisri|text|尝试签出根目录中的".env“文件。这将是一个隐藏文件。更正这些值。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|f69qo|DB_HOST=localhost
+DB_DATABASE=homestead
+DB_USERNAME=homestead
+DB_PASSWORD=secret|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

Try to checkout the ".env" file in your root directory. It will be a hidden file. Correct these values.

<pre><code> DB_HOST=localhost
 DB_DATABASE=homestead
 DB_USERNAME=homestead
 DB_PASSWORD=secret
</code></pre>

entityMap|blocks|key|aflal|text|请更新以下文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|ddcem|vendor+-+.env+-+on+line#7|e931g|DB_HOST=localhost
+DB_DATABASE=homestead
+DB_USERNAME=homestead
+DB_PASSWORD=secret|code-block|syntax|javascript|9dmp0|而不是宅地用户，你的数据库，用户名和密码。这对你来说应该是可行的。^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|M|9|@]|A|@]|B|$]]|$2|E|4|F|6|G|8|N|9|@]|A|@]|B|$H|I]]|$2|J|4|K|6|7|8|O|9|@]|A|@]|B|$]]]]

Please update below file.

vendor - .env - on line#7

<pre><code> DB_HOST=localhost
 DB_DATABASE=homestead
 DB_USERNAME=homestead
 DB_PASSWORD=secret
</code></pre>

Instead of homestead user your database, username and password. This should work for you.

entityMap|blocks|key|51sqv|text|如果你使用MAMP|type|unstyled|depth|inlineStyleRanges|entityRanges|data|da842|也检查你的端口号，通常是|eldgq|主机localhost|fps4n|端口8889|erhau|用户根|75d54|密码root|evh42|套接字/应用程序/MAMP/tmp/mysql/mysql.sock^0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|O|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|P|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|Q|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|R|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|S|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|T|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|U|9|@]|A|@]|B|$]]]]

If you are on MAMP

Check your port number as well generally it is

Host localhost

Port 8889

User root

Password root

Socket /Applications/MAMP/tmp/mysql/mysql.sock

entityMap|blocks|key|cvab7|text|请更新.env文件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1a39a|DB_HOST=localhost
+DB_DATABASE=homestead
+DB_USERNAME=homestead
+DB_PASSWORD=secret|code-block|syntax|javascript|b6di3|然后重启服务器|blockquote^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|K|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|L|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|J|8|M|9|@]|A|@]|B|$]]]]

Pls Update .env file

<pre><code> DB_HOST=localhost
 DB_DATABASE=homestead
 DB_USERNAME=homestead
 DB_PASSWORD=secret
</code></pre>

<blockquote>
 After then restart server
</blockquote>

entityMap|blocks|key|3r3h8|text|我也想出了这个..。然后，我通过将数据库信息直接放在“database.php”中来解决这个问题，在您的例子中，我会像这样更改信息|type|unstyled|depth|inlineStyleRanges|entityRanges|data|10n3k|mysql'+=>+[
++++++++'driver'++++=>+'mysql',
++++++++'host'++++++=>+'localhost',
++++++++'database'++=>+'wdcollect',
++++++++'username'++=>+'root',
++++++++'password'++=>+'',
++++++++'charset'+++=>+'utf8',
++++++++'collation'+=>+'utf8_unicode_ci',
++++++++'prefix'++++=>+'',
++++++++'strict'++++=>+false,
++++],|code-block|syntax|javascript|gm31|别忘了在XAMPP的config.inc中修改你的设置|fheip|['auth_type']+=+'config';
['Servers'][$i]['user']+=+'root';
['Servers'][$i]['password']+=+'';
['AllowNoPassword']+=+true;^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|M|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|N|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|O|9|@]|A|@]|B|$F|G]]]]

I came up with this too...
then I solve it by putting the database information directly in " database.php " 
In your case, I would change the information like this

<pre><code>mysql' =&gt; [
 'driver' =&gt; 'mysql',
 'host' =&gt; 'localhost',
 'database' =&gt; 'wdcollect',
 'username' =&gt; 'root',
 'password' =&gt; '',
 'charset' =&gt; 'utf8',
 'collation' =&gt; 'utf8_unicode_ci',
 'prefix' =&gt; '',
 'strict' =&gt; false,
 ],
</code></pre>

and don't forget to change your setting in XAMPP's config.inc

<pre><code>['auth_type'] = 'config';
['Servers'][$i]['user'] = 'root';
['Servers'][$i]['password'] = '';
['AllowNoPassword'] = true;
</code></pre>

entityMap|blocks|key|a444u|text|将.env文件和config.php文件与您在数据库settings.if中的用户名和密码以及您的主机名进行匹配，它们不相等，关系将不会连接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

Match the .env file and the config.php file with your username and password and your hostname in the database settings.if they are not equal,relation will not connect.

entityMap|blocks|key|2lmai|text|.env文件需要与mysql数据库具有相同的数据库名称、用户名和密码，并检查是否所有权限都授予了该用户访问数据库的权限。我通过在数据库名称前添加cpanel用户名和像jumbo这样的用户名解决了我的问题_admingo和jumbo_user1，其中jumbo是我的cpanel用户名，admingo是我在mysql中创建的数据库名称，user1是被提供了对数据库admingo的访问权限的用户。这解决了我的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

The .env file should have same database name , username and password as in the mysql database and check whether all permissions are granted to the user for accessing the database or not.
I solved my problem by adding the cpanel username in front of database name and username
like jumbo_admingo and jumbo_user1 respectively where jumbo is my cpanel username and admingo is the database name i created in mysql and user1 is the user which has been provided the access to the database admingo.
THIS SOLVED MY PROBLEM.

entityMap|blocks|key|7517h|text|原因是缓存了旧的数据库凭据/bootstap/cache/config.php在.env文件中，我对其进行了如下修改|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|ch7hq|DB_HOST=localhost
+DB_DATABASE=homestead
+DB_USERNAME=homestead
+DB_PASSWORD=secret|code-block|syntax|javascript|bi74h|然后删除该文件|evmlb|/bootstap/cache/config.php|js|fh1a9|如果问题仍然存在，您可以尝试以下方法。|BOLD|bse8|php+artisan+config:清除php+artisan缓存:清除php+artisan+config:cache|buflg|通过编写exit命令，然后重新启动vargarnt/homestead配置|a97hm|vagrant+reload+--provision|755ld|然后又打开了流浪汉|90kv6|Vagrant+Up
Vagrant+ssh^0|D|Q|0|0|0|0|0|J|0|0|4|4|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|13|9|@$A|14|B|15|C|D]]|E|@]|F|$]]|$2|G|4|H|6|I|8|16|9|@]|E|@]|F|$J|K]]|$2|L|4|M|6|7|8|17|9|@]|E|@]|F|$]]|$2|N|4|O|6|I|8|18|9|@]|E|@]|F|$J|P]]|$2|Q|4|R|6|7|8|19|9|@$A|1A|B|1B|C|S]]|E|@]|F|$]]|$2|T|4|U|6|7|8|1C|9|@]|E|@]|F|$]]|$2|V|4|W|6|7|8|1D|9|@$A|1E|B|1F|C|D]]|E|@]|F|$]]|$2|X|4|Y|6|I|8|1G|9|@]|E|@]|F|$J|P]]|$2|Z|4|10|6|7|8|1H|9|@]|E|@]|F|$]]|$2|11|4|12|6|I|8|1I|9|@]|E|@]|F|$J|K]]]]

Reason is the old database credentials are cached <code>/bootstap/cache/config.php</code>

In the .env file, I modified it as follow 

<pre><code> DB_HOST=localhost
 DB_DATABASE=homestead
 DB_USERNAME=homestead
 DB_PASSWORD=secret
</code></pre>

Then removed that file

<pre><code>/bootstap/cache/config.php 
</code></pre>

If the issue still there you might try the following.

php artisan config:clear
php artisan cache:clear
php artisan config:cache

Exit vagrant by writing the <code>exit</code> command
Then restart vargarnt/homestead config 

<pre><code>vagrant reload --provision
</code></pre>

Then opened vagrant again 

<pre><code>Vagrant Up
Vagrant ssh
</code></pre>

entityMap|blocks|key|f72g3|text|编辑laravel根目录中的文件.env。如下图所示：数据库_HOST=localhost数据库_DATABASE=laravel数据库_USERNAME=root数据库_密码=your-root-pas|type|ordered-list-item|depth|inlineStyleRanges|entityRanges|data|emd3c|还要在phpmyadmin中创建一个名为"laravel“的数据库。|6o6ug|运行以下命令：php+artisan缓存:清除php+artisan配置:缓存php+artisan配置:清除php+artisan迁移|a1m7n|它适用于我，使用Apache和MySQL的XAMPP。|unstyled^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|J|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|K|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|L|9|@]|A|@]|B|$]]|$2|G|4|H|6|I|8|M|9|@]|A|@]|B|$]]]]

<ol>
<li>Edit the file .env in your laravel root directory. make looks as in below : 

<pre><code> DB_HOST=localhost
 DB_DATABASE=laravel
 DB_USERNAME=root
 DB_PASSWORD=your-root-pas
</code></pre></li>
<li>Also create one database in phpmyadmin named, "laravel".</li>
<li>Run below commands :

<pre><code> php artisan cache:clear
 php artisan config:cache
 php artisan config:clear 
 php artisan migrate
</code></pre></li>
</ol>

It worked for me, XAMPP with Apache and MySQL.

entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/8881c6c24568fd05c5ca832fe3e4c0b9.png|imageAlt|blocks|key|1jj8f|text|在XAMPP上打开终端>转到/opt/lampp/htdocs/project_name>运行php+artisan+migrate.env文件|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|58u25|DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=8080
DB_DATABASE=database_name
DB_USERNAME=root
DB_PASSWORD=|code-block|syntax|javascript|20tf4|​|82i1f|?|atomic|ccjl3^0|E|U|1B|J|0|0|0|0|1|0|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]]|A|@$B|C|D|E|2|F|G|Y|H|@$I|Z|J|10|K|L]|$I|11|J|12|K|L]]|M|@]|6|$]]|$B|N|D|O|2|P|G|13|H|@]|M|@]|6|$Q|R]]|$B|S|D|T|2|F|G|14|H|@]|M|@]|6|$]]|$B|U|D|V|2|W|G|15|H|@]|M|@$I|16|J|17|B|18]]|6|$]]|$B|X|D|T|2|F|G|19|H|@]|M|@]|6|$]]]]

Open terminal on XAMPP > go to <code>/opt/lampp/htdocs/project_name</code> > run <code>php artisan migrate</code>

.env file 

<pre><code>DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=8080
DB_DATABASE=database_name
DB_USERNAME=root
DB_PASSWORD=
</code></pre>

<a href="https://i.stack.imgur.com/bSNor.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bSNor.png" alt="laravel: php artisan migrate on xampp terminal"></a>

entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/ac53fdda5816030103d8e078b4d0b845.png|imageAlt|blocks|key|2h1tf|text|在我的示例中，我希望连接到安装在windows上的数据库，我过去常常通过workbench访问该数据库，因此我将localhost替换为我通过键入以下命令获得的ip地址ipconfig在windows命令提示符上|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|bp8oc|?|atomic|au1fi|​^0|2C|8|0|0|1|0|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]]|A|@$B|C|D|E|2|F|G|S|H|@$I|T|J|U|K|L]]|M|@]|6|$]]|$B|N|D|O|2|P|G|V|H|@]|M|@$I|W|J|X|B|Y]]|6|$]]|$B|Q|D|R|2|F|G|Z|H|@]|M|@]|6|$]]]]

in my case I wanted to connect to the database installed on windows that i used to access through workbench, so i replaced localhost with the ip address which i obtained by typing <code>ipconfig</code> on windows command prompt
<a href="https://i.stack.imgur.com/z7nEO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/z7nEO.png" alt="enter image description here" /></a>

entityMap|blocks|key|8fauc|text|在我的例子中，这实际上是root用户权限问题。我的Laravel|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1095r|配置都很完美，但后来我发现这是根用户权限问题，因为我的MySQL配置不知何故发生了变化。|di91n|所以我导航到xampp文件夹>+C:\xampp\mysql\bin|unordered-list-item|d71j|搜索my.ini文件并在编辑器中打开它，然后添加添加skip-grant-tables在以下位置：[mysqld]+skip-grant-tables+port=3306|ajrif|它起作用了。^0|P|7|0|0|0|Q|H|1D|10|0^^$0|$]|1|@$2|3|4|5|6|7|8|P|9|@$A|Q|B|R|C|D]]|E|@]|F|$]]|$2|G|4|H|6|7|8|S|9|@]|E|@]|F|$]]|$2|I|4|J|6|K|8|T|9|@]|E|@]|F|$]]|$2|L|4|M|6|K|8|U|9|@$A|V|B|W|C|D]|$A|X|B|Y|C|D]]|E|@]|F|$]]|$2|N|4|O|6|7|8|Z|9|@]|E|@]|F|$]]]]

In my case, it was actually root user permission problem. My <code>Laravel</code> configurations were all perfect, but later I found that it was root user permission problem since my MySQL configs were somehow changed.
<ul>
<li>so i navigated to xampp folder &gt; C:\xampp\mysql\bin</li>
<li>searched for my.ini file and opened it in editor then added added <code>skip-grant-tables</code> in following place:</li>
</ul>
<code>[mysqld] skip-grant-tables port=3306</code>
and it worked.

I have installed Laravel 5 successfully and changed MySQL credentials in database.php file in config directory to
 '

<pre><code>mysql' =&gt; [
 'driver' =&gt; 'mysql',
 'host' =&gt; env('DB_HOST', 'localhost'),
 'database' =&gt; env('DB_DATABASE', 'wdcollect'),
 'username' =&gt; env('DB_USERNAME', 'root'),
 'password' =&gt; env('DB_PASSWORD', ''),
 'charset' =&gt; 'utf8',
 'collation' =&gt; 'utf8_unicode_ci',
 'prefix' =&gt; '',
 'strict' =&gt; false,
 ],
</code></pre>

I don't want to use homestead and I have changed .env file to

<pre><code>APP_ENV=local
APP_DEBUG=true
APP_KEY=apLIzEMOgtc5BUxdT9WRLSvAoIIWO87N

DB_HOST=localhost
DB_DATABASE=wdcollect
DB_USERNAME=root
DB_PASSWORD=

CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync

MAIL_DRIVER=smtp
MAIL_HOST=mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=null
MAIL_PASSWORD=null
</code></pre>

I don't understand that why it's saying that access denied for 'homestead'@'localhost'

Laravel 5 error SQLSTATE[HY000] [1045] Access denied for user 'homestead'@'localhost' (using password: YES)

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

 我已成功安装Laravel 5，并将配置目录中database.php文件中的MySQL凭据更改为‘ mysql' => [            'driver'    => 'mysql',            'host'      => env('DB_HOST', 'localhost'),            'database'  => env('DB_DATABASE', '

问Laravel 5错误SQLSTATE[HY000] [1045]拒绝访问用户'homestead'@'localhost‘(使用密码: YES)
EN

回答 24

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Laravel 5错误SQLSTATE[HY000] [1045]拒绝访问用户'homestead'@'localhost‘(使用密码: YES)EN

回答 24

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Laravel 5错误SQLSTATE[HY000] [1045]拒绝访问用户'homestead'@'localhost‘(使用密码: YES)
EN