myrocks安装
Posted 79 months ago
myrocks安装
已编译好的下载包 http://pan.baidu.com/s/1eR4vrO2 kbnd
先下载好
然后解压
查看基础文档
配置文件如下
[mysqld]
rocksdb
default-storage-engine=rocksdb
skip-innodb
default-tmp-storage-engine=MyISAM
collation-server=latin1_bin
init_connect='SET NAMES utf8'
log-bin
binlog-format=ROW
basedir =/home/free/rock
datadir =/home/free/rock/data
port =3309
server_id = 100032
socket =/home/free/rock/rock.sock
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
运行命令
path替换你的路径
安装
mysql_install_db --defaults-file=/path/to/my.cnf
运行
mysqld_safe --defaults-file=/path/to/my.cnf
安装后的设置
mysql --socket=xxxx
set password=password('root');
grant all privileges on *.* to root@'%' identified by 'root';
flush privileges;
grant grant option on *.* to 'root'@'%';