Sequel Pro, laravel issues

Posted In Laravel
  • brandon-byrne 2 years ago

    Hi Guys

     

    Firstly thank you for the awesome videos, I have learned so much so far. The issue I am having with Sequel Pro and Laravel is I get the following two errors;

    QueryException in Connection.php line 770:SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from `customers` limit 1)

    and then 

     

    PDOException in Connector.php line 119:SQLSTATE[HY000] [2002] No such file or directory

    Could anyone assist, I am using WAMP and can not get them to connect.

    thanks Brandon

  • mark 2 years ago

    What environtments have you set?

    Mamp uses this by default I think, try use that.

    DB_HOST=127.0.0.1
    DB_PORT=8889
  • devdojo 2 years ago
    Hey Brandon :)
    
    Glad you like the content. 
    
    So, there are a few things that could be the issue.
    
    1. It could be your database credentials are incorrect. perhaps try `localhost` as the DB_HOST instead of `127.0.0.1` or the other way around.
    2. Perhaps you do not have the PDO extension installed
    3. Lastly, if you've checked all those, make sure you have a table named `customers`
    
    Hope this helps :)

    Hey Brandon :)

    Glad you like the content.

    So, there are a few things that could be the issue.

    1. It could be your database credentials are incorrect. perhaps try localhost as the DB_HOST instead of 127.0.0.1 or the other way around.
    2. Perhaps you do not have the PDO extension installed
    3. Lastly, if you've checked all those, make sure you have a table named customers

    Hope this helps :)

  • brandon-byrne 2 years ago
    Hey Guys 
    
    Thanks for the responses, I have tried using localhost and 127.0.0.1 but they both produce the same errors, that includes the correct ports 8889 and 3306.
    I have also made sure that the passords and user names are correct when acessing the customers table.
    
    I only thing I don't have installed is the PDO extention so I will give that a try, I am using a mac so do I run that in the command line terminal?
    
    
    thanks again Brandon
    

    Hey Guys

    Thanks for the responses, I have tried using localhost and 127.0.0.1 but they both produce the same errors, that includes the correct ports 8889 and 3306. I have also made sure that the passords and user names are correct when acessing the customers table.

    I only thing I don't have installed is the PDO extention so I will give that a try, I am using a mac so do I run that in the command line terminal?

    thanks again Brandon

  • mark 2 years ago
    For Mac I can recommend using [Laravel Valet](https://laravel.com/docs/5.3/valet).
    
    So damn easy to use.

    For Mac I can recommend using Laravel Valet.

    So damn easy to use.

Please login or signup to leave a response.

Login

or Sign Up

Sign Up

or Login
×
Want to create your own SAAS?

I can teach you to create your own Software as a Service. Click here to learn more!

Visit SAAS Adventure!