Export MySQL table To Excel or CSV without any Software

In this video I have shown how you can export a MySQL table to excel or CSV without any third party software. All you can use CMD prompt to export export the table. 1. First login to your MySQL database through command prompt. You can check below link to see the steps for that. https://chillyfacts.com/connect-remote-mysql-database-using-command-prompt/ …

Continue reading

Reset PostgreSQL password on Windows

In this video I have shown how to reset the forgotten password of PostgreSQL on windows 10 PC. 1. First locate the pg_hba.conf file inside the installation directory of PostgreSQL. In this example the file is located in ‘C:\Program Files\PostgreSQL\12\bin’. 2. Open the file in notepad and comment the below lines by putting # at …

Continue reading

Download Youtube Videos using Command Prompt CMD

Now you can download youtube videos using command line commands. This will work in any platform like unix, linux and windows. To demonstrate the downloader in windows we have to download an executable exe file from below link or their website. Download youtube-dl here. youtube-dl.rar Steps to Download youtube Videos 1. Download the youtube-dl and …

Continue reading

Connect to remote MySql database using Command Prompt

In this video I have shown how to create an online free MySQL database for testing. How to create remote MySQL database. How to connect to remote MySQL database. As per in this example. We can connect to MySQL with the below command line argument. Open CMD and First navigate to location where you have …

Continue reading