Skip to content
Snippets Groups Projects
99-permitions.sh 649 B
Newer Older
#!/bin/bash 
MRP=$MYSQL_ROOT_PASSWORD
echo "CREATE USER IF NOT EXISTS 'smartdata_admin' IDENTIFIED BY '$MYSQL_PASSWORD';"	| mysql -u root --password=$MRP
echo "CREATE USER IF NOT EXISTS 'smartdata' IDENTIFIED BY '$MYSQL_PASSWORD';"	 	| mysql -u root --password=$MRP
echo "CREATE USER IF NOT EXISTS 'tutorial' IDENTIFIED BY '$MYSQL_PASSWORD';" 		| mysql -u root --password=$MRP

echo "GRANT ALL PRIVILEGES ON *.* TO 'smartdata_admin';" 				| mysql -u root --password=$MRP
echo "GRANT ALL PRIVILEGES ON *.* TO 'smartdata';" 					| mysql -u root --password=$MRP
echo "GRANT ALL PRIVILEGES ON *.* TO 'tutorial';"				    	| mysql -u root --password=$MRP