create database arun_test;
Delete a database.mysql> create database arun_test;
Query OK, 1 row affected (0.01 sec)
mysql>
drop database arun_test;
Delete a DATABASE USERmysql> drop database arun_test;
Query OK, 0 rows affected (0.09 sec)
mysql>
Code: Select all
mysql> DROP user gautham_osc2@localhost;
Code: Select all
mysql> select User, Host from user where User like '%gautham_osc2%';
+--------------+-------------+
| User | Host |
+--------------+-------------+
| gautham_osc2 | 192.168.1.% |
| gautham_osc2j | 192.168.1.% |
| gautham_osc2j | localhost |
+--------------+-------------+
3 rows in set (0.00 sec)
Code: Select all
mysql>
mysql> DROP user gautham_osc2@'192.168.1.%';
Query OK, 0 rows affected (0.02 sec)
mysql>