Run this command in sail project folder:
docker-compose exec mysql bash
execute the mysql -u root -p command
provide the default password password
then executes
# May be any user created with sail docker-compose
#
GRANT ALL PRIVILEGES ON *.* TO '<sail-user-from-docker-compose-yml>'@'%';and
FLUSH PRIVILEGES;that`s it!
Thank you
Really helped me, thanks
My DB_USERNAME is "adam" and I can login with this user in mysql workbench (not with root). And this is also the sail user of docker-compose, right?
So when I login with "adam" in the container mysql -u adam -p they try to give me all PRIVILEGES then this is denied:
ERROR 1045 (28000): Access denied for user 'adam'@'%' (using password: YES)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'adam'@'%^C
Am I missing something?
My DB_USERNAME is "adam" and I can login with this user in mysql workbench (not with root). And this is also the sail user of docker-compose, right?
So when I login with "adam" in the container
mysql -u adam -pthey try to give me all PRIVILEGES then this is denied:ERROR 1045 (28000): Access denied for user 'adam'@'%' (using password: YES) mysql> GRANT ALL PRIVILEGES ON *.* TO 'adam'@'%^CAm I missing something?
You need login with root user and grant all privileges to your adam user. ;)
My DB_USERNAME is "adam" and I can login with this user in mysql workbench (not with root). And this is also the sail user of docker-compose, right?
So when I login with "adam" in the containermysql -u adam -pthey try to give me all PRIVILEGES then this is denied:ERROR 1045 (28000): Access denied for user 'adam'@'%' (using password: YES) mysql> GRANT ALL PRIVILEGES ON *.* TO 'adam'@'%^CAm I missing something?
You need login with root user and grant all privileges to your adam user. ;)
yes that worked and makes sense. I thought I don't have the password for root but then I spotted MYSQL_ROOT_PASSWORD is set to $db_password
Thank you a lot!
the .env content
APP_NAME=Laravel
APP_ENV=local
APP_KEY=base64:4sE3uAionWsXgJatwdc2JHHs/n1qcDOo/dTCglpCBnQ=
APP_DEBUG=true
APP_URL=http://backend-app.test
LOG_CHANNEL=stack
LOG_DEPRECATIONS_CHANNEL=null
LOG_LEVEL=debug
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=sail
DB_USERNAME=sail
DB_PASSWORD=123456
BROADCAST_DRIVER=log
CACHE_DRIVER=file
FILESYSTEM_DISK=local
QUEUE_CONNECTION=sync
SESSION_DRIVER=file
SESSION_LIFETIME=120
MEMCACHED_HOST=memcached
REDIS_HOST=redis
REDIS_PASSWORD=null
REDIS_PORT=6379
MAIL_MAILER=smtp
MAIL_HOST=mailhog
MAIL_PORT=1025
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
MAIL_FROM_ADDRESS="[email protected]"
MAIL_FROM_NAME="${APP_NAME}"
AWS_ACCESS_KEY_ID=
AWS_SECRET_ACCESS_KEY=
AWS_DEFAULT_REGION=us-east-1
AWS_BUCKET=
AWS_USE_PATH_STYLE_ENDPOINT=false
PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=
PUSHER_HOST=
PUSHER_PORT=443
PUSHER_SCHEME=https
PUSHER_APP_CLUSTER=mt1
VITE_PUSHER_APP_KEY="${PUSHER_APP_KEY}"
VITE_PUSHER_HOST="${PUSHER_HOST}"
VITE_PUSHER_PORT="${PUSHER_PORT}"
VITE_PUSHER_SCHEME="${PUSHER_SCHEME}"
VITE_PUSHER_APP_CLUSTER="${PUSHER_APP_CLUSTER}"
SCOUT_DRIVER=meilisearch
MEILISEARCH_HOST=http://meilisearch:7700
when I exec docker-compose exec mysql bash;docker-compose exec mysql bash; GRANT ALL PRIVILEGES ON *.* TO 'sail'@'%'; FLUSH PRIVILEGES; ;and then in sail project forder, exec ./vendor/bin/sail shell; mysql -u sail -p -h 127.0.0.1,give me an error information ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1:3306' (111); when exec mysql -u sail -p, given me an another error information ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2), how can I connect with DBvaear tool?
Thank you very much!
I can't thanks enough.
You made my day! Thanks
@WhiskeyM1ke make sure you use the right username in your MySQL command!
In case your
DB_USERNAMEis laravalor in case your
DB_USERNAMEis sailAlso, make sure to flush the privileges
and exit afterwards