mariaDB

Published by onesixx on

설치 on Docker

https://onesixx.com/mysql-docker/

설치 on macbook

brew install mysql

설정

Homebrew로 설치한 거라, mysql.server대신 brew services [command] mariadb 사용

Shell
Shell
Shell
Shell
Shell

ERROR! MariaDB is not running, but PID file exists

Homebrew로 설치한 거라, mysql.server대신 brew services [command] mariadb 사용

Shell

DB Client

DBeaver ..

datafile 위치

https://www.lesstif.com/pages/viewpage.action?pageId=17105786

show variables like 'datadir';

# Variable_name, Value
‘datadir’, ‘/var/lib/mysql/’

MySQL 테이블 및 데이타베이스 크기 알아내기

SELECT TABLE_NAME AS 'Tables',
       round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB'
FROM information_schema.TABLES
WHERE table_schema = "wordpress"
ORDER BY (data_length + index_length) DESC;

MySQL 서버 접속

SQL

Password는 yml 파일에서 설정한 MYSQL_ROOT_PASSWORD 값

DB 및 사용자 생성

SQL
SQL

DB Server 외부 접속 테스트

  • MySQL Workbench GUI 환경에서 접속 테스트
SQL
Categories: Ubuntu

onesixx

Blog Owner

Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x