Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

Devpat's avatar

error when using php artisan migrate in laravel 5.7 in ubuntu docker c

Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = course_discovery and table_name = migrations)

at /var/www/html/project/courseDiscovery/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] [1698] Access denied for user 'root'@'localhost'") /var/www/html/project/courseDiscovery/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68

2 PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=course_discovery", "root", "", []) /var/www/html/project/courseDiscovery/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68

0 likes
2 replies
aurawindsurfing's avatar

Are you sure credentials are correct for new docker instance:

mysql:host=127.0.0.1;port=3306;dbname=course_discovery", "root", "", []

Can you connect to DB from outside? Using this ip:

docker-machine ip default

I also had once problem in JetBrains as they did not update to the newest MySQL driver and needed to downgrade to connect.

Maybe it is one of those?

Hope it helps!

Devpat's avatar

all good now. problem is in my php. need to set

extension=pdo.so extension=pdo_mysql.so

in php.ini file.

as well as delete the root user and make one again.

Please or to participate in this conversation.