구름 IDE MySQL 환경 설정

Apply spring-boot on html Container

$ sudo apt-get update
$ sudo apt install -y ca-certificates-java
$ sudo apt-get install -y openjdk-17-jdk
$ java -versioin
openjdk version "17.0.5" ...
$ cd ..
$  bash
wget https://dlcdn.apache.org/maven/maven-3/3.8.7/binaries/apache-maven-3.8.7-bin.tar.gz
$ sudo tar xf ./apache-maven-3.8.6-bin.tar.gz -C /opt
$ sudo ln -s /opt/apache-maven-3.8.6 /opt/maven
$ export PATH=/opt/maven/bin:$PATH
$ mvn --version
Apache Maven 3.8.6 ...
$ vi ~/.bashrc       # add PATH
...                # press 'o'
export PATH=/opt/maven/bin:$PATH
:wq!
$ . ~/.bashrc 
$ mvn spring-boot:run
@ Chagne Container port 8080입력하세요

** 공개키 오류(공개키 다시받기)
//sudo apt-get update 에서 오류가 발생 시.
$ wget -q -O - https://packages.cloudfoundry.org/debian/cli.cloudfoundry.org.key | apt-key add -
혹은
$ curl https://cli-assets.heroku.com/apt/release.key | sudo apt-key add -

use MySQL

$ sudo service mysql restart
$ mysql -u root -p
Enter password :          # just Enter
mysql> select user, host from mysql.user;
...
| root             | localhost |
mysql> GRANT ALL ON *.* TO 'root'@'localhost';  // 권한 부여
mysql> UPDATE mysql.user SET authentication_string=PASSWORD('비밀번호') WHERE user='root'; // 비밀번호 변경
mysql> UPDATE mysql.user SET plugin="mysql_native_password" WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;
$ mysql -u root -p 
Enter password :          # 다른 점은 패스워드 입력 해야 접속 가능.

file dump

//dumps폴더로 이동
$ # cd ../dumps/
$ mysql -u root -p < ./ddl.sql
Enter password : ...
$ mysql -u root -p dbName < ./dml.sql

MySQL command

show databases;
show tables;

use dbName;

select * from TABLES_NAME;