Most Rated Articles

Installing Apache and Apache Modules the easy way

The Essential steps on how to Sysprep Windows 7

SSH is very much similar to telnet. SSH is a shell program which allows a user remote access and the ability to execute commands over a network.

It is important to protect your wireless networks from unwanted and abusive users. Unauthorized users may reduce the bandwidth and may lock up your network

There are many methods on how to optimize apache. It could be on the software side, but upgrading the hardware also makes a difference.

With Windows 7 as a new OS in the market, one may worry about any problems that could be encountered especially network issues such as compatibility with older OS. Windows 7 might encounter problems communicating with older Windows models such as XP. The following are ways on how to network Windows 7 and XP.

One way of installing windows over the network is through the use of RIS or Remote Installation Services. However, you must have the following prerequisites in order to install Windows over the network.

Installing a printer on a mac is just as easy as installing a printer on an OS of Windows. The following steps are just some of the steps on how to connect your printer a Mac operating system.

Nowadays, it is important to have access to Wi-Fi. However, not everyone has their own internet connection so most people leech wherever there is free Wi-Fi. Most routers with Wi-Fi access require passwords but nowadays, there are other places to look around and search for free Wi-Fi.

Some applications cannot install in Windows 7 due to incompatibility issues. A solution would be to enable XP mode in a virtual environment of Windows 7. This configuration may be used to run and install programs that were incompatible in Windows 7.

Database  »  MySQL
 Picture

How to recover the MySQL root password

By: Jerry Slagger
Date Added : June 23, 2009 Views : 935




Did you forget or lose your MySQL root password? No problem, you can easily recover by following these simple steps. Note that this how to is for recovering the MySQL root password on linux servers, such as RedHat, Fedora, CentOS and may other distributions. While this is for linux many of the same steps will work on MySQL that is running on Windows servers.

How to reset the MySQL root password:

1. Log in to the linux servers bash shell as root.
$ su - root

2. Stop the MySQL service.
# mysql stop

3. Start MySQL in safe mode with the -
-skip-grant-tables option.
#
mysqld_safe --skip-grant-tables &

4. Connect to MySQL with the root account.
# mysql -u root

5. Create a new MySQL root password.
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW_PASSWORD") where user='root';
mysql> flush privileges;
mysql> quit

6. Stop the MySQL Server.
# mysql stop

7. Now start the MySQL server in normal mode.
# mysql start

That's it. You should now be able to login to the MySQL server using the root account.

# mysql -u root -p




Comments

anonymous , 2009-06-26 16:16:45
These steps worked great for me. I used this to reset the mysql root password after I forgot it. Thanks!

Article Categories