070-8260-2526

9 ~ 6

352-0331-1626-83

:ũڸ


ֹ
Ȩ > > ֹ

ȸ 7991
$ mysql -u root Error 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
  ٸ 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 [ؾߵǴµ]