Level 102
Set FORWARD_DB_PORT=3307 or similar in your .env and try again
You can see it here: https://github.com/laravel/sail/blob/69013b19d554b2aaa1d57b4237a88e9d720e67d7/stubs/mysql.stub#L4
1 like
Jan 30, 2023
8
Level 5
ports not available mysql
Hi, I am running Laravel sail for the first time. I have valet and mysql already running at port 3306. I want to use Laravel sail as well. Is there any way I can run mysql for sail in different port?
I go this error while running: ./vendor/bin/sail up
Error response from daemon: Ports are not available: exposing port TCP 0.0.0.0:3306 -> 0.0.0.0:0: listen tcp 0.0.0.0:3306: bind: address already in use
How can I use different port for mysql.?
Thanks
Level 5
@Sinnbeck Here is my .env
DB_CONNECTION=mysql
DB_HOST=mysql
FORWARD_DB_PORT=3307
DB_DATABASE=laravel
DB_USERNAME=sail
DB_PASSWORD=password
and I got this error again: Error response from daemon: Ports are not available: exposing port TCP 0.0.0.0:80 -> 0.0.0.0:0: listen tcp 0.0.0.0:80: bind: address already in use
Level 102
@david001 same thing :) https://github.com/laravel/sail/blob/69013b19d554b2aaa1d57b4237a88e9d720e67d7/stubs/docker-compose.stub#L14
APP_PORT=8081
Click on any port here to see what the env name is for the port :)
https://github.com/laravel/sail/tree/69013b19d554b2aaa1d57b4237a88e9d720e67d7/stubs
1 like
Level 5
@Sinnbeck Thanks , I have use APP_PORT=8081 in .env and my server is running now. However in browser I got 404 error while accessing localhost. I have / url in my web.php and it opens welcome.blade.php
Level 102
Level 5
@Sinnbeck Thanks, It worked!!
Level 102
@david001 Happy to help. If its solved, please mark a best answer :)
1 like
Level 1
in windows i had this problem when running mysql
Solution
To solve this, you just need to add your port to the excluded list using these commands:
net stop winnat
netsh int ipv4 add excludedportrange protocol=tcp startport=3306 numberofports=1
net start winnat
after this run
docker run -p 3306:3306 -d --name mysql-ole-funde -e MYSQL_ROOT_PASSWORD=rootpassword -e MYSQL_DATABASE=mydatabase mysql:latest
working fine.
Please or to participate in this conversation.