Level 34
@pefremidis because there is no root/root on your Sail setup.
May I know why you are changing the defaults? Did you intend to use a MySQL DB outside Sail?
Apr 10, 2021
10
Level 27
Laravel sail change db username and password?
Hello I downloaded a fresh laravel 8 application and I am using sail By default the .env file that was created has
DB_USERNAME=sail DB_PASSWORD=password
but I need to change these and use my own
How is this possible?
for now I am simply trying to change them to root/root and I get Access denied for user 'root'@...
Level 27
I have multiple sites that use sail and each one has its own defaults for username and password. So when I am changing projects it is annoying to switch credentials in order to connect with table plus for example
Level 34
@pefremidis Sail only gets the credentials on your .env file, so change your .env file first and rebuild your sail using:
sail build --no-cache
sail up -d
And root/root should work.
Level 27
Nop still nothing
Level 34
@pefremidis hmm, it must be the volume, try:
sail down -v
sail build --no-cache
sail up -d
18 likes
Level 27
Oh everything is ok now!
Thanks
Level 1
Wowwww. I lost half day trying to resolve this. Thx @neilstee !!!!
1 like
Level 1
@neilstee Thank you my friend, that worked for me !
1 like
Level 39
I don't understand your pb, therei is nothing special to do normally, the values you define in .env are taken by docker compose and so by sail cde
It works without pb for me with postgresql.
Level 1
If anyone is still having issues I'd like to add on top of @neilstee's answer.
sail down -v
sail up -d
sail artisan config:cache
sail artisan migrate
5 likes
Please or to participate in this conversation.