• MySQL
• MySQL 설치 in Ubuntu
• 데이터베이스와 사용자 생성

MySQL

---

MySQL 설치 in Ubuntu

apt  -y  update
apt  -y  upgrade

apt  install  mysql-server
mysql_secure_installation

vi  /etc/mysql/mysql.conf.d/mysqld.cnf
    bind-address = 0.0.0.0
    
systemctl  restart  mysql.service
systemctl  enable   mysql.service

pip3  install  pymysql

데이터베이스와 사용자 생성

DATABASE="~"
USER="~"
PASSWD="~"
ROOT_PASSWD="~"

mysql  -uroot  -p${ROOT_PASSWD}  mysql
    CREATE DATABASE ${DATABASE};
    SHOW DATABASES;

    GRANT all privileges ON ${DATABASE}.* TO ${USER}@localhost 
          IDENTIFIED BY '${PASSWD}';
    GRANT all privileges ON ${DATABASE}.* TO ${USER}@'%' 
          IDENTIFIED BY '${PASSWD}';
    flush privileges;

    SELECT Host, User, Password, max_user_connections 
      FROM user 
     ORDER BY User ASC, Host ASC;
      
    SELECT Host, Db, User 
      FROM db 
     ORDER BY User ASC, Db ASC, Host ASC;
     
    exit

mysql  -u${USER}  -p${PASSWD}  ${DATABASE}

#--- 권한 설정
#---     권한 목록 : ALL, SELECT, INSERT, UPDATE, DELETE, DROP, ...
#---         DESCRIBE  db;
#---     HOST : %, localhost
GRANT ${권한목록} ON ${DATABASE}.* TO ${USER}@'${HOST}' [IDENTIFIED BY '${PASSWD}'] [WITH GRANT OPTION];

SHOW GRANTS FOR ${USER}@'${HOST}';

REVOKE SELECT, INSERT ON ${DATABASE}.* FROM ${USER}@'${HOST}';

---