U E D R , A S I H C RSS

MySQL/root암호분실시

MySQL .


1.

~cpp 
shell>mysqladmin -u root password ' 호' 

2. ( .)


# , mysql .
~cpp 
shell> killall mysqld 

# . .
~cpp 
shell> safe_mysqld --skip-grant & 

# mysql .
# mysql db root 트 한.

~cpp 
shell> mysql

~cpp 
mysql> use mysql;
mysql> UPDATE user SET password=PASSWORD('호') where user='root';
mysql> FLUSH PRIVILEGES
Valid XHTML 1.0! Valid CSS! powered by MoniWiki
last modified 2021-02-07 05:23:49
Processing time 0.0172 sec