SELECT * FROM mysql.user ;


nambah ip tertentu yg bisa remote

CREATE USER 'root'@'0.0.0.0' IDENTIFIED BY '';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'0.0.0.0';


buat semua ip bisa remote

CREATE USER 'root'@'%' IDENTIFIED BY '';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';


kemudian flush

FLUSH PRIVILEGES;