[MariaDB] MariaDB 관리 접속 및 간단 사용법/포트(port)넘버 확인,변경/설치, 삭제

https://codemonkyu.tistory.com/entry/MariaDB-MariaDB-%EA%B4%80%EB%A6%AC-%EC%A0%91%EC%86%8D-%EB%B0%8F-%EA%B0%84%EB%8B%A8-%EC%82%AC%EC%9A%A9%EB%B2%95

 

[MariaDB] MariaDB 관리 접속 및 간단 사용법

코드에 sudo lsof -PiTCP -sTCP:LISTEN 입력해주면 포트넘버 확인가능

SHOW GLOBAL VARIABLES LIKE 'PORT'; 도 가능

 

• set password for root@localhost = password('admin123');
  
  create database mirrorCity_rhythm character set utf8;

#테이블 생성(create)구문
create table rhythm(
    nickname varchar(20),
    name varchar(20),
    hire_date date,
    salary int,
    PRIMARY KEY (nickname)
);

#데이터(data) insert 구문
insert into rhythm(nickname, name, hire_date, salary) 
values('HARIBO', '이혜영', '2000-02-01', 8450),
('KIM', '김환철', '2011-02-01', 5450),
('HWANG', '황대영', '2004-02-01', 7450),
('mr.BAEK', '이지백', '2001-02-01', 8050);

INSERT INTO login(name, id, password) 
VALUES('이혜영', 'id001', 'pw001'),
('김환철', 'id002', 'pw002'),
('황대영', 'id003', 'pw003'),
('이지백', 'id004', 'pw004');

INSERT INTO login(id, name, password) VALUES(‘id002', ‘KIM’, 'pw002'),
(‘id002', ‘KIM’, 'pw002'),
(‘id003, ‘HWANG’, 'pw003'),
(‘id004, ‘BAEK’, 'pw004');

 

[Macbook M1] mariadb 설치, 삭제

https://explored.tistory.com/29

[Macbook M1] mariadb 설치, 삭제, 계정생성

https://velog.io/@taelee/%ED%98%84%EC%9E%AC-%EC%97%B4%EB%A0%A4%EC%9E%88%EB%8A%94-%ED%8F%AC%ED%8A%B8-%ED%99%95%EC%9D%B8mac

현재 열려있는 포트 확인 및 닫기(mac)

 

# mariadb 접속
mariadb -u root -p

#사용자권한 주기
grant all on practice.* to root@localhost identified by ‘admin123’;


#사용자권한 보는법
show grants for root@localhost;

#테이블 생성하기
create table practiceTable2(

    nickname varchar(20),

    name varchar(20),

    hire_date date,

    salary int,

    PRIMARY KEY (nickname)

);


#비밀번호 설정하기
set password for root@localhost = password(‘admin123’);



GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket WITH GRANT OPTION |

| GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION


#포트 넘버 확인하기
SHOW GLOBAL VARIABLES LIKE 'PORT';



MariaDB [(none)]> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mydb               |

| mysql              |

| performance_schema |

| sys                |

| test               |

+--------------------+

6 rows in set (0.002 sec)



create table test_table(

    nickname varchar(20),

    name varchar(20),

    hire_date date,

    salary int,

    PRIMARY KEY (nickname)

);



sudo vi /etc/my.cnf

grep my.cnf

화면 끄는법 : 터미널

pmset displaysleepnow

 

 

 

아이맥 영원히 sleep모드 안들게 하는법. 전원 유지시키는법:터미널

caffeinate -d

 

https://www.makeuseof.com/tag/4-ways-keep-mac-from-sleeping/

How to Stop Your Mac Going to Sleep