MySQL 권한설정

MySQL 원격접속

 

http://blog.naver.com/itkmj/220898960514

 

 

 

MySQL 권한설정

 

- 계정생성. localhost or %(원격접속허용)

create user 'hkd'@'%' identified by '1234'; 

 

-- 계정생성 확인

use mysql;

 

select  * from user;

 

-- 권한 설정. db명.테이블명

grant all privileges on *.* to 'hkd'@'%' identified by '1234';

 

grant all privileges on *.* to 'hkd'@'%' with grant option; -- 8.X버젼용

 

-- grant select on *.* to 'hkd'@'%' identified by '1234';