mysql table size 변경
programming/mysql 2012. 4. 18. 13:39 |'programming > mysql' 카테고리의 다른 글
| 시작/종료 (0) | 2012.04.10 |
|---|---|
| mysql원격접근 (0) | 2012.01.27 |
| root비번을 잊어버렸을때.. (0) | 2011.10.09 |
'programming/mysql'에 해당되는 글 4건
- 2012.04.18 mysql table size 변경
- 2012.04.10 시작/종료
- 2012.01.27 mysql원격접근
- 2011.10.09 root비번을 잊어버렸을때..
시작/종료
programming/mysql 2012. 4. 10. 21:03 |내꺼
루트에서
/mysql/bin/mysql_safe &
종료
/mysql/bin/mysqladmin shutdown -p
'programming > mysql' 카테고리의 다른 글
| mysql table size 변경 (0) | 2012.04.18 |
|---|---|
| mysql원격접근 (0) | 2012.01.27 |
| root비번을 잊어버렸을때.. (0) | 2011.10.09 |
mysql원격접근
programming/mysql 2012. 1. 27. 17:57 |'programming > mysql' 카테고리의 다른 글
| mysql table size 변경 (0) | 2012.04.18 |
|---|---|
| 시작/종료 (0) | 2012.04.10 |
| root비번을 잊어버렸을때.. (0) | 2011.10.09 |
root비번을 잊어버렸을때..
programming/mysql 2011. 10. 9. 12:31 |service mysql stop
wait until MySQL shuts down. Then run
mysqld_safe --skip-grant-tables &
then you will be able to login as root with no password.
mysql -uroot mysql
In MySQL command line prompt issue the following command:
UPDATE user SET password=PASSWORD("abcd") WHERE user="root";
FLUSH PRIVILEGES;
EXIT
/etc/init.d/mysqld restart
At this time your root password is reset to "abcd" and MySQL will now
know the privileges and you'll be able to login with your new password:
mysql -uroot -p mysq
http://translate.google.co.kr/translate?hl=ko&sl=en&tl=ko&u=http%3A%2F%2Fforums.vpslink.com%2Fcentos%2F1264-mysql-root-default-password.html&anno=2
wait until MySQL shuts down. Then run
mysqld_safe --skip-grant-tables &
then you will be able to login as root with no password.
mysql -uroot mysql
In MySQL command line prompt issue the following command:
UPDATE user SET password=PASSWORD("abcd") WHERE user="root";
FLUSH PRIVILEGES;
EXIT
/etc/init.d/mysqld restart
At this time your root password is reset to "abcd" and MySQL will now
know the privileges and you'll be able to login with your new password:
mysql -uroot -p mysq
http://translate.google.co.kr/translate?hl=ko&sl=en&tl=ko&u=http%3A%2F%2Fforums.vpslink.com%2Fcentos%2F1264-mysql-root-default-password.html&anno=2
'programming > mysql' 카테고리의 다른 글
| mysql table size 변경 (0) | 2012.04.18 |
|---|---|
| 시작/종료 (0) | 2012.04.10 |
| mysql원격접근 (0) | 2012.01.27 |