DB/MySQL
-
[MySQL] Install MySQL with Homebrew (Mac)DB/MySQL 2023. 2. 7. 22:24
1. 터미널 실행 brew update brew install mysql-> 결과 ==> mysql We've installed your MySQL database without a root password. To secure it run: mysql_secure_installation MySQL is configured to only allow connections from localhost by default To connect run: mysql -u root To restart mysql after an upgrade: brew services restart mysql Or, if you don't want/need a background service you can just run..
-
[MySQL] CentOS7 - Mysql 5.7 cmmand 설치DB/MySQL 2021. 6. 21. 09:39
(21.05.26 기준) centos7 커멘드 설치 8.0 https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html 5.7 https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html === sudo yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
-
The server time zone value ‘KST’ is unrecognized or represents more than one time zone.DB/MySQL 2019. 12. 5. 11:43
# The server time zone value 'KST' is unrecognized or represents more than one time zone # My SQL 5.1.X 이후 버전부터 KST 타임존을 인식하지 못함 ## jdbc:mysql://${MYSQL_HOST:localhost}:3306/db_example?characterEncoding=UTF-8&serverTimezone=UTC