Skip to main content

flipkart

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…

7 Easy steps to speed up your Windows PC

7 Easy steps to speed up your Windows PCToday I am going to discuss some tips to speed up your Windows PC. These tips can be used for your laptop or desktop computer. 

1 Delete Temporary Files 

Temporary files are the one which is used for supporting some applications for a limited period of time and left unused for later. Deleting temporary files is very easy. But there are peoples they still don’t know about temporary files. For them I have included this step in my list. Deleting these files periodically will prevent your PC from becoming a very slower one. Deleting temporary files will improve the performance of your PC.
Temporary files can be deleted in the following way
  • Click on the Start icon
  • Type Run on the search box
  • Select the Run from list 
  • Type temp and press enter
  • Delete all the files from the appearing folder.
  • Repeat all the steps for %temp% and prefetch instead of temp.

Note: If some files remain undeleted then skip that files. 

2 Uninstall unwanted applications

There will be so many applications installed in your PC. Some of them will be unused by you. Uninstalling these unwanted applications will free up a lot of space in drives and thus it makes your PC faster.

3 Avoid unneeded background processes

The unwanted programs running in the background will reduce the memory and processing power of a PC available for a specific program started by the user. So stopping these background applications will free up those resources and that can be used by the main task. 

You can do this using task manager or some other third party applications like Driver Booster.

4 Install Anti-virus

Anti-virus not only protects PC from malicious programs but also it increases the system performance. A lot of free anti-virus softwares are available in the internet such as Avast, AVG and Avira. Using an anti-virus protects your PC from harmful applications which may affect the system performance.

5 Empty recycle bin

Simply deleting the files didn’t delete them properly. Deleting a file means it is just moved to the recycle bin. That means the file still exists in the system. Once we empty the recycle bin the space on the disk becomes free and can be reused.

6 Add extra RAM

Adding extra RAM will cost you some money but it will surely speed up your PC. You can even play high end games easily using increased RAM.

7 Keep your PC cool

Heating up of PC will affect the performance. So for better performance one needs to keep the PC cool. Every PC should come with an internal fan to do this job. You can also do this using an external fan or a cooling pad.

Comments

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…

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…

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…