mysql -hhostname -uusername -ppassword db_name -e 'query to execute;'
- hostname – the host on which MySQL is installed
- username – the MySQL user that has the necessary privileges over the database
- passsword – the MySQL user password
- db_name – the name of the MySQL database that you want to query
- -e – MySQL option which will execute the statement and quit
- query to execute; – the MySQL query you want to execute enclosed in single quotes
apg is a handy utility for creating random passwords / strings. To install it run:
apt-get install apg
The below for loop will create 300 random usernames / email addresses in the format email@example.com. You can always replace “domain” with “$i” , then you’ll have addresses in the format firstname.lastname@example.org.
-M – specifies that mode will be used
L – use small letters only mode
-n – number of passwords/random strings, in this case 300
for i in $(apg -M L -n 300); do echo $email@example.com >> fileToSaveResult ; done