Should DB_HOST be changed to 127.0.0.1?

Question

So I'm using XAMPP and Laravel 5.x with PHP7.4 and when I load my local server, I run into an error and cannot access the database on my system. When I searched online, the answers I found said to change the local DB_HOST address in the database.php file to 127.0.0.1 instead of setting it to localhost because MYSQL will use TCP to connect instead of a UNIX socket. Will it cause problems if I push this change to staging or production servers?

P粉587780103 · Answer

Laravel uses the DotEnv library to configure different environments. You can follow the Laravel documentation to generate .env files for each environment (local and development server).

P粉986860950 · Answer

On a real server, you need to connect to the database server that contains the database used by the application, Therefore the .env configuration related to the database needs to be changed to the actual database server

DB_HOST=[这里是数据库服务器IP]
DB_PORT=3306
DB_DATABASE=[数据库名称]
DB_USERNAME=[用户名]
DB_PASSWORD=[用户密码]

What you need to read about Laravel Project Deployment