mysql root 계정 원격 허용 Mysql

mysql> GRANT ALL PRIVILEGES ON *.* to root@"%" IDENTIFIED BY '패스워드'  WITH GRANT OPTION;
mysql> flush privileges
mysql> select * from user where User = 'root'


※. localhost만 접속 가능
mysql> GRANT ALL PRIVILEGES ON *.* to root@"localhost" IDENTIFIED BY '패스워드'  WITH GRANT OPTION;

Leave Comments



T-NAVI