Step # 1 : Stop mysql service
\n# \/etc\/init.d\/mysqld stop<\/p>\n
Output:
\nStopping MySQL database server: mysqld.\/<\/p>\n
Step # 2: Start to MySQL server w\/o password:
\n# mysqld_safe –skip-grant-tables &<\/p>\n
Output:
\n[1] 5988
\nStarting mysqld daemon with databases from \/var\/lib\/mysql
\nmysqld_safe[6025]: started<\/p>\n
Step # 3: Connect to mysql server using mysql client:
\n# mysql -u root<\/p>\n
Output:
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 1 to server version: 4.1.15-Debian_1-log
\nType ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the buffer.
\nmysql><\/p>\n
Step # 4: Setup new MySQL root user password (\ud2b9\uc218\ubb38\uc790 \ubd88\uac00 !@#$%^&*)
\nmysql> use mysql;
\nmysql> update user set password=PASSWORD(“NEW-ROOT-PASSWORD”) where User=’root’;
\nmysql> flush privileges;
\nmysql> quit<\/p>\n
\ucd94\uac00<\/span> # ps -ef | grep mysqld<\/span> Step # 6 * Test \uc2e4\uc218\ub85c \uacc4\uc815 \uc0ad\uc81c\uc2dc :<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":"
\n Step # 5<\/span>
\n \uc2e4\ud589\uc911\uc778 mysql \ub2e4\uc2dc \uc885\ub8cc(* \uc911\uc694 : \uad8c\ud55c \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \ub370\ubaac\uc744 \uc885\ub8cc) \ud558\uc9c0 \uc54a\uc73c\uba74 mysql \ud558\uba74 \ubc14\ub85c \ub4e4\uc5b4\uac10<\/span><\/p>\n
\nroot 12084 11558 0 20:10 pts\/2 00:00:00 sh .\/mysqld_safe –skip-grant-ta
\nroot 12090 12084 0 20:10 pts\/2 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld
\nroot 12092 12090 0 20:10 pts\/2 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld
\nroot 12093 12092 0 20:10 pts\/2 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld
\n#
\n# killall mysqld<\/span>
\nmysqld daemon ended
\n[1]+ Done .\/mysqld_safe –skip-grant-tables
\n#<\/p>\n
\nMysql \ub370\ubaac \uc7ac \uc2e4\ud589 \ud6c4 \uac31\uc2e0\ub41c \ud328\uc2a4\uc6cc\ub4dc\ub85c \ub85c\uadf8\uc778<\/p>\n
\n: Start MySQL server and test it
\n# \/etc\/init.d\/mysqld start
\n# mysql -u root -p<\/p>\nchown: `mysql:mysql': invalid user<\/em><\/pre>\n
# yum --enablerepo=\\* --disablerepo=c5-media groupinfo 'MySQL Database'<\/pre>\n