Archive for the ‘Others’ category

« Older Entries
Newer Entries »

How to Reset MySQL Root Password

August 18th, 2012 by Admin

Forgot your MySQL root user password? Don’t worry. We are here for rescue.

When you tried to login to root without entering a password, you may get ‘Access Denied’ message, as MySQL is expecting a password. This article explains how to reset MySQL root password when you don’t remember your old one.

How to Reset MySQL Root Password:

Step 1: Stop the MySQL service by going to Control Panel, Administrative Tools and Services. Right-click on the service and choose Stop.

Step 2: Create a new text file and copy and paste the following lines into it:

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

Make sure to change the password “MyNewPass” to whatever password you want to replace the current one with. Now save the file and give it a name like C:\mysql-init.txt or whatever you like.

Step 3: Now go to the command prompt and type in the following command:

C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt

In my case, I had to change the path to something different than C:\mysql\bin. If you installed MySQL using the installation wizard, which I did, you have to use a different command:

C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe"
         --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini"
         --init-file=C:\mysql-init.txt

So what is the path for your defaults-file? You can get the exact value by going to the Services dialog again and right-clicking on MySQL and choosing Properties. The box that says “Path to executable” has the value for defaults-file.

At this step, I ran into an error. Every time I would try to execute the command, I would end up getting an error message and the password would not be reset.

InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB’s files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.

In my case, I have to go to the Task Manager and click on the Processes tab. Here I found that I already had several instances of MySQL running! I don’t know why or how they were started, but even with the service stopped, there were processes running.

I killed off all the processes and ran the command again, which worked perfectly.

Step 4: Go back to the Services window and restart the MySQL service. You should now be able to log into the MySQL database! Enjoy!

Comments Off on How to Reset MySQL Root Password »

Posted in Others, Tips & Tricks

Tags:

How to Use Parental Controls in Windows 7

August 16th, 2012 by Admin

Windows 7 has built-in parental controls that allows you to control certain aspects of your computer. This is ideal if you don’t want your children accessing certain programs or more importantly don’t want them to access to computer as certain times, such as at night when the computer is in their room.

Windows 7 Parental Controls is easy to setup and you can use it to limit how much computer time children have, as well as which programs and games they can use. So let’s look at how you can setup Windows 7 Parental Controls.

How To Use Parental Controls in Windows 7?

To access Parental Controls open the Start Menu and type parental controls into the Search box and hit Enter.

Next select the account that you want to setup parental controls on. In our screenshot we have selected Test. Remember that the account has to be a standard account and not an administrator account.

Under Parental Controls mark the radio button next to On, enforce current settings. Then you can go through and control their computer time, games, and programs.

Option 1: Set Time Limits

Once you have clicked on time limits you are presented with a grid with days and times as in the image below. This grid allows you to select when access will be allowed or blocked to the account.

Option 2:Control Games
Click on Games to control the type of access your child has to games on the computer. You can completely block all games or select games by ratings and game names. These game ratings are based on the Entertainment Software Rating Board.

Option 3:Control Programs

If you want to restrict certain programs on the machine, click on Allow and block specified programs then scroll through the list of installed programs and block them.

That’s it. The user account is now configured to use Windows 7 Parental Controls. To modify or change these settings the user will need to know the administrator password to change settings. So you need to make sure to password protect your administrator account, otherwise anyone can turn off Parental Controls and use the computer with no restrictions.

Comments Off on How to Use Parental Controls in Windows 7 »

Posted in Others, Tips & Tricks, Windows 7

Tags:

How to Reset Admin Password on Virtual Machine

August 13th, 2012 by Admin

I have presently created a Windows XP virtual machine as well as have been making use of it with no troubles. Today when I start my computer, it asked me for an administrator password. I suppose that I did not set up since I have not at all asked for it prior to. How can I reset the password or else do I require to rebuild a new machine? Can I make use of a password reset utility? Thanks in advance for any assist.

I was given a Virtual PC file which belongs to a worker who left our business. The Virtual PC has vital files and data. I started up the request in Microsoft Virtual PC 2007, however cannot logon for the reason that we do not be acquainted with any user names or passwords for the machine. How be I able to reset the Administrator password on the virtual machine?

