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;
0 Komentar