티스토리 뷰

IT관련

MySql 운영자 비번 바꾸기

밥상머리 2016. 11. 5. 15:27

[root@localhost /]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1410922

Server version: 5.0.77-log Source distribution


Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


mysql> use mysql

Database changed

mysql> update user set password=password('새로운비번') where user='root';

Query OK, 2 rows affected (0.00 sec)

Rows matched: 2  Changed: 2  Warnings: 0


mysql> flush privileges;

Query OK, 0 rows affected (0.02 sec)

댓글
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
링크
«   2024/11   »
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
글 보관함