<div id="readability-page-1" class="page"><div>
                <div id="SE-99fe1300-59da-4af1-9273-6bd8e6a21551">
                                    <p id="SE-ecbbf316-b99b-46e9-993d-f4c7386cec0c"><span id="SE-da6a9444-29e5-4a5e-9497-84d2a678ea30"><b>1. 셸 진입 및 준비</b></span></p><p id="SE-72e0e339-4702-4a79-8153-b006d392cd6e"><span id="SE-81136b34-3236-4ea8-88c1-c53b27022426">​</span></p><p id="SE-a37c2afe-d40d-4daf-a66a-b03c94c2bb67"><span id="SE-e88df1e4-4fd3-471d-b8a1-05ceb8dd2d53">- root 로 mysql 셸 진입</span></p>
                            </div>                                                                                <div id="SE-e363f7e6-24f1-437f-9386-e06ca28812b2">
                                    <p>$ select user,host from user;

+------------------+-----------+
| user             | host      |
+------------------+-----------+
| trans_log        | %         |
| admin            | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
6 rows in set (0.00 sec)</p>
                                </div>                <div id="SE-c6bb338d-d5f9-47f8-b9f7-1fbbd8bc9a30">
                                    <p id="SE-394e2115-e25d-4530-a231-dd063f451533"><span id="SE-953fa425-4459-4273-b187-3fdb4fc11f9f">​</span></p><p id="SE-edc910c9-b4b2-4d21-93ed-172844519ac5"><span id="SE-40b08946-8235-4127-b2dd-b813ff1db092"><b>2. User 생성</b></span></p><p id="SE-dc38eb3c-d027-4c3c-abff-60897a243e16"><span id="SE-0ef49529-8279-48ee-830a-974960b5200b">​</span></p><p id="SE-8d36067d-0224-404d-830b-6f89f43bd34a"><span id="SE-2644134b-b4bf-4b6c-a259-03ddfd1d7b7c">- localhost (mysql 서버) 에서 셸을 통한 접근만 허용하려면 유저명@localhost 로 한다.</span></p>
                            </div>                <div id="SE-2f54588c-e25a-4135-a080-264fa5ea96c5">
                                    <p>$ CREATE USER writer0713@localhost IDENTIFIED BY 'password';</p>
                                </div>                <div id="SE-aa753de0-99dd-409f-99a0-bcdeafa2e5b2">
                            <p id="SE-de361868-1694-4660-aca6-6b129e3f3393"><span id="SE-228da7ab-3f28-4277-905e-07b2cd3b1f3e">- 외부에서 접근 (client) 을 허용하려면 localhost 대신 '%' 를 적자.</span></p>
                        </div>                <div id="SE-094637f0-bb67-4f22-b165-f99826b1e294">
                                    <p>$ CREATE USER 'writer0713'@'%'IDENTIFIED BY 'password';</p>
                                </div>                <div id="SE-bc29491b-8ec9-4537-b860-f1a5579cb337">
                                    <p id="SE-d88afe08-8edd-4ab5-acb9-6e76020eab05"><span id="SE-88946dc5-82a9-4403-95d5-4da52330ec8e">​</span></p><p id="SE-1ebf81dc-d07d-4de7-adc1-48d0a5d18123"><span id="SE-b7c47ba8-8d51-4cca-8e5f-8a1a0b929077">​</span></p><p id="SE-c96d754c-05c3-4000-9e3b-b53604a66eb4"><span id="SE-e6c281bd-8256-41b9-94c3-fa693abbba84"><b>3. User 전체 권한 추가</b></span></p><p id="SE-0f26dc79-b049-43f0-9a75-856f2d9b1aad"><span id="SE-2823046b-3bc7-4d76-a69d-12336a5da6ed">​</span></p><p id="SE-3f04b181-deab-45c0-8b26-66bfd5916d32"><span id="SE-0498e1ce-1857-4c8a-a55b-ea36d2bf5803">- 전체권한 추가</span></p>
                            </div>                <div id="SE-9d2a012f-9704-4fa4-be1b-653e80be6ca2">
                                    <p>$ GRANT ALL ON *.* TO writer0713@'%';</p>
                                </div>                <div id="SE-d24ea0af-6f47-4ecd-86c3-9b0c285bedb8">
                            <p id="SE-dbfde2fb-305d-43ed-91d0-870239d7c338"><span id="SE-8e3a9599-1114-4eff-8fda-f0ecadb2ec28">- 특정 권한 (ex. select, insert) 만 추가</span></p>
                        </div>                <div id="SE-660792fb-e2d4-407f-8929-49f43a00f9ec">
                                    <p>$ GRANT SELECT, INSERT ON *.* TO writer0713@'%';</p>
                                </div>                                                                <div id="SE-1a1f1ec0-8e5d-4ba6-90f7-9bb4fb08a252">
                                    <p>$ SHOW GRANTS FOR writer0713@'%';</p>
                                </div>                                <div id="SE-9794d52c-93a9-439e-a3de-d25bc3d4d356">
                                    <p>$ DROP USER writer0713@'%';</p>
                                </div>                    </div></div>

나만의공간。

KIM JUNGHWAN

1. 셸 진입 및 준비 - root 로 mysql 셸 진입 - mysql 사용 - 현재 사용자 리스트 확인 2. User 생성 - localhost (mysql 서버) 에서 셸을 통한 접근만 허용하려면 유저명@localhost 로 한다. - 외부에서 접근 (client) 을 허용하려면 localhost 대신 '%' 를 적자. 3. User 전체 권한 추가 - 전체권한 추가 - 특정 권한 (ex. select, insert) 만 추가 - 메모리에 바로 적용 4. User 권한 확인 5. User 삭제

[mysql] user(사용자) 생성, 권한 추가, 변경, 삭제

댓글