Mysql reads and runs commands through documents to quickly add multiple users and databases to mysql _ MySQL

Mysql reads and runs commands through documents to quickly add multiple users and databases to mysql.

# Vi mysqlusers.txt

Create databaseDataname;
Grant all privileges onDataname. *Username@ Localhost identified'Password';
Flush privileges;

#/Usr/local/mysql/bin/mysql-u root-pPassword<Mysqlusers.txt

The blue italic part is the corresponding user name and password. to add multiple users and databases, you only need to copy the code in the middle and modify the corresponding location, for example:
Create databaseDataname1;
Grant all privileges onDataname1. *Username1> @ Localhost "identified'Password';
Flush privileges;

Create databaseDataname2;
Grant all privileges onDataname2. *Username2> @ Localhost "identified'Password';
Flush privileges;