Actually, resetting admin password on a virtual machine is the same process as resetting one from a physical machine, if you have created a Windows password reset CD. Most virtual machine software like VirtualBox, MS Virtual PC, Parallels, VMware etc, provides the feature of booting virtual machine from physical CD and ISO image. So you can let your virtual machine boot from Windows password reset CD and reset your forgotten admin password easily. It’s more convenient that you can also boot from ISO image to reset Windows password, without having to physically burn a password reset CD.

To reset admin password on virtual machine running inside VMware Workstation, please refer to this guide:
How to Reset VMware Administrator Password

To reset admin password on virtual machine running inside Microsoft Virtual PC, please refer to this guide:
How to Reset Virtual PC Password

To reset admin password for virtual machine in VirtualBox, please refer to this guide:
How to Reset VirtualBox Password

To reset admin password for Parallels virtual machine, please refer to this guide:
How to Reset Lost Windows 8/7/Vista/XP Password for Parallels Virtual Machine

To reset Windows domain admin password on virtual machine, please refer to this guide:
How to Reset Windows Domain Password

Comments Off on How to Reset Admin Password on Virtual Machine »

Posted in Others, Tips & Tricks

Tags:

How to Reset SQL Server SA Password if You Forgot it

August 5th, 2012 by Admin

I have a local install of SQL Server Express that I haven’t touched in months. Now I need to use it, and I’ve forgotten the SA password. I have tried using SQL Server Management Studio, I have done Single User Mode with SQL Server and used sqlcmd, they all tell me I don’t have permissions for it. I’m afraid that even reinstalling SQL Server Express isn’t going to fix this for me. Does anyone know of any other method to reset the SA password?

Forgot the password of SA account on your SQL Server? You may lost the SA password on a machine, and when you log in to the machine directly using an account in the admin group, SQL Server Management Studio still doesn’t allow you to log in using Windows authentication. So how to reset forgotten SA password if you can’t connect via Windows Authentication?

In this tutorial we’ll show you an easy way to reset SQL Server SA password with SQL Server Password Changer, if you forgot the password and can’t connect to your SQL Server database. The password resetting procedure is simple and you can reset SA password in just a few mouse clicks!

How to Reset SQL Server SA Password if You Forgot it:

  1. Download SQL Server Password Changer on your local PC, install and launch it.
  2. Click the Open File button. Select the SQL Server master database file (master.mdf). Typically it is located in the folder: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.Select the SQL Server master database file
  3. The program will automatically decrypt the master database file and display all user accounts in your SQL Server. Select the SA account, click the Change Password button. Type a new password and click OK.SQL Server Password Recovery
  4. The old password will be replaced with your new password. Now you are able to log into the SA account using your new password.

Now you’ve completed the task of resetting SQL Server SA password. No need to worry about forgetting SA password! With SQL Server Password Changer you can reset SQL Server SA password quickly and easily.

Comments Off on How to Reset SQL Server SA Password if You Forgot it »

Posted in Others, Tips & Tricks

Tags:

PST Password Recovery

August 2nd, 2012 by Admin

Forgot your PST password? Is there any way to recover the password? What to do if you have some very urgent emails in it? If you’re an Outlook user, you should know that Microsoft Outlook automatically stores email messages, contacts, appointments, tasks, notes and journal entries in a personal storage folder, also known as a .PST file. So you’ll get big trouble if you can’t recall the PST password.

This guide will show you how to recover forgotten PST password with PST password recovery software. Outlook password recovery is one of the best PST password recovery tool which can help you easily unlock and open any password-protected PST files. Now, let’s go through the step-by-step PST password recovery guide together.

  1. Install Outlook Password Recovery program on your computer.
  2. Start the program and then click Unlock PST File button. You’ll be prompted to select your Outlook PST file.

  3. After choosing your Outlook PST file, click OK.
  4. The program will analyze the Outlook PST file and recover your forgotten password instantly.

With this guide you can easily recover PST password from Microsoft Outlook 2012, 2007, 2003, 2002, 2000, etc. This PST password recovery tool also works with your old .PST file backed up in your USB flash drive.

Comments Off on PST Password Recovery »

Posted in Others, Tips & Tricks

Tags:

How to Show Computer Icon on Windows 8 Desktop

July 31st, 2012 by Admin

When you perform a clean install of Windows 7 or Windows 8, Windows doesn’t show Computer icon on the desktop by default. Users need to manually add the icon to the desktop.

