Skip to main content

How to connect remote DB from localhost using PhpMyAdmin

Connecting to a remote database from localhost can be done in many ways. Here I am going to explain a very simple way to do so. That is, connecting a remote database using phpmyadmin in the local server. To do so you need to follow the simple steps given below, Note: Hope you guys have server installed in your local machine Xampp, Wamp etc. I am using xampp for the tutorial.
1.Open the XAMPP control panel. You can open it from the Xampp directory. (eg: C:\xampp ->xampp-control) 2.Click on the Config button on the right side of Apache and select PhpMyAdmin (config.inc) from the dropdown list. 3.Now you need to add the connection details in the config.inc document just before the php closing tag in the following format. Eg: $i++; $cfg['Servers'][$i]['host'] = ''; //provide hostname and port if other than default $cfg['Servers'][$i]['user'] = '';//user name for your remote server $cfg['Servers'][$i]['password'] = '';//pass…
Post a Comment

How To Download Videos or Audio From Streaming Websites

Most video sites operate on streaming algorithms. These algorithms only allow the online streaming of videos and prevent the downloading of videos to your disk or memory. Although, downloading videos from these kind of sites are breaking the rules. But there are lot of ways to do so. 

In the case of YouTube, it allows you to save videos for offline streaming. But it doesn't allows to download the videos to local drive or memory. But there are lot of methods which let you to download videos or just extract the audio and save them to your local drive or memory. The simplest way you can do this is by removing three letters from the video URL. For example a YouTube video URL will look like this https://www.youtube.com/watch?v=Boc39rGYcrc . Now remove the letters 'ube' from the word 'youtube' on the link and hit 'enter'. This will take you to a new website called 'yout.com'. This site allows you to download the video or just the audio of the video as an mp3 file by selecting appropriate option.


Download Facebook Videos

Similar to YouTube, the Facebook mobile application also has the feature that allows users to save videos for offline viewing. Inorder to save the video, just play the video you want to download and open the three dot menu in the top right corner. From the list of options, select 'Download'. The video will be downloaded to your device so that you could watch it offline later.

If you want to download the Facebook videos from your web browser on a desktop, you can download that video file easily by the following steps. First, determine if the video is hosted by Facebook and if it is, "Right click" on the video and select "Copy link address". Open a new tab and search "downvids.net". Paste the video link, select the video format and hit the 'Download'. This site works for many other video sites and so you can even use it to download from YouTube or other streaming websites.

Comments

  1. Useful info.... Tnx techshasthra

    ReplyDelete
  2. Anchu Stephen Thumpakal25 September 2017 at 10:05

    Thank u for your clear explanation.....

    ReplyDelete

Post a Comment

Popular posts from this blog

How To Hack Any Android Game On Rooted Android Smartphone

In these days, most of the android users don’t know what they can do with their rooted android smartphone. By rooting a smartphone you can unlock your sytem files. By using different applicatons you can edit the system properties and improve the system performance and much more. Also, you can easily edit almost every android game data with root access.
Here I am going to hack ‘Tennis 3D’ game on any rooted smartphone using a simple file manager. By using a root file manager anyone can edit the game data by the following steps. By editing the internal game data, you can make free unlimited money in your game. 
Steps to hack Tennis 3D game on any rooted android smartphone
First you need to install root file manager like ‘Root Explorer’ from Playstore and grant root access to the file manager via Superuser. Open the root explorer and go to data folder inside the data folder (Data>>Data) from the Root folder. Then you can see data folders of each application installed in your phone. F…
1 comment
Read more

How to Restore Accidentally Deleted Google Chrome Data

If you have accidentally deleted Google Chrome user data including bookmarks, saved passwords and search history, then you can restore the chrome data easily by accessing the User Data folder. Google Chrome automatically stores all your browser data including bookmarks, saved passwords, search history and settings in a hidden folder named User Data inside the AppData folder.
First you need access to the User Data folder. In order to view the folder, first enable the hidden files and folders.
For Enabling the Hidden files and folders view
Search for "show hidden files and folders" in the start menu. Check to enable the "Show hidden files, folders, and drives" option.
Then Click OK

To Restore the Chrome Data
Close the Google ChromeIn the Windows Explorer, navigate to the location "C:\Users\%USERNAME%\AppData\Local\Google\Chrome\" , where %USERNAME% is your system username Right click on the "User Data" folder and choose "Restore previous versions&q…
Post a Comment
Read more

Nubia Z17 Mini with dual-rear camera setup launched in India at Rs. 19,999

ZTE Nubia has launched its Nubia Z17 Mini smartphone with dual rear camera setup in India. The device is priced at Rs.19.999 and will be available via Amazon from June 12.
The Nubia N17 Mini features a 5.2-inch Full HD display with 1920 x 1080pixels resolution. The screen also has a pixel density of 424ppi and it comes with Corning Gorilla Glass protection. The smartphone is powered by a Qualcomm Snapdragon 652 Octa-Core 64 bit processor coupled with 4GB RAM. The device possesses an internal storage of 64GB which can be expanded upto 200GB via microSD card. 
The Nubia Z17 Mini comes with a dual-rear camera setup consisting of two 13MP Sony IMX258 sensors - Sony full-light MONO sensor and a true color RGB sensor. The dual rear camera setup has a 3D mode that creates interactive 3D pictures. On the front the device has a 16MP sensor with 80° wide angle lens and F2.0 aperture. 
The phone runs on Nubia UI 4.0 based on Android 6.0 Marshmallow. The Connectivity options of this device inclu…
1 comment
Read more