How to Modify MySQL Startup Script, Reset Root Password, and Restore Settings on Linux

1. Modify MySQL server script

~]# vi /etc/rc.d/init.d/mysqld
# locate $bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null 2>&1 & wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?
# add --skip-grant --skip-networking after this line

$bindir/mysqld_safe --datadir="$datadir" --skip-grant --skip-networking --pid-file="$mysqld_pid_file_path" $other_args >/dev/null 2>&1 &
wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?

2. Restart MySQL service

# service mysqld restart

3. Update or modify MySQL root user password

~]# mysql> USER mysql
~]# mysql> UPDATE user SET password=PASSWORD('mypasshao') WHERE user='root';

4. Remove --skip-grant and --skip-networking from MySQL startup script

# vi /etc/rc.d/init.d/mysqld
# find the following line:
$bindir/mysqld_safe --datadir="$datadir" --skip-grant --skip-networking --pid-file="$mysqld_pid_file_path" $other_args >/dev/null 2>&1 &
wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?
# delete --skip-grant and --skip-networking

5. Restart MySQL service again

# service mysqld restart