No such file or directory when run php artisan migrate on ubuntu

Question

i moved my laravel project from windows to ubuntu, i did everything required ( installing php, composer ...) then when i run php artisan migrate to create my database tables, it says:

In Connection.php line 664:
                                                                             
 SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from informa  
 tion_schema.tables where table_schema = blog and table_name = migrations)     
                                                                               

In Connector.php line 68:
                                                   
 SQLSTATE[HY000] [2002] No such file or directory

PS: i was using WAMP server for my database in Windows.

my .env DB config:

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=blog
DB_USERNAME=blog
DB_PASSWORD=

have you tried access your phpMyAdmin ? – JEJ Sep 17 '21 at 11:20 — JEJ, Sep 17 '21 at 11:20

onifade boluwatife · Answer 1 · 2021-09-17T11:38:53.757

0

you are getting that error because php artisan migrate is trying to check the migration table from your database for the migration details, so it doesn't migrate old migrations files again, but since you want to create the tables afresh,

run this
php artisan migrate:fresh this would clear the database and create all table afresh

or run php artisan migrate:install this would create the migration table , then run php artisan migrate to create all other tables

edited Sep 17 '21 at 11:38

answered Sep 17 '21 at 11:22

onifade boluwatife

146
6

1

Please add some explanation to your answer such that others can learn from it – Nico Haase Sep 17 '21 at 11:23
also check to be sure you have created the database `blog` – onifade boluwatife Sep 17 '21 at 11:26
no i didn't create it , and when i run php artisan migrate:fresh it also says :SQLSTATE[HY000] [2002] No such file or directory (SQL: SHOW FULL TABLES WHER E table_type = 'BASE TABLE') – Seif Khédija Sep 17 '21 at 11:40
you have to create the database first before running the migrations – onifade boluwatife Sep 17 '21 at 11:47
is there any specific command to create my database named 'blog' please? – Seif Khédija Sep 17 '21 at 11:50
no you have to create it your self, either by going through your phpmyAdmin or through the mysql cli – onifade boluwatife Sep 17 '21 at 12:05

score 0 · Accepted Answer · answered Sep 17 '21 at 11:25

0

Your database seems to be missing the migrations table. You can create it by running

php artisan migrate:install

After that you will be able to run your migrations.

answered Sep 17 '21 at 11:25

brombeer

8,716
5
21
27

its says : Connection refused (SQL: create table `migrations` (` id` int unsigned not null auto_increment primary key, `migration` varchar(25 5) not null, `batch` int not null) default character set utf8mb4 collate 'ut f8mb4_unicode_ci') – Seif Khédija Sep 17 '21 at 11:37
You did create your database 'blog' first, right? You can use `phpMyAdmin` (if installed) to create it – brombeer Sep 17 '21 at 11:50
You'd also need to create your database user there, giving access to your database. – brombeer Sep 17 '21 at 11:52

score -2 · Answer 3 · edited Sep 17 '21 at 11:38

-2

Use 127.0.0.1 for DB_HOST
Run php artisan config:clear

edited Sep 17 '21 at 11:38

Dharman

30,962
25
85
135

answered Sep 17 '21 at 11:32

Isaya M Pombo

1
2

when i use ip adress it says : Connection refused instead no such file or directory – Seif Khédija Sep 17 '21 at 11:39
1

Always explain your answer. I'm curious what it would be when you suggest changing `localhost` to `127.0.0.1`... – Gert B. Sep 17 '21 at 12:27
Keep in mind that a good explanation helps others to learn from your answer – Nico Haase Sep 17 '21 at 17:07

No such file or directory when run php artisan migrate on ubuntu

3 Answers3