配置文件 my.ini
[client]
#password = your_password
port = 3306
socket = E:/workspace/mysql/tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = E:/workspace/mysql/tmp/mysql.sock
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 240K
basedir=E:/develop/mariadb-10.2.12-winx64
datadir=E:/workspace/mysql/database/MYSQL
character-set-server=utf8
啟動命令
安裝:mysql_install_db? --ldata=E:/workspace/mysql/database/MYSQL
增加為windows服務(wù):mysqld --install
手工啟動:mysqld --console