帶下劃線“_”數(shù)據(jù)庫名“test_park”的數(shù)據(jù)庫識別不了,無其他符號的數(shù)據(jù)庫“test”識別成功,兩個數(shù)據(jù)庫配置一樣
數(shù)據(jù)庫設(shè)置
return [
// 默認(rèn)數(shù)據(jù)庫
'default' => 'mysql',
'connections' => [
'mysql' => [
'driver' => 'mysql',
'host' => '127.0.0.1',
'port' => 3306,
'database' => 'test_park',
'username' => 'root',
'password' => '123456',
'unix_socket' => '',
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_general_ci',
'prefix' => '',
'strict' => true,
'engine' => null,
],
]
];
PDOException: SQLSTATE[HY000] [1049] Unknown database 'test_park' in E:\MXJK_GitLab\webman\vendor\illuminate\database\Connectors\Connector.php:70
Stack trace:
#0 E:\MXJK_GitLab\webman\vendor\illuminate\database\Connectors\Connector.php(70): PDO->__construct('mysql:host=127....', 'root', '123456', Array)
#1 E:\MXJK_GitLab\webman\vendor\illuminate\database\Connectors\Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection('mysql:host=127....', 'root', '123456', Array)
#2 E:\MXJK_GitLab\webman\vendor\illuminate\database\Connectors\MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection('mysql:host=127....', Array, Array)
#3 E:\MXJK_GitLab\webman\vendor\illuminate\database\Connectors\ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect(Array)
#4 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
#5 E:\MXJK_GitLab\webman\vendor\illuminate\database\Connection.php(1064): call_user_func(Object(Closure))
#6 E:\MXJK_GitLab\webman\vendor\illuminate\database\Connection.php(1100): Illuminate\Database\Connection->getPdo()
#7 E:\MXJK_GitLab\webman\vendor\illuminate\database\Connection.php(442): Illuminate\Database\Connection->getReadPdo()
#8 E:\MXJK_GitLab\webman\vendor\illuminate\database\Connection.php(368): Illuminate\Database\Connection->getPdoForSelect(true)
#9 E:\MXJK_GitLab\webman\vendor\illuminate\database\Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}('select `name` f...', Array)
#10 E:\MXJK_GitLab\webman\vendor\illuminate\database\Connection.php(672): Illuminate\Database\Connection->runQueryCallback('select `name` f...', Array, Object(Closure))
#11 E:\MXJK_GitLab\webman\vendor\illuminate\database\Connection.php(376): Illuminate\Database\Connection->run('select `name` f...', Array, Object(Closure))
#12 E:\MXJK_GitLab\webman\vendor\illuminate\database\Query\Builder.php(2414): Illuminate\Database\Connection->select('select `name` f...', Array, true)
#13 E:\MXJK_GitLab\webman\vendor\illuminate\database\Query\Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#14 E:\MXJK_GitLab\webman\vendor\illuminate\database\Query\Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#15 E:\MXJK_GitLab\webman\vendor\illuminate\database\Query\Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#16 E:\MXJK_GitLab\webman\vendor\illuminate\database\Concerns\BuildsQueries.php(294): Illuminate\Database\Query\Builder->get(Array)
#17 E:\MXJK_GitLab\webman\vendor\illuminate\database\Query\Builder.php(2388): Illuminate\Database\Query\Builder->first(Array)
#18 E:\MXJK_GitLab\webman\app\api\controller\IndexController.php(19): Illuminate\Database\Query\Builder->value('name')
#19 E:\MXJK_GitLab\webman\vendor\workerman\webman-framework\src\App.php(293): app\api\controller\IndexController->index(Object(support\Request))
#20 E:\MXJK_GitLab\webman\vendor\workerman\webman-framework\src\App.php(147): Webman\App::Webman\{closure}(Object(support\Request))
#21 E:\MXJK_GitLab\webman\vendor\workerman\workerman\Connection\TcpConnection.php(638): Webman\App->onMessage(Object(Workerman\Connection\TcpConnection), Object(support\Request))
#22 E:\MXJK_GitLab\webman\vendor\workerman\workerman\Events\Select.php(311): Workerman\Connection\TcpConnection->baseRead(Resource id #153)
#23 E:\MXJK_GitLab\webman\vendor\workerman\workerman\Worker.php(2467): Workerman\Events\Select->loop()
#24 E:\MXJK_GitLab\webman\vendor\workerman\workerman\Worker.php(1453): Workerman\Worker->run()
#25 E:\MXJK_GitLab\webman\vendor\workerman\workerman\Worker.php(1396): Workerman\Worker::forkWorkersForWindows()
#26 E:\MXJK_GitLab\webman\vendor\workerman\workerman\Worker.php(560): Workerman\Worker::forkWorkers()
#27 E:\MXJK_GitLab\webman\vendor\workerman\webman-framework\src\support\App.php(124): Workerman\Worker::runAll()
#28 E:\MXJK_GitLab\webman\start.php(4): support\App::run()
#29 {main}
這里粘貼截圖
這里寫系統(tǒng)環(huán)境相關(guān)信息
win10 mysql5.7 php7.3
"workerman/webman-framework": "^1.4.3",
"monolog/monolog": "^2.0",
"psr/container": "1.1.1",
"illuminate/redis": "^8.83",
"illuminate/events": "^8.83",
"phpoffice/phpspreadsheet": "^1.25",
"illuminate/database": "^8.83",
"illuminate/pagination": "^8.83",
"symfony/var-dumper": "^5.4"
執(zhí)行 mysql -h127.0.0.1 -uroot -p
輸入密碼,進(jìn)入mysql命令行,執(zhí)行 show databases;
或者 use test_park;
,看下數(shù)據(jù)庫是否存在。這種基本都是自己的低級錯誤,自己簡單定位下就出來了。數(shù)據(jù)庫不存在就是不存在,代碼不會騙人,只有自己騙了自己。