Level 65
What does your DB env settings look like?
Apr 9, 2018
10
Level 4
the error php artisan migrate
hello all i was try run php artisan migrate command but i get the error of terminal: ~:Dive564-laravel aalrasheid$ php artisan migrate
Illuminate\Database\QueryException : SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = dive564 and table_name = migrations)
at /Applications/MAMP/htdocs/Dive564-laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664 660| // If an exception occurs when attempting to run a query, we'll format the error 661| // message to include the bindings with SQL, which will make this exception a 662| // lot more helpful to the developer instead of just the database's errors. 663| catch (Exception $e) {
664| throw new QueryException( 665| $query, $this->prepareBindings($bindings), $e 666| ); 667| } 668|
Exception trace:
1 PDOException::("SQLSTATE[HY000] [2002] No such file or directory") /Applications/MAMP/htdocs/Dive564-laravel/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68
2 PDO::__construct("mysql:host=localhost;port=3306;dbname=dive564", "root", "root", []) /Applications/MAMP/htdocs/Dive564-laravel/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68
Please use the argument -v to see more details. notes i use application Mamp in os Mac
Level 4
hello bashy thank you for replay to me , the DB env setting this one:
DB_CONNECTION=mysql DB_HOST=localhost DB_PORT=3306 DB_DATABASE=dive564 DB_USERNAME=root DB_PASSWORD=root
Level 50
@aalrashid change DB_HOST from localhost to 127.0.0.1
Level 4
hi rin4ik thank you to replay to me ,this not work was trying same
Level 50
Level 65
Ok must be something to do with your MySQL server not actually running. Can you connect to it manually via CLI?
mysql -u root -proot
Level 4
hello thank you for help all and appreciate all :>
Level 50
@aalrashid fixed?
Level 4
@rin4ik no ,but go easy Solved macOS Recovery my Mac :)
Level 4
hello ALL, I know now what is my problem with mac os have tow solved one : most add this class: use Illuminate\Support\Facades\Schema;
function boot() { Schema::defaultStringLength(191); } on AppServiceProvider.php file
tow: by the terminal, most works in .profile edit not the files./bash_profile run the: source ~/.profile thank you all
Please or to participate in this conversation.