Naman Khare

Personal Blog

Hero Illustration

Posts

  • Error: connect ECONNREFUSED & Open MySQL Port (remote)

    Error: node:events:505 throw er; // Unhandled ‘error’ event ^ Error: connect ECONNREFUSED your-ip:3306 at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1187:16) Emitted ‘error’ event on Connection instance at: at Connection._notifyError (\node_modules\mysql2\lib\connection.js:236:12) at Connection._handleFatalError (\node_modules\mysql2\lib\connection.js:167:10) at Connection._handleNetworkError (\node_modules\mysql2\lib\connection.js:180:10) at Socket.emit (node:events:527:28) at emitErrorNT (node:internal/streams/destroy:157:8) at emitErrorCloseNT (node:internal/streams/destroy:122:3) at processTicksAndRejections (node:internal/process/task_queues:83:21) { errno: -4078, code: ‘ECONNREFUSED’, syscall: ‘connect’, address: ‘your-ip’,

    Go to post

  • How to import CSV file into mysql database using commmand line (terminal)

    ,

    Import large CSV file using command line rather than using phpMyAdmin or other GUI software. Importing CSV file using command line is much faster, you can import 100000+ rows in seconds which is not possible in phpMyAdmin. Table name should be same as the CSV file name. Use this command in your command line. Please

    Go to post

  • Fix MongoDB port for remote access in iptables [firewalld] ubuntu

    , ,

    Just add 27017/tcp to iptable and it will work! sudo firewall-cmd –zone=public –add-port=27017/tcp –permanent sudo firewall-cmd –reload Check using: sudo iptables -L -v and/or sudo firewall-cmd –list-ports Check if firewalld is running: sudo systemctl status firewalld tested on: ubuntu: 22.04.1 LTS Make sure you have disable ufw: sudo ufw disable   Errors: E-1: connect ECONNREFUSED

    Go to post

  • HTML vs. PHP: What’s the difference and Which one should I choose?

    What they are meant for? HTML and PHP are two different things meant for two different task. As far as HTML (Hypertext Markup Language) is concerned, HTML (along with CSS) is a backbone of all the web-development and used as a front end development whereas PHP (Hypertext Preprocessor) is a server side scripting language which execute

    Go to post