mariaDB 7

[SpringBoot] SpringBoot์— mariadb์™€ mybatis ์—ฐ๊ฒฐ์‹œํ‚ค๊ธฐ

Note ์—ฌ๋Ÿฌ ๊ธ€๋“ค์„ ์‚ดํŽด ๋ณด์•˜์ง€๋งŒ ํ•˜๋‚˜์˜ ๊ธ€๋งŒ์„ ๋”ฐ๋ผํ•ด์„œ ์ œ๋Œ€๋กœ ์‹คํ–‰๋˜๋Š”๊ฒƒ์ด ์—†์–ด ๋”ฐ๋กœ ๊ธฐ๋ก์šฉ์œผ๋กœ ๊ธ€์„ ์ž‘์„ฑํ•ฉ๋‹ˆ๋‹ค. ๊ธ€์„ ์‹œ์ž‘ํ•˜๊ธฐ์— ์•ž์„œ ๊ฐ„๋žตํ•˜๊ฒŒ ์–ด๋–ค ํŒŒ์ผ๋“ค์„ ์ƒ์„ฑํ•ด์•ผํ•˜๊ณ  ์„ค์ •ํ•ด์•ผํ•˜๋Š”์ง€ ํ๋ฆ„์„ ์ ์–ด๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค. build.gradleํŒŒ์ผ์— dependencies ์ถ”๊ฐ€ํ•˜๊ธฐ.(mybatis, jdbc, mariadb) domain(vo) ์ƒ์„ฑํ•˜๊ธฐ service ํŒŒ์ผ ์ƒ์„ฑํ•˜๊ธฐ(@Service) controller.java ํŒŒ์ผ ์ƒ์„ฑํ•˜๊ธฐ(@Controller) application.java ์‹คํ–‰ํŒŒ์ผ -> @MapperScan(value = {"com.tistory.eisen"}) application.properties ํŒŒ์ผ์— mybatis ์„ค์ •๊ฐ’ ๋„ฃ๊ธฐ(์„ ํƒ์— ๋”ฐ๋ผ mybatis-config.xml) mapp..

[SpringBoot] VSCode์— MariaDB5.5 ์—ฐ๋™ํ•˜๊ธฐ(3)

[SpringBoot] VSCode์— MariaDB5.5 ์—ฐ๋™ํ•˜๊ธฐ(1) [SpringBoot] VSCode์— MariaDB5.5 ์—ฐ๋™ํ•˜๊ธฐ(2) [SpringBoot] VSCode์— MariaDB5.5 ์—ฐ๋™ํ•˜๊ธฐ(3) Preview Error Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLInvalidAuthorizationSpecException: Could not connect to address=(host=10.0.100.58)(port=3306)(type=master) : (conn=5) Access denied ..

[SpringBoot] VSCode์— MariaDB5.5 ์—ฐ๋™ํ•˜๊ธฐ(2) error

[SpringBoot] VSCode์— MariaDB5.5 ์—ฐ๋™ํ•˜๊ธฐ(1) [SpringBoot] VSCode์— MariaDB5.5 ์—ฐ๋™ํ•˜๊ธฐ(2) [SpringBoot] VSCode์— MariaDB5.5 ์—ฐ๋™ํ•˜๊ธฐ(3) Error ์žฌ์„ค์น˜ ์ดํ›„ ์ฒ˜์Œ ์‹œ์ž‘์ธ๋ฐ ์ด๋Ÿฐ ์˜ค๋ฅ˜๊ฐ€ ๋‚˜์˜ต๋‹ˆ๋‹ค. [root@localhost /]# /usr/bin/mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MariaDB to secure it, we'll need t..

[MariaDB](CentOS) putty๋กœ ์—ฐ๊ฒฐํ•œ server์— mariaDB ์„ค์น˜ํ•˜๊ธฐ(3)

