MySql: Change Root Password

1. Use Mysqladmin Command To Change Root  User Password

If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:

$ mysqladmin -u root password NEWPASSWORD

However, if you want to change (or update) a root password, then you need to use following command

$ mysqladmin -u root -p oldpassword newpass

Enter password:

2.  Reset /Recover MySQL Root Password

In case you can not remember the root password, following steps can be used to reset the password.
Here are commands you need to type for each step (login as the root user):

 Step # 1 : Stop mysql service

# /etc/init.d/mysql stop

Output:

Stopping MySQL database server: mysqld.

Step # 2: Start to MySQL server w/o password:

# mysqld_safe --skip-grant-tables;

Output:

[1] 5988

Starting mysqld daemon with databases from /var/lib/mysql

mysqld_safe[6025]: started

Step # 3: Connect to mysql server using mysql client:

# mysql -u root

Output:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 1 to server version: 5.0.1

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>

Step # 4: Setup new MySQL root user password

mysql> use mysql;

mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';

mysql>flush privileges;

mysql>quit

Step # 5: Stop MySQL Server:

# /etc/init.d/mysql stop

Output:

Stopping MySQL database server: mysqld

STOPPING server from pid file /var/run/mysqld/mysqld.pid

 Step # 6: Start MySQL server and test it

# /etc/init.d/mysql start

# mysql -u root -p

Enter password.

All Online Data Lost

All Online Data Lost After Internet Crash!!!

Linux Admin Tool: Iostat

The iostat command at its most basic provides an overview of CPU and disk I/O statistics:

#iostat

iostat
Linux 2.4.21-32.ELsmp (dw1.corp.co.com) 03/30/2007
avg-cpu: %user %nice %sys %iowait %idle
4.10 0.01 1.26 4.69 89.94

Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
cciss/c0d0 19.43 24.51 27.90 726081316 826335200
cciss/c0d0p1 16.75 17.37 110.99 514613362 3287372808
cciss/c0d0p2 2.57 6.44 60.75 190884490 1799215720
cciss/c0d0p3 0.10 0.69 1.17 20583160 34713968

Below the first line (which contains the system's kernel version and hostname, along with the current date), iostat displays an overview of the system's average CPU utilization since the last reboot. The CPU utilization report includes the following percentages:

· Percentage of time spent in user mode (running applications, etc.)
· Percentage of time spent in user mode (for processes that have altered their scheduling priority using nice(2))
· Percentage of time spent in kernel mode
· Percentage of time spent idle

Below the CPU utilization report is the device utilization report. This report contains one line for each active disk device on the system and includes the following information:

· The device specification, displayed as dev-sequence-number, where is the device's major number[1], and is a sequence number starting at zero.
· The number of transfers (or I/O operations) per second.
· The number of 512-byte blocks read per second.
· The number of 512-byte blocks written per second.
· The total number of 512-byte blocks read.
· The total number of 512-byte block written.

This is just a sample of the information that can be obtained using iostat. For more information, refer to the iostat(1) man page.