-
Notifications
You must be signed in to change notification settings - Fork 1
/
db.sh
48 lines (38 loc) · 1 KB
/
db.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
apt update
apt upgrade -y
apt install figlet -y
apt install ruby
gem install lolcat
echo "Installing python and modules for sql connection" | lolcat
apt install python -y
pip install SQLAlchemy
pip install PyMySQL
pip install mysql-connector
apt-get update --fix-missing
apt install mariadb
pkg install mariadb
cd /data/data/com.termux/files/usr/etc
if [ -d /data/data/com.termux/files/usr/etc ]
then
echo "Folder 'my.cnf.d' exists"
else
echo "making folder 'my.cnf.d"
mkdir my.cnf.d
fi
mysql_install_db
echo "mysqld_safe -u root &" > /data/data/com.termux/files/usr/bin/sql
chmod +x /data/data/com.termux/files/usr/bin/sql
cd
mysqld_safe -u root &
figlet "copy paste the lines below" | lolcat
echo ""
echo "copy paste the lines below which are colourful " | lolcat
echo ""
echo "CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; " | lolcat
echo ""
echo "GRANT ALL PRIVILEGES ON * . * TO 'username'@'localhost';" | lolcat
echo ""
echo "exit" | lolcat
echo ""
echo "mysql -u [username] -p" | lolcat
mysql