Laravel – SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables….

- Advertisement -

SQLSTATE[HY000] [2002] No such file or directory  

While setting up MySQL, I am getting the following error:

- Advertisement -

Command-line code: testLaravel1 php artisan migrate

SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema

Error:

- Advertisement -

Illuminate\Database\QueryException

SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testLaravel2020 and table_name = migrations and table_type = ‘BASE TABLE’)

at vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
667▕ // If an exception occurs when attempting to run a query, we’ll format the error
668▕ // message to include the bindings with SQL, which will make this exception a
669▕ // lot more helpful to the developer instead of just the database’s errors.
670▕ catch (Exception $e) {
➜ 671▕ throw new QueryException(
672▕ $query, $this->prepareBindings($bindings), $e
673▕ );
674▕ }
675▕

+33 vendor frames
34 artisan:37
Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

FIX:

This error happen when we use MAMP server in Mac mostly.

So:
I am using Mamp and Laravel 8. My database.php has this line under the MySQL directive:

‘unix_socket’ => env(‘DB_SOCKET’, ”),

The solution was to add the DB_SOCKET option which was missing on the environment file:

DB_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock

finally, the  line should be:

‘unix_socket’ => env(‘DB_SOCKET’, ”),     to

‘unix_socket’ => env(‘DB_SOCKET’, ‘/Applications/MAMP/tmp/mysql/mysql.sock’),
Search Terms:

hy000, sqlstate hy000, hy000 mysql, mysql hy000, laravel mysql server has gone away, mysql server has gone away laravel, sqlstate hy000 laravel, sql hy000, drupal mysql server has gone away, mysql 1114 the table is full, hy000 odbc, mysql 1114 table is full, 2054 mysql

- Advertisement -

Share it with friends:

Related Articles

Laravel – SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables….

SQLSTATE No such file or directory   While setting up MySQL, I am getting the following error: Command-line code: testLaravel1 php artisan migrate SQLSTATE No such...

How to create best Bootstrap FAQ template? [Full Source Code]

Bootstrap FAQ Bootsrap Frequently Asked Questions. bootstrap faq, bootstrap faq template, bootstrap 4 faq template, bootstrap 3 faq template, bootstrap compost faq, faq in...

Old Instagram Logo with HTML and CSS quality logo

Create the Old Instagram Logo by HTML and CSS. Old Instagram Logo CSS  for new style Instagram logo  logo.html <div class="Instagram"> <span class="Instagram-strip"></span> <span class="Instagram-viewfinder"></span> ...

Chrome plans to start blocking resource-heavy ads in August Update

Chrome plans to start blocking resource-heavy ads that drain a lot of battery in August, Google announced today on its Chromium blog (via VentureBeat). Chrome...

How to create Sitemaps on Blogger for Google and Bing

Create Sitemaps on Blogger The XML Sitemap file is like a directory of all web pages that exist on your website or blog. Google,...

How to speed up WordPress with Plesk and WP Super Cache, WP Rocket, Autoptimize Free

https://websavers.ca/how-to-speed-up-wordpress   This guide includes 9 tips to show you how to take just about any WordPress site to a maximum 1-2 seconds load time. If you’ve...

Get in Touch

163FansLike
115FollowersFollow

Latest Posts

Laravel – SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables….

SQLSTATE No such file or directory   While setting up MySQL, I am getting the following error: Command-line code: testLaravel1 php artisan migrate SQLSTATE No such...

How to create best Bootstrap FAQ template? [Full Source Code]

Bootstrap FAQ Bootsrap Frequently Asked Questions. bootstrap faq, bootstrap faq template, bootstrap 4 faq template, bootstrap 3 faq template, bootstrap compost faq, faq in...

Old Instagram Logo with HTML and CSS quality logo

Create the Old Instagram Logo by HTML and CSS. Old Instagram Logo CSS  for new style Instagram logo  logo.html <div class="Instagram"> <span class="Instagram-strip"></span> <span class="Instagram-viewfinder"></span> ...

Chrome plans to start blocking resource-heavy ads in August Update

Chrome plans to start blocking resource-heavy ads that drain a lot of battery in August, Google announced today on its Chromium blog (via VentureBeat). Chrome...

How to create Sitemaps on Blogger for Google and Bing

Create Sitemaps on Blogger The XML Sitemap file is like a directory of all web pages that exist on your website or blog. Google,...

Popular Posts

This is the proposed SpaceX internet plan. WOW

Sometime in 2019, SpaceX will be launching the first of its proposed 4000 satellites to provide ultra-high speed internet to the entire world. This is...

Instagram Logo CSS gradient with HTML best 2 quality logo

The new Instagram logo create by CSS gradient. Read more about Gradient here Instagram logo CSS and HTML Method - 1 logo.html &lt;link rel="stylesheet" href="//maxcdn.bootstrapcdn. com/font-awesome/4.3.0/css/font-awesome.min.css"&gt; &lt;span class="instagram"&gt; ...

Failed to execute ‘postMessage’ on ‘DOMWindow’: https://www.accounts.google.com !== http://yourdoamin.com

Failed to execute 'postMessage' on 'DOMWindow': The target origin provided ('https://accounts.google.com') does not match the recipient window's origin ('https://www.yourdomain.com') What is the problem actually? How to...

DB import failure at CREATE ALGORITHM = UNDEFINED DEFINER Error: #1227 – Access denied – Fixed

CREATE ALGORITHM=UNDEFINED [email protected]`%` SQL SECURITY INVOKER VIEW...  When import the SQL file from localhost to remote server, if the server is shared or not given...

XAMPP Port 443 ERROR in Windows with VMware

When we used XAMPP and VM Ware or any Virtual machine on the same PC we can't run XAMPP or WAMP properly because Virtual machine...