Following are the few best practices and basic commands for MySQL Administration.
MySQL Access and credential security
shell> mysql -u testuser -pMyP@ss0rd
mysql: [Warning] Using a password on the command line interface can be insecure.
By looking at OS cmd’s history using history cmd other os users can see/get MySQL user password easily. It always good to not use a password on the command line interface. Another option for securing password while automating MySQL scripts is a use of mysql_config_editor. For more info on this check out my blog post about credential security.
Consider of having following implementation for Strong access policy.
- use of validate_password plugin for a strong password policy.
- Limit …