mysql的windows安装

1、下载版本

  mysql-cluster-gpl-noinstall-7.1.9a-win32

2、建立文件夹

C:/Users/user1> mkdir my_cluster my_cluster/ndb_data my_cluster/mysqld_data my_cluster/conf
C:/Users/user1> my_cluster/mysqld_data/mysql my_cluster/mysqld_data/ndbinfo

 

3、copy

In the conf folder, create 2 files (note that “/home/user1” should be replaced with your home directory):
my.cnf:
[mysqld]
ndbcluster
datadir=c://Users//user1//my_cluster//mysqld_data
basedir=c://Users//user1//mysqlc
port=5000
config.ini:
[ndb_mgmd]
hostname=localhost
datadir=c:/Users/user1/my_cluster/ndb_data
id=1
[ndbd default]
noofreplicas=2
datadir=c:/Users/user1/my_cluster/ndb_data
[ndbd]
hostname=localhost
id=3
[ndbd]
hostname=localhost
id=4
[mysqld]
Id=50

 

C:/Users/user1>copy mysqlc/data/mysql my_cluster/mysqld_data/mysql
C:/Users/user1>copy mysqlc/data/ndbinfo my_cluster/mysqld_data/ndbinfo

 

5、启动

C:/Users/user1>cd my_cluster
C:/Users/user1/my_cluster>start /B c:/Users/user1/mysqlc/bin/ndb_mgmd -f conf/config.ini --initial --configdir=c:/Users/user1/my_cluster/conf
C:/Users/user1/my_cluster>start /B c:/Users/user1/mysqlc/bin/ndbd -c localhost:1186
C:/Users/user1/my_cluster>start /B c:/Users/user1/mysqlc/bin/ndbd -c localhost:1186

 

C:/Users/user1/my_cluster> c:/Users/user1/mysqlc/bin/ndb_mgm -e show

 

 

c:/Users/user1/my_cluster>start /B c:/Users/user1/mysqlc/bin/mysqld --defaults-file=conf/my.cnf

 

5、test

c:/Users/user1/my_cluster>c:/Users/user1/mysqlc/bin/mysql -h 127.0.0.1 –P5000 -u root  注意：-P表示端口号，一定大写。
mysql> create database clusterdb;use clusterdb;
mysql> create table simples (id int not null primary key) engine=ndb;
mysql> insert into simples values (1),(2),(3),(4);
mysql> select * from simples;

 

6、设置mysql密码

mysqladmin -u root -p 123456

 

123456

 

7 关闭

C:/Users/user1/my_cluster> c:/Users/user1/mysqlc/bin/mysqladmin -u root -h 127.0.0.1 –P5000 shutdown
C:/Users/user1/my_cluster>c:/Users/user1/mysqlc/bin/ndb_mgm -e shutdown