mysql] putty로 linux에 있는 mysql 접속하기

1. Putty실행

    * 주소는 http:// 이런거 빼고 아이피만 입력할것 ex) 192.168.0.1

2. 로그인

3. mysql 설치확인

rpm -qa | grep mysql

4. mysql 설치위치 확인

find / -name mysql

5. mysql 접속

mysql -u user명 -h 주소 -p 디비명

6. user의 pw입력

7. 성공했다면 아래와 같이 나옴

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 157

Server version: 5.1.73-log Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

8. 셀렉트 등을 통해 잘 작동하는지 확인

참고할 곳

http://egloos.zum.com/kwon37xi/v/1634694
http://jonnung.tistory.com/11