Reputation: 868
I have a basic issue in laravel setup. I have setup laravel 5.5 using php7.0(cli) and for artisan migrate I have install the mysql server on my system (I have already xampp on my system) so now my Laravel project access the mysql cli (not xampp which I access with phpmyadmin) how can I connect my laravel with xampp database.
currently its direct configure with cli php and mysql-server
Thanks
Upvotes: 5
Views: 23808
Reputation: 71
Go to .env file in your project root folder, there you can edit:
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=testdatagym
DB_USERNAME=root
DB_PASSWORD=
Upvotes: 1
Reputation: 404
You have .env
file in your project root folder. There you can edit:
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=database_name
DB_USERNAME=root
DB_PASSWORD=
By default, XAMPP root username is root
, there is no password and port is 3306.
Obviously, you have to start MySQL in XAMPP control panel.
Upvotes: 8