untuk cek user
SELECT * FROM mysql.user;
buat user; '%' agar bisa diakses semua ip/ alamat
CREATE USER 'dbremote'@'%' IDENTIFIED BY 'password_user';
set password
SET PASSWORD FOR 'dbremote'@'%' = PASSWORD('developer1!');
memberikan hak akses ke semua db
GRANT ALL PRIVILEGES ON *.* TO 'dbremote'@'%';
0 Komentar