우분투에서 Mariadb 설치하기 Install Start installing the package. apt -y install mariadb-server mariadb-client Enables you to improve the security of your MariaDB installation. /usr/bin/mysql_secure_installation $ vi /etc/my.cnf [mysqld] character-set-server=utf8mb4 collation-server=utfmb4_unicode_ci …
우분투에서 MySQL 설치하기 Install apt install -y mysql-server 캐릭터셋 설정하기 $ vi /etc/my.cnf … [mysqld] character-set-server=utf8mb4 collation-server=utfmb4_unicode_ci systemctl restart mysql 서버 재부팅시 자동 활성화하기 $ systemctl stop mysql $ systemctl …
자주사용하는 Mariadb 명령어 Access MySQL $ mysql -u root -p Show All database mysql> SHOW DATABASES; Create new database mysql> CREATE DATABASE DATABASE_NAME; mysql> FLUSH PRIVILEGES; Delete new database mysql> …
도커 MySQL 예제 Syntax $ docker run -d \ – -name mydb \ – -env MYSQL_ROOT_PASSWORD=<password> \ – -env MYSQL_USER=<dbuser> \ – -env MYSQL_PASSWORD=<dbpass> \ – -env MYSQL_DATABASE=<dbname> \ mysql:5.5 …
