PHP Laravel Framework Database Connection Error

Question

I created a database called learning-laravel and I created a table which is users I want to get data from that table I wrote this code block:

Route::get('/',function()
{   
    $users = DB::table('users')->get();
    return $users;
});

but I'm getting this type of error:

PDOException
SQLSTATE[HY000] [2005] Unknown MySQL server host 'localhost:3306' (2)



  */
    public function createConnection($dsn, array $config, array $options)
    {
        $username = array_get($config, 'username');

        $password = array_get($config, 'password');

        return new PDO($dsn, $username, $password, $options);
    }

can you show the code where you specify the host and port number? — Ibu
– Ibu, Commented Dec 16, 2013 at 17:30
my database.php file 'mysql' => array( 'driver' => 'mysql', 'host' => 'localhost:3306', 'database' => 'database', 'username' => 'root', 'password' => 'root', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', ), — user3107761
– user3107761, Commented Dec 16, 2013 at 17:31
I checked my MAMP server APACHE post:8888 MySQL post:3306 I think there should be no error — user3107761
– user3107761, Commented Dec 16, 2013 at 17:33

keslerm · Accepted Answer · 2013-12-16 17:31:43Z

1

Try instead of including the port in the host, add a "port" key and the port in a seperate key.

    'host'     => 'localhost',
    'port'     => '8889'

Looks like it may be trying to use that entire string as the host name.

answered Dec 16, 2013 at 17:31

keslerm

677 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Zarathuztra · Accepted Answer · 2013-12-16 17:37:10Z

0

As you said in your comment above, you have your MAMP settings pointing MySQL requests to port 3306. Here is the correct setting in that case:

'host' => 'localhost',
'port' => '3306'

Also, the "is it plugged in" suggestion would be to make sure your DB is actually running.

answered Dec 16, 2013 at 17:37

Zarathuztra

3,2411 gold badge22 silver badges34 bronze badges

Comments

Angel Camacho · Accepted Answer · 2015-04-16 19:01:20Z

0

The solution is:

'host'      => 'localhost:3306',

answered Apr 16, 2015 at 19:01

Angel Camacho

11 bronze badge

Collectives™ on Stack Overflow

PHP Laravel Framework Database Connection Error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related