Preview CentOS7, MariaDB 5.5 ์„ค์น˜ ํ›„ remove ํ•œ ํ›„์— MariaDB 10.4 ์„ค์น˜๋ฅผ ์‹œ๋„. ์•ˆ๋˜๋Š” ์ด์œ ๋ฅผ ์•Œ๊ฒŒ๋จ. centOS ์„œ๋ฒ„ ์ž์ฒด๊ฐ€ 32bit๋กœ ์„ค์ •๋˜์–ด์žˆ๋˜๊ฑฐ์ž„... ๋‚˜๋Š” ๋‹น์—ฐํžˆ 64bit๋กœ ์„ค์ •์ด ๋˜์–ด ์žˆ๋Š”์ค„ ์•Œ์•˜์Œ. ๊ทธ๋ž˜์„œ ๊ทธ๋ƒฅ 5.5๋ฅผ ์ƒˆ๋กœ ๊น”๊ธฐ๋กœ ํ•จ. X ์ž˜๋ชป์„ค์น˜ํ•จ.... https://www.programmersought.com/article/53796246624/ $ systemctl list-unit-files --type=service ** ํ‚ค๋ณด๋“œ๋ฅผ ์ด์šฉํ•ด์„œ ๋‚ด๋ฆผ.... ๋งˆ์šฐ์Šค ๋“œ๋ž˜๊ทธ๊ฐ€ ์•ˆ๋จนํž˜. ์ƒˆ๋กœ ์„ค์น˜๊ฐ€ ์ž˜ ๋œ ๊ฒƒ์„ ๋ณผ ์ˆ˜ ์žˆ์Œ mysql์„ ์„ค์น˜ํ•˜๋”๋ผ. mariadb๊ฐ€ ์•„๋‹ˆ๋ผ... ๋ฉ์ฒญ... ์‹œ๊ฐ„์„ ๋„ˆ๋ฌด ๋งŽ์ด ๋‚ ๋ ธ๋„ค์š”. ์ด๊ฑธ ๋‹ค์‹œ ๋”ฐ๋ผํ•˜๊ธฐ. https..

Database/MySql 2021.08.03

[SpringBoot] VSCode์— MariaDB5.5 ์—ฐ๋™ํ•˜๊ธฐ(1)

[SpringBoot] VSCode์— MariaDB5.5 ์—ฐ๋™ํ•˜๊ธฐ(1) [SpringBoot] VSCode์— MariaDB5.5 ์—ฐ๋™ํ•˜๊ธฐ(2) [SpringBoot] VSCode์— MariaDB5.5 ์—ฐ๋™ํ•˜๊ธฐ(3) pom.xml 4.0.0 org.springframework.boot spring-boot-starter-parent 2.5.3 com.example thymeleaf 0.0.1-SNAPSHOT war thymeleaf Demo project for Spring Boot 11 UTF-8 org.springframework.boot spring-boot-starter-thymeleaf org.springframework.boot spring-boot-starter-web org.springfra..

[MariaDB](CentOS) putty๋กœ ์—ฐ๊ฒฐํ•œ server์— mariaDB 5.5 ์„ค์น˜ํ•˜๊ธฐ

MariaDB Server 5.5 ์„ค์น˜ํ•˜๊ธฐ https://mariadb.com/resources/blog/installing-mariadb-10-on-centos-7-rhel-7/ ๐Ÿ’ก The RHEL 7 and CentOS 7 distributions include MariaDB Server 5.5 by default. ์ฐพ์•„๋ณด๋‹ˆ CentOS 8 ๋ฒ„์ „๋„ ๊ธฐ๋ณธ์ ์œผ๋กœ 5.5๋ฅผ ๊ฐ€์ง€๊ณ  ์žˆ๋‹ค. ๋”ฐ๋ผ์„œ mariadb server 5.5๋ฅผ ์„ค์น˜ํ•˜๋ ค๋ฉด ์•„๋ž˜์˜ ๋ช…๋ น์–ด๋ฅผ ์ž‘์„ฑํ•˜๋ฉด ๋œ๋‹ค. $ sudo yum install mariadb-server Complete๊ฐ€ ๋œจ๋ฉด ์„ค์น˜๊ฐ€ ์™„๋ฃŒ๋œ ๊ฒƒ! MariaDB ์‹คํ–‰ํ•˜๊ธฐ $ systemctl start mariadb ๋น„๋ฐ€๋ฒˆํ˜ธ ์„ค์ •ํ•˜๊ธฐ $ /usr/bin/mysql_secure_in..

Database/MySql 2021.07.28

[Window]MariaDB ์„ค์น˜ํ•˜๊ธฐ

๊ณต์‹ ํ™ˆํŽ˜์ด์ง€ https://mariadb.org/ ๋‹ค์šด๋กœ๋“œ ํŽ˜์ด์ง€ https://downloads.mariadb.org/ Use UTF8 as default server's character set ์ฒดํฌํ•ด์„œ UTF8 ์ธ์ฝ”๋”ฉ์„ ๊ธฐ๋ณธ์œผ๋กœ ๋ณ€๊ฒฝ Enable access from remote ... ์ฒดํฌ ํ•ด์ œํ•ด์„œ ์›๊ฒฉ์—์„œ root ๊ณ„์ • ์ ‘์† ๋ฐฉ์ง€ db ์„ค์ •ํ•˜๊ธฐ MySQL Client ์‹คํ–‰ root ๋น„๋ฐ€๋ฒˆํ˜ธ ์ž…๋ ฅ ํ›„ show databases; ์„ค์น˜ ์™„๋ฃŒ. Uploaded by Notion2Tistory v1.1.0

Database/MySql 2021.07.28
728x90
๋ฐ˜์‘ํ˜•