分类：
2008-09-18 11:34:47
[root@RHEL4 www]# mysql -uvpopmail -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 24 to server version: 4.1.7
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+----------+
| Database |
+----------+
| test |
| vpopmail |
+----------+
2 rows in set (0.01 sec)
mysql> \q
Bye
[root@RHEL4 domains]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 26 to server version: 4.1.7
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use vpopmail
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> select * from vpopmail;
+------------+-----------+---------------------------------+--------+--------+------------+--------------------------------------------+-----------+-----------------+
| pw_name | pw_domain | pw_passwd | pw_uid | pw_gid | pw_gecos | pw_dir | pw_shell | pw_clear_passwd |
+------------+-----------+---------------------------------+--------+--------+------------+--------------------------------------------+-----------+-----------------+
| super | xpc.com | $1$UgxlJ$Lb6YjN7QVF0Mx.Q4bUZHT/ | 0 | 0 | super | /home/vpopmail/domains/xpc.com/super | 52428800s | |
| postmaster | xpc.com | $1$QkpPn$BwIA9pE.vKZbIVQskZb5s. | 0 | 0 | Postmaster | /home/vpopmail/domains/xpc.com/postmaster | 52428800s | |
| xy | xpc.com | $1$SkiIB$xSpdValKj8K.tHLmL9ZVJ/ | 0 | 0 | xy | /home/vpopmail/domains/xpc.com/xy | 52428800s | |
| postmaster | xyie.com | $1$Y7Na.$9E3f34RZ79xvxfMiVNY1C0 | 0 | 0 | Postmaster | /home/vpopmail/domains/xyie.com/postmaster | 52428800s | 123456 |
| xy | xyie.com | $1$WEkYx$zSCD/J7GlIh86GEvaCSDD1 | 0 | 0 | xy | /home/vpopmail/domains/xyie.com/xy | 52428800s | |
+------------+-----------+---------------------------------+--------+--------+------------+--------------------------------------------+-----------+-----------------+
5 rows in set (0.00 sec)
mysql> \q
Bye