In Windows 7 and previous Windows versions, adding the Computer icon to the desktop is a simple task. Open the Start menu, right-click on Computer, and click Show on desktop option to show Computer icon on the desktop. But how to place the Computer icon on desktop in Windows 8? As you know, Start menu doesn’t exist in Windows 8 and has been replaced with Metro-style Start screen. So, users can’t add Computer icon from the Start menu.

Windows 8 users who would like to see Computer icon on the desktop can follow the given below steps.

Step 1: Right-click on desktop and select Personalize to open Personalization window.

Step 2: In the left-pane of Personalization window, click on Change desktop icons. This will open Desktop Icon Settings.

Step 3: Here, under Desktop icons section, tick Computer checkbox and then click Apply button to show the Computer icon on the desktop. You can also show/hide Recycle Bin, Network, and Control Panel icons on the desktop from here. You are done!

The default icons Computer, Network, Recycle Bin and Control Panel can be replaced with a custom one by selecting the icon and then clicking on Change Icon button.

Comments Off on How to Show Computer Icon on Windows 8 Desktop »

Posted in Others, Tips & Tricks, Windows 8

Tags:

Transfer Files and Settings from Windows 7 to Windows 8

July 27th, 2012 by Admin

Whether you plan to upgrade your Windows 7 machine to Windows 8 or buy a new PC with Windows 8 pre-installed, you can use Windows Easy Transfer to copy all your files and settings from your old machine or old version of Windows to your new machine running Windows 8. In this article, I’ll walk you through the steps of using Windows Easy Transfer and an external USB drive to easily complete the task.

Before we get started, let me clarify exactly what you can transfer using Windows Easy Transfer:

  • User accounts
  • Documents
  • Music
  • Pictures
  • E-mail (including contacts and e-mail settings)
  • Internet Favorites
  • Videos
  • And more

Part 1: Save Windows 7 Files and Settings to USB Drive

  1. To get started, you need to open Windows Easy Transfer on your old PC. In Windows 7, just search for Easy Transfer and you’ll see it show up:
  2. Click on Windows Easy Transfer from the list of programs.
  3. You’ll be presented with the Welcome to Windows Easy Transfer screen, which gives you an overview of what items you can transfer. Click Next to start.
  4. Select An external hard disk or USB flash drive.
  5. Now, select This is my old computer option to transfer files and setting from current PC.
  6. In this step, it shows currently logged-in User Profile and Shared Items options. You can customize the default folder and file section by hitting Customize. The Customize link present in User Profile section lets you pick Documents, Music, Pictures, Videos, Program Settings and Windows Settings, whereas the Shared Items section’s Customize link will open a Shared Items menu, allowing you to choose the shared items that are to be moved.
  7. Once you’ve selected the files, it will ask you to enter the password to secure the transfer process. Clicking Save will prompt you to specify the USB drive where your files and settings are to be copied.
  8. When the destination folder is selected, it will start copying the settings and selected folders. The time it takes to complete the copying process depends upon the volume of selected data.
  9. Window 7 Easy Transfer wizard saves all the settings, user folders, and files from Windows 7 in a MIG file. Now, eject the USB drive, and move to PC running Windows 8.

Part 2: Restore Files and Settings from USB Drive to Windows 8

  1. To get started, open Windows Search from Windows 8 Start hover menu, enter easy transfer in search bar, and then click Apps. Now, launch Windows Easy Transfer utility from main window.
  2. In Windows Easy Transfer wizard, select An external hard disk or USB flash drive option to restore data and settings saved in MIG file.
  3. In next step, choose This is my new computer option.
  4. It will now ask you to plug-in the USB drive where the MIG file is saved. Plug-in the USB drive and select Yes to specify the Windows Easy Transfer file.
  5. On selecting the MIG file, it will ask you to specify the password. Enter the password to restore the data, and click Next.
  6. Once access is granted, it will ask you to choose what to transfer from old PC. At this point, you can select the files and settings that are to be transferred to your new PC. Click Customize under User Profile and Shared Items sections to select the folders.
  7. Once you’ve selected the settings and folders, hit Transfer to begin the settings and data migration process.
  8. After this has finished you will get a message telling you the transfer is complete. You can also see a list of what files and programs were transferred, or choose close to exit the wizard. Now you have the best of both worlds – all your important old files saved onto your new computer.

