참고: [[MariaDB]]
===서비스 상태 확인===
systemctl status mysql
====추가====
> insert into user(host, user, password) values ( CREATE USER 'localhostnewuser', @'[user]','password([password])'); > insert into user(host, user, password) values ('192.168.0.%', '[user]',IDENTIFIED BY 'password([password])user_password');
===데이터베이스 사용권한===
)'''ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC''';
===GUI Tool==<nowiki>#</nowiki> arm base docker run --name myadmin -d -e PMA_HOST=dbhost -p 8080:80 ebspace/armhf-phpmyadmin <nowiki>http://your_host_ip:8080/phpmyadmin</nowiki>
https://www.mysql.com/products/workbench/
==로그 설정==
$ mysql -su root
===로그 설정보기===
mysql> show variables like 'general_log%';
mysql> set global general_log=on;
$ sudo nano /etc/my.cnf
[mysqld]
general_log_file = /var/log/general.log
general_log = 1
==백업 및 복구==
[[MysqlDump]]를 사용하여 백업 및 복구를 할 수 있다.
==타임존==
SET @@session.time_zone='+09:00';
[[분류:Database]]