How I got this error?
Ans: I was running php artisan migrate command in /opt/lampp/htdocs/project_dir
What was the error? ubuntu@ip-ip_addr:/opt/lampp/htdocs/project_dir$ php artisan migrate
In Connection.php line 664:
SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = db_name and table_name = migrations
)
In Connector.php line 67:
SQLSTATE[HY000] [2002] Connection refused
Screenshot of the error:
Solution:
1. Open .env file
2. Change the DB_HOST=127.0.0.1 to DB_HOST=localhost
3. Make sure the port number, db name, username and password is correctly mention in the .env before saving it
4. Save the .env file then run command: sudo artisan config:cache
5. Now, run command: php artisan migrate
Output after applying the solution:
Thanks for reading. I hope you enjoyed the article!
Email - contact@DevOpsSchool.com
Chetan is a Full Stack Software developer. He provides optimize solutions at each and every layer of the Enterprise application right from Front end to back end using demanding next gen technologies.
Worked with renowned software companies like ATCS Inc USA, Mercedes Benz USA, Intel, McAfee, JDA Software Inc, Infosys Limited
Expertise in Java/J2ee, PHP, Laravel, Javacript, Angular JS, JQuery, Html, CSS, Git, Aws, Node
1. Technical consultation to customers
2. Trainer on Java, J2EE, JavaScript and PHP Laravel frameworks, PL/SQL, Cross Platform Mobile App Development
3. Team Conflict resolution. Great Team Player
4. Quick Learner. Ability to adapt & expertise new or unknown technologies very easily and quickly
3. Ux/ Mock up screens/ Wire frame designing Skills
4. Excellent development skills
5. Automation Testing skills
6. Server hosting & deployment skills
7. Middle ware/ Server Technologies: Java, J2EE, Spring MVC, Spring Security, Spring Core,Hibernate, Struts, REST Web Services.
8. Web Technologies: Sencha ExtJS, Angular JS, JQuery, Bootstrap CSS, Html, Css, Javascript
9. Mobile Technologies: Cordova/ Phonegap, Ionic
10. Server side build tools: Ant, Maven
11. Web UI side build tools: Node JS, Grunt JS
12. Version Control Tools: Git, SVN, Source Tree
13. Server Side Testing Technologies: JUnit, REST Assured
14. Frontend Side Testing Technologies: JS Unit, Mocha, Sinon
- MyHospitalNow.com – PROD | Clean all patient user and related quote, bid and file data - March 21, 2020
- Sending Email with attachments in Laravel 5.5 using and PHP & JQuery - February 20, 2020
- How to run php artisan queue:listen in background on Ubuntu or Linux machine - February 6, 2020
