Database changed
MYSQL> show tables;
+---------------------------------------+
| Tables_in_information_schema |
+---------------------------------------+
| CHARACTER_SETS |
| COLLATIONS |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS |
| COLUMN_PRIVILEGES |
| KEY_COLUMN_USAGE |
| PROFILING |
| ROUTINES |
| SCHEMATA |
| SCHEMA_PRIVILEGES |
| STATISTICS |
| TABLES |
| TABLE_CONSTRAINTS |
| TABLE_PRIVILEGES |
| TRIGGERS |
| USER_PRIVILEGES |
| VIEWS |
+---------------------------------------+
17 rows in set (0.01 sec)
MYSQL> select distinct grantee from user_privileges;
+--------------------+
| grantee |
+--------------------+
| 'root'@'localhost' |
| 'root'@'dbro101' |
| 'rc'@'localhost' |
| ''@'dbro101' |
| ''@'localhost' |
| 'rc'@'%' |
| 'redcarpet'@'%' |
| 'sdc_updater'@'%' |
+--------------------+
8 rows in set (0.01 sec)
MYSQL> CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';
MYSQL> GRANT ALL ON *.* TO 'jeffrey'@'localhost';
No comments:
Post a Comment