작성완료

Ubuntu MariaDB 설치

Ubuntu에 MariaDB를 설치하는 과정은 패키지 매니저 업데이트, MariaDB 서버 및 클라이언트 설치, 보안 설정, 서비스 시작 및 자동 재시작 설정, 사용자 생성 및 권한 설정, 외부 접속 허용, 마지막으로 모든 설정 후 재시작으로 구성됩니다.

UbuntuMariaDB

apt update

apt install mariadb-server

apt install mariadb-client

mysql_secure_installation

Switch to unix_socket authentication [Y/n]
n

Change the root password? [Y/n]
Y

New password:
Re-enter new password:

Remove anonymous users? [Y/n]
Y

Disallow root login remotely? [Y/n]
n

Remove test database and access to it? [Y/n]
Y

Reload privilege tables now? [Y/n]
Y

systemctl start mysql

패키지가 없을 경우 설치 필요apt install systemd

systemctl enable mysql

mysql -u root -p

sql
CREATE USER 'root'@'%' IDENTIFIED BY '비밀번호';

sql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

FLUSH PRIVILEGES;

vi /etc/mysql/mariadb.conf.d/50-server.cnf

bind-address = 0.0.0.0

systemctl start mysql

작성완료

UbuntuMariaDB

apt update

apt install mariadb-server

apt install mariadb-client

mysql_secure_installation

Switch to unix_socket authentication [Y/n]
n

Change the root password? [Y/n]
Y

New password:
Re-enter new password:

Remove anonymous users? [Y/n]
Y

Disallow root login remotely? [Y/n]
n

Remove test database and access to it? [Y/n]
Y

Reload privilege tables now? [Y/n]
Y

systemctl start mysql

패키지가 없을 경우 설치 필요apt install systemd

systemctl enable mysql

mysql -u root -p

sql
CREATE USER 'root'@'%' IDENTIFIED BY '비밀번호';

sql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

FLUSH PRIVILEGES;

vi /etc/mysql/mariadb.conf.d/50-server.cnf

bind-address = 0.0.0.0

systemctl start mysql