Laravel PDOException SQLSTATE HY000 1049 Unknown database forge

Question

I am using Laravel to connect to MySQL database   I got this exception   PDOException SQLSTATE HY000   1049  Unknown database  forge    and this is my config database php   mysql    gt  array               driver       gt   mysql                host         gt   localhost                database     gt   laravel                username     gt   Anastasie                password     gt   A Laurent                charset      gt   utf8                collation    gt   utf8 unicode ci                prefix       gt                   why is the error referring to PDO database  and why the forge database name  I have already changed it    Should I do anything to tell Laravel that I am using MySQL database   Update 1  I found this line protected  table    users   in my user php file and I have changed it to  protected  table    user   because the table in my database is user not users  Update 2  I wrote this in my Route  Route  resource  users    UsersController      and I added UsersController php in my controllers folder  and inside UsersController php I have this   class UsersController extends BaseController                   Display a listing of the resource                 return Response             public function index                  users   User  all            return View  make  users index   compact  users             and I call this url http   localhost 8082 laravel public users   I am using Windows 7 with Laravel 4 2  Thanks in advance

User · Answer

I had the same problem    If you have set your DB name and username and pass correctly in  env file and its still not working run the blow code in terminal  this will clean the caches that left from previous apps   php artisan cache clear   and then run the command php artisan serve again  if you are running it stop and run it again

User · Answer

You need to modify the name of the DB in the file  env  and if need in  env example  I solved my problem with this little correction

User · Answer

Using phpMyAdmin  or whatever you prefer   I just created a database called  forge  and re-ran the php artisan migrate command and it all worked

User · Answer

Stop the server then run php artisan cache clear  Change  env file DB PORT 3308  3308 For me  mysql port

User · Answer

clear your Cache php artisan cache clear and then restart your server php artisan serve 127 0 0 1 8000

User · Answer

I had this problem for several days  it turns out if I created the db inside phpMyAdmin it wouldn t appear to Laravel  so  I created the db through MySqlWorkbench  and it worked

User · Answer

Sounds like you have an environment-specific config file somewhere that overrides the default database settings  Possibly app config local database php

User · Answer

Make sure you do not have a duplicated  env file in the laravel folder  If it exists  delete it  Only keep the  env file

User · Answer

If you ve used Homestead  make sure the database name in your  env file below  DB DATABASE homestead   Is the same as the value in your Homestead yaml file   databases      - homestead

User · Answer

In my case the error was due to incorrect port number  the error is definitely due to incorrect credentials i e  host port dbname username password   Solution   right click on WAMP tray  click  drag your cursor  on MySQL  see the port number used by MySQL  add same in your Laravel configuration    env file  config database php     Clear cache php artisan config cache Run migration php artisan migrate

User · Answer

OK  found solution    In the file database php  by default  it comes the  mysql  part     mysql    gt                 driver    gt   mysql                host    gt  env  DB HOST    127 0 0 1                 port    gt  env  DB PORT    3306                 database    gt  env  DB DATABASE    forge                 username    gt  env  DB USERNAME    forge                 password    gt  env  DB PASSWORD                     charset    gt   utf8mb4                collation    gt   utf8mb4 unicode ci                prefix    gt                   strict    gt  true               engine    gt  null               all you need to do is change the values     database    gt  env  DB DATABASE    forge     username    gt  env  DB USERNAME    forge      by your database name  you must create one if you dont have any  and by that database username  like this   database    gt  env  DB DATABASE    MyDatabase     username    gt  env  DB USERNAME    MyUsername

User · Answer

sometimes its because DB CONNECTION mysql and you want to use SQLite database  A solution to that is to make DB CONNECTION sqlite  hope it helps  DB CONNECTION mysql DB HOST 127 0 0 1 DB PORT 3306 DB DATABASE C  xampp htdocs jbtibl database database sqlite DB USERNAME root DB PASSWORD

User · Answer

write php artisan config cache   in your terminal and it will be fixed

User · Answer

Note  Once it happened that I accidentally had a space before my database name such as mydatabase instead of mydatabase  phpmyadmin won t show the space  but if you run it from the command line interface of mysql  such as mysql -u the user -p then show databases  you ll be able to see the space

User · Answer

first clear your cache using this command php artisan cache clear  Then restart the server using this command php artisan serve

User · Answer

In my particular case  I finally realised that my phpMyAdmin was using port 3308 while Laravel was attempting to connect through 3306  so my advice would be to ensure you have the correct connection string

User · Answer

I did all of them but didn t work  I find out should stop php artisan serve Ctrl   C  and start php artisan serve again

User · Answer

You have to clear the cache like that  because your old configuration is in you cache file     php artisan cache clear   The pdo error comes from the fact Laravel use the pdo driver to connect to mysql

User · Answer

First you have to Create your related Database  Then php artisan cache clear  Now run php artisan migrate install   Hope your problem will get resolved

User · Answer

Encountered this issue quite a few times  note that I m running laravel via Vagrant  So here are the fixes that work for me    Try again several times  refresh page  Reload vagrant  vagrant reload    You may try reloading your server instead of vagrant  ie MAMP

User · Answer

Here is my response to the problem described in the question   in cmd write   php artisan cache clear   then try to do this code in your terminal  php artisan serve   note  this will start again the server

User · Answer

Stop the server then run php artisan cache clear    Start the server and should work now

User · Answer

My APP NAME variables  in  env example and  env and app php  were with space  e g  The App   Surounding that by   and  php artisan cache clear and setting new generated app key to APP KEY variable through env files   and relaunching the server by  php artisan serve solved this issue

[php] Laravel PDOException SQLSTATE[HY000] [1049] Unknown database 'forge'

Examples related to php

Examples related to mysql

Examples related to laravel

Examples related to laravel-4