Posts Tagged ‘password’

How to backup and restore your MySQL database or table structure to in Linux

Whenever there is a database involved, an important task that should never be neglected is backing it up. In the case of MySQL on a Linux machine, backing up consists of executing a single command.
Backing up a MySQL database can be done with one simple command:

mysqldump -h <host> -u <user> -p<password> <db_name> > backup.sql

For example if you want to backup a local database called db1 using the user user1 with password pass1 you should write:

mysqldump -h localhost -u user1 -ppass1 db1 > backup.sql

The backup.sql file contains an SQL query for creating the exact same database. Restoring such a dump-file is just a matter of one command too:

mysql -h <host> -u <user> -p<password> <db_name> < backup.sql

Following the naming from our previous example will result in the following command to restore the database:

mysql -h localhost -u user1 -ppass1 db1 < backup.sql

In the perfect environment the backup should be created by a cronjob or anacronjob.
Another useful thing that one may want to backup is the table structure. For tables whose structure is relatively often changed this can prove to be very helpful. It is done by using one simple modification of the command for backing up an entire database:

mysqldump -d -h <host> -u <user> -p<password> <db_name> > backup.sql

Did you notice the difference? It is the -d option, which specifies that data should not be dumped. Using our previous examples this will be transform to:

mysqldump -d -h localhost -u user1 -ppass1 db1 > backup.sql
VN:F [1.9.18_1163]
Rating: 6.3/10 (3 votes cast)

How to temporarily lock your PC after a given number of incorrect password entries in Windows 7 using the command prompt

Are you worried that your Windows 7 login password is easy to guess and that it is possible to crack it only after a few attempts? Well if you are I have two things to say to you. First, change your password. I know you have probably heard it a thousand times, but having a “smart” password is essential these days. You won’t feel comfortable if a thousand other people unlocked their front doors with a key identical to the one you use for your own front door, would you?
The second thing I have to say is, why don’t you at least lock your PC after a few incorrect entries? Surely this will make the password guessing process a lot longer.
Note: It is a good idea to have a second administrator account which you can use to unlock your PC. Just in case someone decides to do a trick on you.
Note: In case of physical access to your PC this will not slow down the use of System Rescue CD, Ultimate Boot CD or Ubuntu Live CD for resetting your password.

First, open the Command Prompt under Administrator Mode.

To do that, open the Start menu, type cmd in the search box:
Read the rest of this entry »

VN:F [1.9.18_1163]
Rating: 0.0/10 (0 votes cast)

Tighten Your Wireless Network Security In 3 Steps

Tutorial that will help you make sure your wireless network is secure. Tutorial describes how to use WPA2-AE for level of security and encryption. The three main points talked about are Password Protection, Hidden Network Name and the MAC Address Allow List Read the rest of this entry »

VN:F [1.9.18_1163]
Rating: 0.0/10 (10 votes cast)

Error establishing a database connection

Error establishing a database connection in WordPress is one of the worst errors you may get and in my opinion the hardest to troubleshoot as we all know that the developers of WordPress made it really hard for non experienced users to get some useful stuff from the logs. In this tutorial I will try to guide you how to troubleshoot this error and get your wordpress blog up and running once again.

I want to explain that what follows are general instructions how to proceed if you get this error. I will try to generalize the approach to find the root cause of the issue.

The prerequisites are you run the latest available version of WordPress, you use Apache webserver , and you use mysql database. That is pretty much 95% of all WordPress users so we hope to be helpful to majority of the users.

First and most important step is to find out if the username and password are working. All hosting companies offer phpmyadmin to test the connection to the database server. I will not cover instructions of how to do that as all hosting companies offer different control panels. The best advice if you do not know how to test the username and password is to call your hosting provider. The configuration settings about your database login credentials are stored in wp-config.php file. They look like this Read the rest of this entry »

VN:F [1.9.18_1163]
Rating: 4.0/10 (1 vote cast)

wget using authentication proxy on Linux

In this tutorial we will demonstrate something that most of you may need to use just for a few times in their Linux experience but will be very happy that such functionality existed at first place. Commong Linux users, including me, are not so used to get things through a proxy. Maybe used one some time ago but I have totally forgotten that such things as proxies even existed. Anyway in case one day it happens that you find yourself in a corporate network and need to download someting from the command line you will find yourself into some trouble. Not that you cannot download it quickly using a browser but for example in my case it was a script that I had to make work. For such cases after you finish reading this tutorial you will know how to configure wget for using proxy with basic authentication.

There are two ways for wget to pick up the proxy server hostname. One way is from the environment variables and another way is via the wget configuration file.The main and only configuration file of wget is located in etc directory Read the rest of this entry »

VN:F [1.9.18_1163]
Rating: 2.5/10 (14 votes cast)

Buffalo WHR-G54S Admin Config

In this tutorial I will show you how to set all administrative options for Buffalo WHR-G54S Wireless Router. When logon to administration page go to: Admin Config >> Name/Password.

Here you can set AirStation Name up tp 32 symbols and root password. Read the rest of this entry »

VN:F [1.9.18_1163]
Rating: 0.5/10 (10 votes cast)

Stop the Guest Account

Windows XP like any other modern operation system works with users accounts with entire support and management tools of user account.
Also like other operation systems Windows XP have pre-setuped ”Guest” account which is some kind of basic, limited account with predefined low privilege abilities.

Nevertheless of this basic user abilities, this Guest account can be used by some harmful attacker for bad purposes about your system durability.

For this case we will stop this account and he will be unavailable for any access in any login of your Windows XP operation system. Read the rest of this entry »

VN:F [1.9.18_1163]
Rating: 0.0/10 (0 votes cast)