Learn how to fix Laravel Docker Redis Connection Refused error. Our Laravel Support team is here to help you with your questions and concerns.

Laravel Docker Redis Connection Refused | Resolved

Laradock is a popular PHP development environment built on Docker. It offers a set of images for Nginx, Apache, MySQL, Composer, Supervisord, Redis, etc.

While getting started with Laradock is easy with the ‘docker-compose up’ command, sometimes we may run into problems when connecting to the MySQL database and Redis.

Today, we are going to take a look at some of the common connection problems and fix the error.

• Connecting to MySQL:

  When we use Laradock, connecting to the MySQL database can lead to the  SQLSTATE[HY000] [2002] Connection refused error.

  This is usually due to the default settings in the .env file. We can fix this by updating these entries:

  DB_CONNECTION=mysql
DB_HOST=mysql
DB_PORT=3306
DB_DATABASE=laraqueue
DB_USERNAME=root
DB_PASSWORD=root

  Then, head to the Laradock directory and find the my.cnf file under the MySQL directory. We have to add this line to the file:

  sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
character-set-server=utf8
default_authentication_plugin=mysql_native_password


  Next, we have to rebuild the MySQL image with the ‘docker-compose build mysql’  command and restart the service. If the error still occurs, we have to go to the MySQL terminal and run these commands:

  
sudo docker exec -it bash
mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
ALTER USER 'default'@'%' IDENTIFIED WITH mysql_native_password BY 'secret';

• Connecting to Redis:

  When we run into issues with Redis, we have to make sure the Redis host in the .env file is set to the name of the service running Redis, in this case, ‘redis’:

  REDIS_HOST=redis

  Then, run the “docker ps” command to make sure the Redis container is running. If problems still occur, clear the cache using:

  php artisan config:clear

With the above steps, we can easily resolve the common Laradock connection issues with MySQL and Redis. This leads to a smooth development environment for our PHP applications.

[Need assistance with a different issue? Our team is available 24/7.]

Conclusion

In brief, our Support Experts demonstrated how to fix the Laravel Docker Redis Connection Refused error.