-
-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathSetUpSql
42 lines (24 loc) · 1.07 KB
/
SetUpSql
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
sudo pacman -S mariadb
sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
sudo systemctl enable mariadb.service
sudo systemctl start mariadb.service
sudo mysql_secure_installation
./ reboot system
sudo mysql -u root -p
mairadb [(none)]:- CREATE DATABASE SW;
On 'SW' --- "write your database name"
mairadb [(none)]:- CREATE USER 'suno'@'localhost' IDENTIFIED BY 'db_pasword';
On 'username' --- "write your username"
On 'some_pass' --- "write your password"
MariaDB [(none)]:- GRANT ALL PRIVILEGES ON *.* TO 'suno'@'localhost';
flush privileges;
quit
mysql -u suno -p db_pasword < /home/suno/Downloads/SQL/SQL.sql
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> create user 'Su'@'localhost' identified by 'pass';
Query OK, 0 rows affected (0.022 sec)
MariaDB [(none)]> grant all privileges on *.* to 'Su'@'localhost';
Query OK, 0 rows affected (0.015 sec)
MariaDB [(none)]> exit;
Bye