Windows Easy Transfer provides 3 options to transfer your files and settings: An Easy Transfer cable, A network and A external hard disk or USB flash drive. The first two options require connecting your new PC to old PC in order to send the files and settings. However, if you’re planning to upgrade your PC to Windows 8, select the third option that moves your system settings along with files to external hard drive.

Comments Off on Transfer Files and Settings from Windows 7 to Windows 8 »

Posted in Others, Tips & Tricks, Windows 7, Windows 8

Tags:

Protect Website Passwords Saved in Your Browser

July 25th, 2012 by Admin

One of the most convenient tools browsers offer is the ability to save and automatically prefill your website login details and passwords. Because so many sites require accounts and it is well known (or should be at least) that using a shared password is a big no-no, a password manager is almost essential and also a handy feature. But what happens if someone is wandering by and decides to start poking around with your browser and vulnerable internet sites?

To protect your website passwords saved in your browser, it’s essential to learn more about the security features built into Firefox, Internet Explorer and Chrome.

It doesn’t matter how secure your passwords are if you’ve allowed a browser to store them with no protection. You’re left doubly unprotected by having no Windows password, as an unattended PC will force the user to log back in but without a password, an intruder is straight in.

Firefox offers good protection in that it can store an encrypted password file on your hard drive, if you ask it nicely. This protects all the log-in user names and passwords with a master password. So if someone happens to be on your computer and fires up the browser, they’ll have to enter your master password before the browser starts to automatically fill in all of your bank details without you.

For Internet Explorer there’s no such direct replacement. There is a Content Advisor that’s designed to block inappropriate content rather than block access to the browser and stored passwords. If you open Internet Options > Content and under Content Advisor click Enable, you’ll be prompted to enter a password and hint.

Initially this is massively annoying as it’ll prompt you for every website. We suggest you set a homepage, so when the browser is first opened the password will be required and you can allow all the other sites. The alternative is to set up blocks just on sites that require passwords.

When it comes to Chrome, security is even more lax: there isn’t any way to password protect access to the browser within Chrome itself. There is an extension called Secure Profile that goes some way to address this. It forces a password to be entered before access to the browser is allowed. However, as it’s an extension it can be disabled by knowledgeable people and due to limits on Java it displays the password being entered. But it does block access and is better than nothing.

Note: If you already forgot website passwords saved in your browser and want to recover them, Password Recovery Bundle is the software that can help you easily recover website logins and passwords stored in Internet Explorer, Firefox, Chrome, Safari, etc. But if your website passwords are protected with a master password, it’s unrecoverable unless you know the master password.

Comments Off on Protect Website Passwords Saved in Your Browser »

Posted in Others, Tips & Tricks

Tags:

Use WinPE to Recover Data from Unbootable System

July 23rd, 2012 by Admin

I’m in a big pinch right now. My computer (32-bit Vista Home Premium sp2) refuses to boot up (it keeps crashing with an error code 0x7b). I don’t care about the computer right now but I need to backup the data inside it. How do we transfer the data from a computer into an external drive when Windows doesn’t even boot up?

How to recover from a crashed system and safely carry out all the important data from a crashed computer? If your PC just won’t boot, or you can’t get into it because it is overrun with viruses, you can use a Windows PE boot CD as a quick way to get access to your files and copy them to another PC, or external drive. The process is simple enough.

How to Recover Data from Unbootable System:

  1. To get data back from any crashed and unbootable system, we need a bootable CD to access all the available partitions on the system. Click the following link to create a Windows PE bootdisk on any accessible computer.

    2. How to Create a Bootable Windows PE CD or USB Flash Drive

  2. Set your crashed or unbootable computer to boot from CD by going to the Computer BIOS.
  3. Once the computer boots off the CD,  it will load the operating system inside the CD. After logging into Windows PE system, you’ll be able to see all the data and files on the hard drive of your crashed or unbootable computer.
  4. Attach an USB or any external storage drive to the system and you can copy and backup all your important files to it.

Personally, I have used this CD on numerous occasions and in most cases, I successfully recovered my files like my Mp3 collections, software and documents files. With a non-booting system, our primary aim is to recover all the data first before trying out any solution since a wrong solution can wipe out all the available data from the hard drive.

Comments Off on Use WinPE to Recover Data from Unbootable System »

Posted in Others, Tips & Tricks

Tags: