# mysql -u root -p mysql> select User,HOST,Password from mysql.user; +--------------+---------------------+------------------+ | User | HOST | Password | +--------------+---------------------+------------------+ | root | localhost | 284e59d71f64e3ec | | root | vaio.mydomain.co.jp | 284e59d71f64e3ec | | vpopmailuser | localhost | 7d60b94d42e45b72 | | xoops | localhost | 3cf31278467575ed | | stats | localhost | 3cf31278467575ed | +--------------+---------------------+------------------+ 6 rows in set (0.00 sec)
mysql> GRANT ALL ON vpopmail. * TO vpopmailuser@'192.168.1.%' IDENTIFIED BY "vpopmailpass"; Query OK, 0 rows affected (0.00 sec)
mysql> select User,HOST,Password from mysql.user; +--------------+---------------------+------------------+ | User | HOST | Password | +--------------+---------------------+------------------+ | root | localhost | 284e59d71f64e3ec | | root | vaio.mydomain.co.jp | 284e59d71f64e3ec | | vpopmailuser | localhost | 7d60b94d42e45b72 | | xoops | localhost | 3cf31278467575ed | | stats | localhost | 3cf31278467575ed | | vpopmailuser | 192.168.1.% | 7d60b94d42e45b72 | +--------------+---------------------+------------------+ 6 rows in set (0.00 sec) mysql> select Host,Db,User from db; +-------------+------------+--------------+ | Host | Db | User | +-------------+------------+--------------+ | 192.168.1.% | vpopmail | vpopmailuser | | localhost | phpstats | stats | | localhost | vpopmail | vpopmailuser | | localhost | xoops | xoops | +-------------+------------+--------------+ 9 rows in set (0.01 sec)
$ mysql -h [hostname] -u [username] -p[password]
mysql> DELETE FROM mysql.user WHERE user='vpopmailuser' and host='192.168.1.%'; mysql> FLUSH PRIVILEGES;