User Rights List
-
SELECT
-
Query Permissions
-
INSERT
-
Insert Permissions
-
UPDATE
-
Update Permissions
-
DELETE
-
Delete permission (to delete data)
-
CREATE
-
Create Permissions
-
DROP
-
Delete permission (user delete file)
-
RELOAD
-
perform flush-hosts, Flush-logs, Flush-privileges, Flush-status, Flush-tables, flush-threads, refresh, reload, and other command permissions
-
SHUTDOWN
-
Turn off database permissions
-
PROCESS
-
View process Permissions
-
FILE
-
file access Permissions
-
GRANT
-
granting Permissions
-
REFERENCES
-
Referential Permissions
-
INDEX
-
Index Permissions
-
Alter
-
Change Permissions
User Login method
MySQL Login Parameters
| -D,--Database=name |
Open the specified database |
| --delimiter=name |
Specify delimiter |
| -H,--Host=name |
Server name |
| -P,--Password[=name] |
Password |
| --prompt=name |
Set prompt |
| -U,--user=name |
User name |
| -P,--port=127.0.0.1 |
Port number |
| -V,--version |
Output version Information |
MySQL quit three ways
quit、\q、exit
MySQL permissions and login, Exit methods
