Basic commands

Post Reply
a24uall
Site Admin
Posts: 166
Joined: Sun Jul 01, 2012 9:07 am

Basic commands

Post by a24uall »

Create a a database using mysql prompt.
create database arun_test;
mysql> create database arun_test;
Query OK, 1 row affected (0.01 sec)

mysql>
Delete a database.
drop database arun_test;
mysql> drop database arun_test;
Query OK, 0 rows affected (0.09 sec)

mysql>
Delete a DATABASE USER

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>
Arun
WebhostingDevelopment.com
Post Reply

Return to “Mysql Basic Commands”