Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- apt-get install figlet --yes
- figlet MARIADB
- xterm -title "PACKAGES FOR MARIADB" -e apt-get install mariadb-client* mariadb-server* --yes
- firewall-cmd --add-service=mysql --permanent
- firewall-cmd --reload
- systemctl start mysql
- systemctl enable mariadb
- xterm -title "SETTING UP" -e mysql_secure_installation
- xterm -title "ROOT PASSWORD FOR CONFIG" -e read $db_pass
- mysql -u root --password="$db_pass" -Bse "CREATE DATABASE rtps;
- USE rtps;
- CREATE TABLE users( user_id int(5) AUTO_INCREMENT PRIMARY KEY , user_name varchar(20) NOT NULL , user_pass varchar(35) NOT NULL , user_email varchar(40) NOT NULL , user_uuid varchar(40) );
- create user 'test'@'localhost' identified by 'Lokendra143';
- GRANT SELECT,INSERT,UPDATE,DELETE ON rtps.* TO 'test'@'localhost';
- EXIT"
- systemctl restart mysql
Add Comment
Please, Sign In to add comment