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