[root@Linux_win vsftpd]# mysql -u root mysql -p mysql>grant select on vsftpdvirtual.users to vsftpdvirtual@localhost identified by '123456'; mysql>quit
验证刚才的操作是否成功可以执行下面命令:
代码:
[root@Linux_win vsftpd]# mysql -u vsftpdvirtual -p123456 ftpdvirtual mysql>select * from users;
如果成功,将会列出wing、wingger和加密后的密码。 如下所示:
引用:
mysql> select * from users; +---------+------------------+ | name | passwd | +---------+------------------+ | win | 23932fe477657768 | | wingger | 23932fe477657768 | +---------+------------------+ 2 rows in set (0.00 sec)