Sunday, August 19, 2012

create database , user and grant priviliges on MySQL?

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| portaldb           |
| test               |
+--------------------+
4 rows in set (0.01 sec)

mysql> create database schooldb;
Query OK, 1 row affected (0.01 sec)

mysql> create user suser@'localhost' identified by 'suser123';
Query OK, 0 rows affected (0.06 sec)

mysql> grant all on scholldb.* to suser@'localhost';
Query OK, 0 rows affected (0.02 sec)


No comments:

Post a Comment