用root用户进入系统
[root@localhsot]# mysql -u root -p
mysql> show databases;
mysql> use cacti;
mysql> show tables;
mysql> select from user_auth;
mysql> update user_auth set
password=md5("cactipasswd") where id='1';
现在cacti新密码就是cactipasswd
实例如下:
[root@localhost ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL
monitor. Commands end
with ; or \g.
Your MySQL connection id is 28
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use cacti;
Reading table information for completion of table and column
names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user_auth set
password=md5("cactipasswd") where id='1';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed:
1 Warnings: 0
mysql> quit;
Bye
[root@localhost ~]#
只做为学习记录,老鸟小鸟一起飞过。