php artisan migrate 找不到我的数据库

Question

我创建了名为 resume_manager 的 MySQL 数据库 我的数据库用户名是 root 密码是 password 但是当我运行 php artisan迁移 显示以下错误消息。

 Illuminate\Database\QueryException  : SQLSTATE[HY000] [1049] Unknown database 'resume_manager' (SQL: select * from information_schema.tables where table_schema = resume_manager and table_name = migrations)

  at /home/geralt/Music/resume-manager/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
    660|         // If an exception occurs when attempting to run a query, we'll format the error
    661|         // message to include the bindings with SQL, which will make this exception a
    662|         // lot more helpful to the developer instead of just the database's errors.
    663|         catch (Exception $e) {
  > 664|             throw new QueryException(
    665|                 $query, $this->prepareBindings($bindings), $e
    666|             );
    667|         }
    668| 

  Exception trace:

  1   PDOException::("SQLSTATE[HY000] [1049] Unknown database 'resume_manager'")
      /home/geralt/Music/resume-manager/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68

  2   PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=resume_manager", "root", "password", [])
      /home/geralt/Music/resume-manager/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68

  Please use the argument -v to see more details.

我在 Xampp 上运行 MySQL。我检查过 my.cnf 文件端口设置为默认 3306我不知道发生了什么。顺便说一句，我正在使用 Linux Mint。我还运行了所有关于 cache

的命令

          php artisan cache:clear
          php artisan route:cache
          php artisan config:clear
          php artisan view:clear

这是我的.env 文件设置:

APP_NAME=Laravel
APP_ENV=local
APP_KEY=
APP_DEBUG=true
APP_URL=http://localhost

LOG_CHANNEL=stack

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=resume_manager
DB_USERNAME=root
DB_PASSWORD=password

BROADCAST_DRIVER=log
CACHE_DRIVER=file
SESSION_DRIVER=file
SESSION_LIFETIME=120
QUEUE_DRIVER=sync

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_DRIVER=smtp
MAIL_HOST=smtp.mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null

PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=
PUSHER_APP_CLUSTER=mt1

MIX_PUSHER_APP_KEY="${PUSHER_APP_KEY}"
MIX_PUSHER_APP_CLUSTER="${PUSHER_APP_CLUSTER}"

Answer 1

从错误中可以确定您的端口没有问题，用户名和密码都是正确的...所以只需仔细检查 resume_manager 是否存在；

简单地转到你的 mysql 控制台并创建一个空数据库

mysql> CREATE DATABASE resume_manager;

---

或

你也使用 phpmyadmin 做同样的事情...

如果数据库已经存在，它将给出错误，否则将创建新的所需数据库...(您的旧数据库名称中可能存在一些拼写错误)