MySQL Security

mysqldump - MySQL Database Backup Program

To see available option run the command: "mysqldump --help" or "mysqldump -?"

There are 3 general ways to invoke mysqldump (note: You need to have MySQL running):

c:\> mysqldump [options] db_name [tables]
c:\> mysqldump [options] --databases db_name1 [db_name2 db_name3...]
c:\> mysqldump [options] --all-databases or c:\> mysqldump [options] -A
If you do not name any tables following db_name or if you use the --databases or --all-databases option, entire databases are dumped.

ex: mysqldump --add-drop-table -u[username] -p[password] [database] > [backup_file]


If this is enabled, a user can't create new users with the GRANT statement, if the user doesn't have the INSERT privilege for the mysql.user table or any column in the table.
I'm running with: safe-user-create