MYSQL Syntax

Perintah install mysql Server
$ sudo apt install -y mysql-server
$ sudo systemctl start mysql
$ sudo systemctl enable mysql
$ sudo systemctl status mysql
$ sudo mysql_secure_installation

Ikuti instruksi:
Reload privilege tables (Y)
Set root password (Y)Tingkatan Password (2)
Hapus anonymous users (Y)
Nonaktifkan remote login (Y)
Hapus test database (Y)

Masuk kedalam MySQL Database
$ sudo mysql
Buat Database baru
$ mysql> CREATE DATABASE my_company;
Buat User Baru
$ mysql> CREATE USER ‘my_admin’@’localhost’ IDENTIFIED BY ‘password_anda’;
Memberikan akses pada database dan user
$ mysql> GRANT ALL PRIVILEGES ON my_admin.* TO ‘my_admin’@’localhost’;
Flush Database
$ mysql> FLUSH PRIVILEGES;
keluar dari MySQL
$ exit/exit;

Perintah Impor database melalui terminal ubuntu
$ mysql -u <username> -p <database_name> < /path/to/your_database_file.sql