2021年11月23日 星期二

MariaDB

my.ini
[client]
port=3306
socket=/tmp/mysql.sock
default-character-set=utf8mb4
plugin-dir=C:/mariadb/lib/plugin

[mysqld]
basedir = C:/mariadb/
datadir = C:/mariadb/data
port = 3306
character-set-server = utf8mb4
character-set-client-handshake = FALSE
socket=/tmp/mysql.sock

[mysql]
default-character-set = utf8mb4

[mariadb]
character_set_server = utf8mb4
character_set_client = utf8mb4

start.bat
cd /d %~dp0bin
:: 先執行 .\bin\mysql_install_db 後,修改 my.ini 設定檔,再執行 start.bat
mysqld --install
net start mysql
pause

stop.bat
cd /d %~dp0
net stop mysql
bin\mysqld --remove