Laravel Sail部署Fedora服务器时'sail'用户MySQL访问权限问题

本地使用Laravel Sail开发时所有功能（包括artisan migrate）正常，但在Fedora服务器通过反向代理部署后，执行./vendor/bin/sail artisan migrate时出现MySQL权限错误：

SQLSTATE[HY000] [1045] Access denied for user 'sail'@'192.168.160.3' (using password: YES) (Connection: mysql, SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')

at vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
756▕         // If an exception occurs when attempting to run a query, we'll format the error
757▕         // message to include the bindings with SQL, which will make this exception a
758▕         // lot more helpful to the developer instead of just the database's errors.
759▕         catch (Exception $e) {
➜ 760▕             throw new QueryException(
761▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
762▕             );
763▕         }
764▕     }

服务器操作流程 #

• SSH登录服务器
• 编辑/etc/caddy/Caddyfile，添加反向代理配置：project.domaine { reverse_proxy http://0.0.0.0:80 }
• 重启Caddy服务
• 创建项目目录并克隆代码仓库
• 执行composer install
• 构建并启动Sail容器
• 解决存储权限问题后项目可正常访问，但执行迁移时出现上述权限错误。

现有配置 #

.env 文件 #

APP_NAME=Laravel
APP_ENV=local
APP_KEY=base64:ZeM4sQDei27icN6cC1GJMpIAekJAv/yLBp+6c7vjTkc=
APP_DEBUG=true
APP_URL=http://localhost
APP_PORT=80

LOG_CHANNEL=stack
LOG_DEPRECATIONS_CHANNEL=null
LOG_LEVEL=debug

DB_CONNECTION=mysql
#DB_HOST=host.docker.internal.  i try to  
DB_HOST=mysql 
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=sail
DB_PASSWORD=password

docker-compose.yml 文件 #

version: '3'
services:
    laravel.test:
        build:
            context: ./vendor/laravel/sail/runtimes/8.2
            dockerfile: Dockerfile
            args:
                WWWGROUP: '${WWWGROUP}'
        image: sail-8.2/app
        extra_hosts:
            - 'host.docker.internal:host-gateway'
        ports:
            - '${APP_PORT:-80}:80'
            - '${VITE_PORT:-5173}:${VITE_PORT:-5173}'
        environment:
            WWWUSER: '${WWWUSER}'
            LARAVEL_SAIL: 1
            XDEBUG_MODE: '${SAIL_XDEBUG_MODE:-off}'
            XDEBUG_CONFIG: '${SAIL_XDEBUG_CONFIG:-client_host=host.docker.internal}'
        volumes:
            - '.:/var/www/html'
        networks:
            - sail
        depends_on:
            - mysql
    mysql:
        image: 'mysql/mysql-server:8.0'
        ports:
            - '${FORWARD_DB_PORT:-3306}:3306'
        environment:
            MYSQL_ROOT_PASSWORD: '${DB_PASSWORD}'
            MYSQL_ROOT_HOST: '%'
            MYSQL_DATABASE: '${DB_DATABASE}'
            MYSQL_USER: '${DB_USERNAME}'
            MYSQL_PASSWORD: '${DB_PASSWORD}'
            MYSQL_ALLOW_EMPTY_PASSWORD: 1
        volumes:
            - 'sail-mysql:/var/lib/mysql'
            - './vendor/laravel/sail/database/mysql/create-testing-database.sh:/docker-entrypoint-initdb.d/10-create-testing-database.sh'
        networks:
            - sail
        healthcheck:
            test:
                - CMD
                - mysqladmin
                - ping
                - '-p${DB_PASSWORD}'
            retries: 3
            timeout: 5s
networks:
    sail:
        driver: bridge
volumes:
    sail-mysql:
        driver: local

针对性解决方案 #

1. 重置MySQL数据卷

   • 停止容器并删除现有MySQL数据卷（会清空数据库数据，需提前备份）：

     ./vendor/bin/sail down -v
     

   • 重新启动容器，让MySQL重新初始化用户和数据库：

     ./vendor/bin/sail up -d
     

2. 验证并修复数据库用户权限

   • 进入MySQL容器：

     ./vendor/bin/sail mysql -u root -p
     

   • 输入.env中的DB_PASSWORD（即password）登录后，执行命令查看sail用户权限：

     SELECT user, host FROM mysql.user WHERE user = 'sail';
     SHOW GRANTS FOR 'sail'@'%';
     

   • 如果sail用户的host不是%，执行以下命令更新权限：

     CREATE USER IF NOT EXISTS 'sail'@'%' IDENTIFIED BY 'password';
     GRANT ALL PRIVILEGES ON laravel.* TO 'sail'@'%';
     FLUSH PRIVILEGES;
     

3. 修正MySQL环境变量冲突

   • 移除docker-compose.yml中MySQL配置里的MYSQL_ALLOW_EMPTY_PASSWORD: 1，该配置与MYSQL_ROOT_PASSWORD冲突会导致初始化异常：

     environment:
         MYSQL_ROOT_PASSWORD: '${DB_PASSWORD}'
         MYSQL_ROOT_HOST: '%'
         MYSQL_DATABASE: '${DB_DATABASE}'
         MYSQL_USER: '${DB_USERNAME}'
         MYSQL_PASSWORD: '${DB_PASSWORD}'
         # 移除此行：MYSQL_ALLOW_EMPTY_PASSWORD: 1
     

   • 修改后重新创建容器：

     ./vendor/bin/sail down -v
     ./vendor/bin/sail up -d
     

4. 确认容器内.env配置生效

   • 进入Laravel容器检查数据库配置：

     ./vendor/bin/sail shell
     cat .env | grep DB_
     

   • 若配置不一致，重新构建镜像：

     ./vendor/bin/sail build --no-cache
     ./vendor/bin/sail up -d
     

5. 检查Docker网络连通性

   • 进入Laravel容器测试与MySQL容器的连通性：

     ./vendor/bin/sail shell
     ping mysql -c 3
     

   • 若无法连通，确认两个服务都在sail网络下后重启容器。

内容的提问来源于stack exchange，提问作者LarvePoire