MariaDb(MySql) zip 설치

 

다운로드

https://mariadb.org/download

Download MariaDB Server - MariaDB.org

 

여기선 "mariadb-10.9.3-winx64.zip"을 사용한다.

 

설치

 

mysql_install_db --datadir=C:/MariadbRepo --service=MariadbSvc --port=3306 --password=0000

"--datadir=": Db파일이 저장될 위치
"--service=": 작업관리자와 윈도우 서비스 내 표시될 서비스명
"--port=": DB 접속 포트
"--password=": 설치할 때 설정한 비밀번호

FATAL ERROR: OpenSCManager failed에러 발생: 관리자 권한으로 실행'을 안해서 생기는 오류

 

 

단순Ex

C:\MariadbV10_9_3x64\bin>mysql_install_db.exe --password=0000
Default data directory is C:\MariadbV10_9_3x64\data
Running bootstrap
Creating my.ini file
2022-09-28 12:15:01 0 [Note] C:\MariadbV10_9_3x64\bin\mysqld.exe (server 10.9.3-MariaDB) starting as process 37588 ...
Removing default user
Setting root password
Creation of the database was successful

C:\MariadbV10_9_3x64\bin>

 

 

서버실행

mysqld를 실행시키면 된다

C:\MariadbV10_9_3x64\bin>mysqld
2022-09-28 12:16:20 0 [Note] mysqld (server 10.9.3-MariaDB) starting as process 34176 ...

 

접속확인

C:\MariadbV10_9_3x64\bin>mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

C:\MariadbV10_9_3x64\bin>mysql -u root -p
Enter password: ****
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.9.3-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>