I'm trying to run php artisan migrate and it throws errors related to being unable to connect to the mysql database. I have laravel, composer, and valet running on Ubuntu 18.04. I also tried.This is similar to this question but my situation is a little different.
Laravel mysql deadlock pdoexception vs queryexception Patch#
Obviously, short of providing an appropriate patch to PHP, you are not the only one to eventually switch back to 'mysql_native_password' auth strategy on your DB server.Ġ20-03-11T22:25:40.586329Z 0 /usr/local/mysql-8.0.19-macos10.15-x86_64/bin/mysqld (mysqld 8.0.19) starting as process 18261 The PHP mysqli requirements page still says caching_sha2_password plugin will be supported in a future PHP release, so no PHP version seems to support caching_sha2_password. SQLSTATE The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = coffee_hoarder and table_name = migrations and table_type = 'BASE TABLE')
Is there a pull request to support this in Laravel? Is it a PHP limitation? Mysql_native_password is the traditional method to authenticate, it is not very secure (it uses just a hash of the password), but it is compatible with older drivers. How come all the solutions suggested imply changing the behavior of the database?
Illuminate\Database\QueryException : SQLSTATE The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = homestead and table_name = migrations)Īt C:\MAMP\htdocs\bloger\vendor\laravel\framework\src\Illuminate\Database\Connection.php:664Ĭ:\MAMP\htdocs\bloger\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:70Ģ PDO::_construct("mysql:host=127.0.0.1 port=3306 dbname=homestead", "homestead", "secret", ) Please use the argument -v to see more details. var/www/localhost/htdocs/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68Ģ PDO::_construct("mysql:host=db port=3306 dbname=wbc_wallet", "root", "", ) Illuminate\Database\QueryException : SQLSTATE The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = wbc_wallet and table_name = migrations)Īt /var/$query, $this->prepareBindings($bindings), $eġ PDOException::("PDO::_construct(): The server requested authentication method unknown to the client ")
0 kommentar(er)
