sm4rtn0bit4

mariaDB auto configure debian

Aug 25th, 2017
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.79 KB | None | 0 0
  1. #!/bin/bash
  2. apt-get install figlet --yes
  3. figlet MARIADB
  4. xterm -title "PACKAGES FOR MARIADB"  -e apt-get install mariadb-client* mariadb-server* --yes
  5. firewall-cmd --add-service=mysql --permanent
  6. firewall-cmd --reload
  7. systemctl start mysql
  8. systemctl enable mariadb
  9. xterm -title "SETTING UP" -e  mysql_secure_installation
  10. xterm -title "ROOT PASSWORD FOR CONFIG" -e  read $db_pass
  11. mysql -u root --password="$db_pass" -Bse "CREATE DATABASE rtps;
  12. USE rtps;
  13. 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) );
  14. create user 'test'@'localhost' identified by 'Lokendra143';
  15. GRANT SELECT,INSERT,UPDATE,DELETE ON rtps.* TO 'test'@'localhost';
  16. EXIT"
  17. systemctl restart mysql
Add Comment
Please, Sign In to add comment