ITPub博客

首页 > 数据库 > MySQL > windows下安装MySQL

windows下安装MySQL

原创 MySQL 作者:longer3281 时间:2018-03-22 00:16:59 0 删除 编辑
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







来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9606353/viewspace-2152093/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: python连接MySQL
请登录后发表评论 登录
全部评论
数据库架构师,DB从业经历 DB2,Oracle,MySQL,PGSQL,MonogDB 等数据库,hadoop,hive,spark,flink,doris等大数据技术。

注册时间:2009-05-22

  • 博文量
    69
  • 访问量
    185398