Common MySQL operation commands

1. "Change Password"

Enter MySQL, using the command: SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' new password ');

2. "Authorization"

GRANT SELECT, INSERT, DELETE, UPDATE on database name to user @ip (IP address that allows access to database) identified by ' Database password ';

Use this command to create a database user at the same time;

For example: Allow the Admin user to access the database sale_db from 10.21.0.24, access password is 123456;

GRANT SELECT, INSERT, DELETE, UPDATE on sale_db to [e-mail protected] identified by ' 123456 ';

Common MySQL operation commands