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

Atrexian's avatar

local.ERROR: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

Hello I am trying to install my laravel script but I am getting "Whooops, something went wrong!" on my site. My logs:

[2022-06-19 07:09:01] local.ERROR: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from settings where settings.name = license limit 1) {"exception":"[object] (Illuminate\Database\QueryException(code: 1698): SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from settings where settings.name = license limit 1) at /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connection.php:742) [stacktrace] #0 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connection.php(702): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connection.php(404): Illuminate\Database\Connection->run() #2 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2630): Illuminate\Database\Connection->select() #3 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2618): Illuminate\Database\Query\Builder->runSelect() #4 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3154): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\Database\Query\Builder->onceWithColumns() #6 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(698): Illuminate\Database\Query\Builder->get() #7 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(682): Illuminate\Database\Eloquent\Builder->getModels() #8 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get() #9 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(430): Illuminate\Database\Eloquent\Builder->first() #10 /var/www/web/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->find() #11 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2163): Illuminate\Database\Eloquent\Model->forwardCallTo() #12 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2175): Illuminate\Database\Eloquent\Model->__call() #13 /var/www/web/src/Support/helpers.php(142): Illuminate\Database\Eloquent\Model::__callStatic() #14 /var/www/web/src/Support/Upgrading/Actions/UpdateSystemAction.php(72): get_settings() #15 /var/www/web/src/Support/Upgrading/Actions/UpdateSystemAction.php(18): Support\Upgrading\Actions\UpdateSystemAction->shouldUpdateTranslations() #16 /var/www/web/src/App/Console/Kernel.php(61): Support\Upgrading\Actions\UpdateSystemAction->__invoke() #17 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Kernel->App\Console\{closure}() #18 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Closure->__invoke() #19 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #20 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #21 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #22 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/Container.php(651): Illuminate\Container\BoundMethod::call() #23 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Scheduling/CallbackEvent.php(118): Illuminate\Container\Container->call() #24 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Scheduling/Event.php(230): Illuminate\Console\Scheduling\CallbackEvent->execute() #25 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Scheduling/Event.php(200): Illuminate\Console\Scheduling\Event->start() #26 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Scheduling/CallbackEvent.php(77): Illuminate\Console\Scheduling\Event->run() #27 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Scheduling/ScheduleRunCommand.php(156): Illuminate\Console\Scheduling\CallbackEvent->run() #28 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Scheduling/ScheduleRunCommand.php(115): Illuminate\Console\Scheduling\ScheduleRunCommand->runEvent() #29 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Console\Scheduling\ScheduleRunCommand->handle() #30 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #31 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #32 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #33 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/Container.php(651): Illuminate\Container\BoundMethod::call() #34 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\Container\Container->call() #35 /var/www/web/vendor/symfony/console/Command/Command.php(308): Illuminate\Console\Command->execute() #36 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run() #37 /var/www/web/vendor/symfony/console/Application.php(998): Illuminate\Console\Command->run() #38 /var/www/web/vendor/symfony/console/Application.php(299): Symfony\Component\Console\Application->doRunCommand() #39 /var/www/web/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun() #40 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run() #41 /var/www/web/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\Console\Application->run() #42 /var/www/web/artisan(37): Illuminate\Foundation\Console\Kernel->handle() #43 {main}

[previous exception] [object] (Doctrine\DBAL\Driver\PDO\Exception(code: 1698): SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' at /var/www/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18) [stacktrace] #0 /var/www/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(44): Doctrine\DBAL\Driver\PDO\Exception::new() #1 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct() #2 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection() #3 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection() #4 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect() #5 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}() #6 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1084): call_user_func() #7 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1120): Illuminate\Database\Connection->getPdo() #8 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connection.php(468): Illuminate\Database\Connection->getReadPdo() #9 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connection.php(396): Illuminate\Database\Connection->getPdoForSelect() #10 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connection.php(735): Illuminate\Database\Connection->Illuminate\Database\{closure}() #11 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connection.php(702): Illuminate\Database\Connection->runQueryCallback() #12 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connection.php(404): Illuminate\Database\Connection->run() #13 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2630): Illuminate\Database\Connection->select() #14 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2618): Illuminate\Database\Query\Builder->runSelect() #15 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3154): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #16 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\Database\Query\Builder->onceWithColumns() #17 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(698): Illuminate\Database\Query\Builder->get() #18 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(682): Illuminate\Database\Eloquent\Builder->getModels() #19 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\Database\Eloquent\Builder->get() #20 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(430): Illuminate\Database\Eloquent\Builder->first() #21 /var/www/web/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->find() #22 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2163): Illuminate\Database\Eloquent\Model->forwardCallTo() #23 /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2175): Illuminate\Database\Eloquent\Model->__call() #24 /var/www/web/src/Support/helpers.php(142): Illuminate\Database\Eloquent\Model::__callStatic() #25 /var/www/web/src/Support/Upgrading/Actions/UpdateSystemAction.php(72): get_settings() #26 /var/www/web/src/Support/Upgrading/Actions/UpdateSystemAction.php(18): Support\Upgrading\Actions\UpdateSystemAction->shouldUpdateTranslations() #27 /var/www/web/src/App/Console/Kernel.php(61): Support\Upgrading\Actions\UpdateSystemAction->__invoke() #28 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Kernel->App\Console\{closure}() #29 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Closure->__invoke() #30 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #31 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #32 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #33 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/Container.php(651): Illuminate\Container\BoundMethod::call() #34 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Scheduling/CallbackEvent.php(118): Illuminate\Container\Container->call() #35 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Scheduling/Event.php(230): Illuminate\Console\Scheduling\CallbackEvent->execute() #36 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Scheduling/Event.php(200): Illuminate\Console\Scheduling\Event->start() #37 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Scheduling/CallbackEvent.php(77): Illuminate\Console\Scheduling\Event->run() #38 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Scheduling/ScheduleRunCommand.php(156): Illuminate\Console\Scheduling\CallbackEvent->run() #39 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Scheduling/ScheduleRunCommand.php(115): Illuminate\Console\Scheduling\ScheduleRunCommand->runEvent() #40 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Console\Scheduling\ScheduleRunCommand->handle() #41 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #42 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #43 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #44 /var/www/web/vendor/laravel/framework/src/Illuminate/Container/Container.php(651): Illuminate\Container\BoundMethod::call() #45 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\Container\Container->call() #46 /var/www/web/vendor/symfony/console/Command/Command.php(308): Illuminate\Console\Command->execute() #47 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run() #48 /var/www/web/vendor/symfony/console/Application.php(998): Illuminate\Console\Command->run() #49 /var/www/web/vendor/symfony/console/Application.php(299): Symfony\Component\Console\Application->doRunCommand() #50 /var/www/web/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun() #51 /var/www/web/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\Component\Console\Application->run() #52 /var/www/web/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\Console\Application->run() #53 /var/www/web/artisan(37): Illuminate\Foundation\Console\Kernel->handle() #54 {main}

0 likes
11 replies
tisuchi's avatar

@atrexian Make sure you have set the right value for DB connection in the .env file.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=
1 like
Atrexian's avatar

@tisuchi Thanks. Now I am getting error: local.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel.shares' doesn't exist

tisuchi's avatar

@Atrexian

Alternatively, try this-

php artisan migrate:refresh

And make sure that you have database is exists already.

1 like
Atrexian's avatar

@tisuchi Done that. It shows setup wizard so I installed that but still same problem. I have created Database laravel and user root has full privilegies

tisuchi's avatar

@Atrexian

Now I am getting error: local.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel.shares' doesn't exist

If you mean that you are facing the same issue, then make sure that you have a migration file for shares table.

It seems that you don't have shares table.

Atrexian's avatar

@tisuchi Mrigration:

Illuminate\Database\QueryException

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'favourite_folder' already exists (SQL: create table favourite_folder (user_id char(36) not null, parent_id char(36) not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

at vendor/laravel/framework/src/Illuminate/Database/Connection.php:742 738▕ // If an exception occurs when attempting to run a query, we'll format the error 739▕ // message to include the bindings with SQL, which will make this exception a 740▕ // lot more helpful to the developer instead of just the database's errors. 741▕ catch (Exception $e) { ➜ 742▕ throw new QueryException( 743▕ $query, $this->prepareBindings($bindings), $e 744▕ ); 745▕ } 746▕ }

  +12 vendor frames

13 database/migrations/2020_03_03_070319_create_favourites_folders_table.php:21 Illuminate\Support\Facades\Facade::__callStatic()

  +33 vendor frames

47 artisan:37 Illuminate\Foundation\Console\Kernel::handle()

Please or to participate in this conversation.