1)下载安装文件
2)解压安装文件到指定目录
3)配置好参数文件;
4)初始化MySQL数据库
mysqld --initialize datadir=D:\MySQL\mariadb-10.2.13-winx64\datadb
5)注册服务
D:\MySQL\mariadb-10.2.13-winx64\bin\mysqld install mysqld --defaults-file=D:\MySQL\mariadb-10.2.13-winx64\datadb\my.ini
6)启动MySQL服务:
a)直接在 windows服务配置里直接启动
b)命令行启动: net start mysqld (停止服务 net stop mysqld)
7)删除服务
需要在管理员模式下打开cmd,执行sc delete mysqld 即可
8)附上参数文件:
#[mysqld]
#datadir=D:/MySQL/mariadb-10.2.13-winx64/data
#[client]
#plugin-dir=D:/MySQL/mariadb-10.2.13-winx64/lib/plugin
#
[client]
#password = your_password
port = 3306
socket = D:\\MySQL\mariadb-10.2.13-winx64\\mysql.sock
plugin-dir=D:\\MySQL\\mariadb-10.2.13-winx64\\lib\\plugin
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
basedir=D:\\MySQL\mariadb-10.2.13-winx64
datadir=D:\\MySQL\mariadb-10.2.13-winx64\\datadb
log-error=D:\\MySQL\mariadb-10.2.13-winx64\\datadb\\mysqld.log
port = 3306
socket = D:\\MySQL\mariadb-10.2.13-winx64\\mysql.sock
init_connect = 'SET NAMES utf8'
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
server-id = 168
innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size = 400M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 60
character_set_server=utf8
collation-server=utf8_general_ci
character_set_client=utf8
log-bin=mysql-bin
binlog_format=mixed
expire_logs_days=3
max_binlog_size=200M
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
default-character-set=utf8
character_set_connection=utf8
no-auto-rehash
[client]
default-character-set=utf8
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
2)解压安装文件到指定目录
3)配置好参数文件;
4)初始化MySQL数据库
mysqld --initialize datadir=D:\MySQL\mariadb-10.2.13-winx64\datadb
5)注册服务
D:\MySQL\mariadb-10.2.13-winx64\bin\mysqld install mysqld --defaults-file=D:\MySQL\mariadb-10.2.13-winx64\datadb\my.ini
6)启动MySQL服务:
a)直接在 windows服务配置里直接启动
b)命令行启动: net start mysqld (停止服务 net stop mysqld)
7)删除服务
需要在管理员模式下打开cmd,执行sc delete mysqld 即可
8)附上参数文件:
#[mysqld]
#datadir=D:/MySQL/mariadb-10.2.13-winx64/data
#[client]
#plugin-dir=D:/MySQL/mariadb-10.2.13-winx64/lib/plugin
#
[client]
#password = your_password
port = 3306
socket = D:\\MySQL\mariadb-10.2.13-winx64\\mysql.sock
plugin-dir=D:\\MySQL\\mariadb-10.2.13-winx64\\lib\\plugin
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
basedir=D:\\MySQL\mariadb-10.2.13-winx64
datadir=D:\\MySQL\mariadb-10.2.13-winx64\\datadb
log-error=D:\\MySQL\mariadb-10.2.13-winx64\\datadb\\mysqld.log
port = 3306
socket = D:\\MySQL\mariadb-10.2.13-winx64\\mysql.sock
init_connect = 'SET NAMES utf8'
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
server-id = 168
innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size = 400M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 60
character_set_server=utf8
collation-server=utf8_general_ci
character_set_client=utf8
log-bin=mysql-bin
binlog_format=mixed
expire_logs_days=3
max_binlog_size=200M
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
default-character-set=utf8
character_set_connection=utf8
no-auto-rehash
[client]
default-character-set=utf8
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9606353/viewspace-2152093/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9606353/viewspace-2152093/