MariaDB 10.5 원격 접속 쿼리

1. 방법1 (DCL)

GRANT ALL PRIVILEGES ON *.* TO '아이디'@'%' IDENTIFIED BY '비밀번호';

FLUSH PRIVILEGES;

 

 

2. 방법2 (DML)

INSERT INTO mysql.user (host,user,authentication_string,ssl_cipher, x509_issuer, x509_subject) VALUES ('%','아이디',password('패스워드'),'','',''); GRANT ALL PRIVILEGES ON *.* TO '아이디'@'%';

FLUSH PRIVILEGES;