# vi mysqlusers.txt create database dataname; grant all privileges on dataname.* to username@localhost identified by ‘password‘; flush privileges; # /usr/local/mysql/bin/mysql -u root -p password < mysqlusers.txt
create database dataname1; grant all privileges on dataname1.* to username1>@localhost” identified by ‘password‘; flush privileges; create database dataname2; grant all privileges on dataname2.* to username2>@localhost” identified by ‘password‘; flush privileges;
