MYSQL Command should remember

This is just to save some mysql command that sometimes I forget. The store is good for me when I need to look back and copy paste.

1. Faster import sql file

Export and Compress sql file:

Decompress and Import:

Create new user and pass:

Grant privileges:

List of the “in progress” process: