Konten [Tampil]
1. create database
2. create user akses mysql
3. import database
4. setup url dbeaver
CREATE USER 'user_dev'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'user_dev'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
--------------------------
import data ;
mysql -u root -p yesjitu_locale < ~/Downloads/dumpdata/db\ staging/dump-yesjitu_db-new-202503201755.sql
--------------------------
GRANT ALL PRIVILEGES ON yesjitu_locale.* TO 'yesjitudb'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
--------------------------
di dbeaver:
jdbc:mysql://103.189.235.30:3306/yesjitu_db-new?allowPublicKeyRetrieval=true&useSSL=false