Are your database settings correct?

did you even LOOK at the line it is showing you? it clearly says case 2005.. which is where i would start.. and that google search led me to this:

http://stackoverflow.com/questions/16580370/mysql-error-2005-u...

localhost is not the right setting.

What i would do is log in to mysql using the command line with -h flag e.g. mysql -h 127.0.0.1 -u user -p replace 127.0.0.1 with whatever might work.. and when it starts working use that in your laravel.. basically trial & error

Yes they are correct... Thanks!!!!

thomastkim said:

Are your database settings correct?

Hello Shez, thanks for your reply, Yes I tried it all, tested with localhost, 127...., ssh and tried connecting to both, localhost works but 127.0.0.1 would not.

e.g.

Using localhost

@**.com [~]# mysql -h localhost -u ******** -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 146474 Server version: 5.6.23 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Using 127.0.0.1

@**.com [~]# mysql -h 127.0.0.1 -u ******** -p Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

updated composer also, reinstalled it, etc...

Do you believe it has something to do with the fact that 127.0.0.1 wont connect? I mean is there another dependency that uses this instead of "localhost"?

My config/database.php file has "localhost" right now.

Thanks

shez1983 said:

did you even LOOK at the line it is showing you? it clearly says case 2005.. which is where i would start.. and that google search led me to this:

http://stackoverflow.com/questions/16580370/mysql-error-2005-u...

localhost is not the right setting.

What i would do is log in to mysql using the command line with -h flag e.g. mysql -h 127.0.0.1 -u user -p replace 127.0.0.1 with whatever might work.. and when it starts working use that in your laravel.. basically trial & error

forget laravel for a second.. create a new script (php) & try to connect to mysql using PDO or mysql_query or something.. and see what happens..

are mysql & your server on the same machine?

Hello Again Shez, thanks for taking the time to respond, I created this simple mysqli connect which successfully returned the total records... However Laravel still not running.

http://206.214.216.52/testmysql/

Yes, Mysql and server are the same machine.

I appreciate it.

shez1983 said:

forget laravel for a second.. create a new script (php) & try to connect to mysql using PDO or mysql_query or something.. and see what happens..

are mysql & your server on the same machine?

Here is a PDO example. it works, however laravel still not running...

http://206.214.216.52/testmysql/test2.php

shez1983 said:

forget laravel for a second.. create a new script (php) & try to connect to mysql using PDO or mysql_query or something.. and see what happens..

are mysql & your server on the same machine?

Ping...

Thanks in advance, so far, mysqli and PDO connect just fine... however Laravel still not able to run, Anyone has a clue?