라즈베리파이에서 mysql 접속하기

라즈베리파이에서 mysql 접속하기

사용한 명령어 빨간색 음영 처리 

ssh pi@192.168.1.118 => ssh로 맥 터미널에서 라즈베리파이 접속

mysql -uroot -p => mysql 실행 

use mysql => MariaDB에서 mysql 실행 

jeong-umaegbug-ui-MacBook-Pro:~ jeongwoomac$ ssh pi@192.168.1.118

pi@192.168.1.118's password: 

Linux raspberrypi 4.14.69-v7+ #1141 SMP Mon Sep 10 15:26:29 BST 2018 armv7l

The programs included with the Debian GNU/Linux system are free software;

the exact distribution terms for each program are described in the

individual files in /usr/share/doc/*/copyright.

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent

permitted by applicable law.

Last login: Fri Sep 21 18:12:11 2018 from 192.168.1.95

Wi-Fi is disabled because the country is not set.

Use raspi-config to set the country before use.

pi@raspberrypi:~ $ mysql -uroot -p

Enter password: 

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

Your MariaDB connection id is 47

Server version: 10.1.23-MariaDB-9+deb9u1 Raspbian 9.0

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> use mysql

Reading table information for completion of table and column names

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

Database changed

MariaDB [mysql]> 

만약 mysql 패스워드를 바꾸고 싶다면 다음과 같은 명령어를 사용하면 된다. 

set password = password("변경하고 싶은 비번");