Laravel - How to create database tables

Question

I'm having problems to create database tables.

First of all I create the models:

php artisan make:model Company -m

Second I update the migration company file, adding the columns that I need

Third I'm going to phpMyAdmin and create a new database named test

Fourth I run the command php artisan migrate or php artisan migrate:install and I have the next error:

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

[PDOException]SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

In database/config.php I edit the mysql driver to this:

'mysql' => [
        'driver' => 'mysql',
        'host' => env('DB_HOST', 'localhost'),
        'port' => env('DB_PORT', '3306'),
        'database' => env('DB_DATABASE', 'test'),
        'username' => env('DB_USERNAME', 'root'),
        'password' => env('DB_PASSWORD', 'pass'),
        'charset' => 'utf8',
        'collation' => 'utf8_general_ci',
        'prefix' => '',
        'strict' => true,
        'engine' => null,
    ],

And .env file:

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=test
DB_USERNAME=root
DB_PASSWORD=pass

I also tried to clean cache with php artisan config:clear .

Anyone can help me? I don't understand what is the problem.

Thank you

you dont have password to login to phpmyadmin. remove the password, keep it blank in the env file — Exprator, Jul 17 '17 at 10:27
@Exprator phpmyadmin has nothing to do with it, and btw mysql is configured to use a password for that user. Which likely is wrong — Damien Pirsy, Jul 17 '17 at 10:28
@DamienPirsy - There is a lack of information, the OP did not state if he is using Windows/Linux and anything related to his MySql installation/configuration. We need to "blind" guess here :) — Mecanik, Jul 17 '17 at 10:32

Mecanik · Answer 1 · 2017-07-17T10:37:04.203

0

Your "root" password is incorrect or it may not have required permissions.

[PDOException]SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

Reset "root" password:

https://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords

Grant "root" user privileges:

Ubuntu: https://www.liquidweb.com/kb/how-to-add-a-user-and-grant-root-privileges-on-ubuntu-14-04/

Centos: https://www.liquidweb.com/kb/how-to-add-a-user-and-grant-root-privileges-on-centos-7/

Then try again :)

Update for the OP ( OSX ):

Setting the MySQL root user password on OS X

edited Jul 17 '17 at 10:37

answered Jul 17 '17 at 10:30

Mecanik

1,539
1
20
50

I think that it tries to create the migrations table in information_schema... It's normal? @NorbertBoros – user3242861 Jul 17 '17 at 10:42
@user3242861 - It should not do that... Does the connection work now ? – Mecanik Jul 17 '17 at 10:42
Does this happen because I have only defined the connection after creating the migrations? @NorbertBoros – user3242861 Jul 17 '17 at 10:50
@user3242861 - Probably yes, but I see that you have fixed your issue. You should accept my answer for fixing the connectiong :) – Mecanik Jul 17 '17 at 12:09

score 0 · Answer 2 · answered Jul 17 '17 at 10:30

0

in config/database.php file edit the password field to "password' => env('DB_PASSWORD', ''), and in .env file DB_PASSWORD = keep the field as empty as given here

answered Jul 17 '17 at 10:30

Mutasim Fuad

606
2
12
31

How do you know he doesn't use a password ? – Mecanik Jul 17 '17 at 10:31

Laravel - How to create database tables

2 Answers2