How To Reset MySQL Password

Rai    Linux     change, how-to, Linux, login, mysql, new, password, reset, tip

If you are like me who tend to forget passwords almost every time, then this tip might help you reset your MySQL password just in case.

To begin, you must have access to the server, one that can stop and start the MySQL process, such as a root account. Sudo account can also be used, just as long that the user can control the MySQL service.

Begin the process by stopping the MySQL process. This can be done by executing /etc/init.d/mysqld stop command, but this can vary depending on how you setup your server. Also, be careful of users who might be using the MySQL service as stopping the service might disrupt their work.

Once the MySQL process is killed, execute the following command:

mysqld-safe --skip-grant-tables

This will run the MySQL process so you need to open another terminal to be able to reset the password. On the new terminal, you will now be able to login to MySQL to reset the password.

On the shell prompt of the new terminal, open the MySQL console:

mysql

mysql> use mysql;
mysql> UPDATE user SET Password=PASSWORD(‘YOUR_NEW_PASSWORD’) WHERE Host=’localhost’ AND User=’root’;
mysql> exit

This will change the password for the user ‘root’. Kill the MySQL process running in the first terminal, either by killing the PID or executing CTRL+C. Then start the process again, this time with the proper procedure:

/etc/init.d/mysqld start

Try logging in to the MySQL console using the new password:

mysql –uroot -p

You should now be able to use the new password for your MySQL.

Torvalds: Linux Ready To Go Green

Rai    Linux, News     development, energy saving, environment, fuel efficiency, kernel, linus torvalds, Linux, new

zdnet.co.uk writes:

In an interview at the linux.conf.au conference, Torvalds admitted that Linux was lagging behind on power-management and energy-diagnosis tools.

“It is an area we were pretty weak in a few years ago and just building up the infrastructure took a long time, but now we are at a point where we have most of it done,” said Torvalds.

“That doesn’t mean we are done. Now we have an infrastructure in place… we have the tools to measure power and notice when the power is higher and why that is, which is pretty important. Before, it used to be a black box,” said Torvalds.

Yay for Linus! And also Linux, of course. Linux not only saves the world by promoting freedom of choice but also making computing environment-friendly.