ٸ mysql password ؾѴ ( rhel 5.6ȯ)
# service mysqld stop
# cd /usr/bin
# mysqld_safe --skip-grant-tables
# mysql
mysql> use mysql;
mysql> UPDATE user SET password=PASSWORD('YOUR_NEW_PASSWORD_HERE')
WHERE user = 'root';
mysql> exit;
# service mysqld start
# mysql ERROR 2002 (HY000): Can't connect to local MySQL server throught socket '/tmp/mysql.sock' (2)
ٸ
'/tmp/mysql.sock' ۹̼ غñ ٶϴ
Ǵ
root Ͻ
ps -ax|grep mysqld
Ȥ
ps -ax|grep mysql
ؼ
mysqld_safe --ɼ
ִ ȮϽñ
Ǿִµ پȵȴٸ
netstat -an|grep LIST
ϼż mysql Ʈ ȮϽñ ٶϴ.
Ȯϼ̴µ ̻ ִٸ...
cd /usr/local/mysql/bin
./safe_mysqld &
Ȥ
./mysqld_safe &
ֽŴ
/etc/rc.d/rc.local
/usr/local/mysql/bin/mysqld_safe &
õɶ öü ֵ ֽñ ٶϴ.
ó:
http://simit.tistory.com/34 [ؾߵǴµ]