首页 > 代码库 > IEE数据库安装向导
IEE数据库安装向导
RHEL 5用rpm包,直接安装后配置数据及缓存目录即可。
RHEL 6用tar包+配置文件,本文是在RHEL 6上安装IEE的向导。
①上传infobright-4.0.6-x86_64.tar包和配置文件my-ib.cnf,mysqld-ib到服务器任意目录
②解压tar包,移动到/usr/local/目录下,配置文件分别移动到/etc/目录,/etc/init.d/目录下
tar -xvf infobright-4.0.6-x86_64.tarmv infobright-4.0.6-x86_64 /usr/local/mv my-ib.cnf /etc/mv mysqld-ib /etc/init.d/chmod u+x /etc/init.d/mysqld-ib
③启动IEE服务,关闭IEE服务
--启动IEE服务/etc/init.d/mysqld-ib start--关闭IEE服务/etc/init.d/mysqld-ib stop
④创建进入IEE数据库命令行界面的快捷方式mysql-ib
ln -s /usr/local/infobright-4.0.6-x86_64/bin/mysql /usr/local/bin/mysql-ib
⑤配置更改IEE数据库的数据目录和缓存目录(IEE服务是关闭状态时操作)
# pwd(切到软件目录)
/usr/local/infobright-4.0.6-x86_64
# ./postconfig.sh(第一次运行postconfig.sh,更改IEE数据库的数据目录)
Infobright post configuration--------------------------------------Using postconfig you can:--------------------------------------(1) Move existing data directory to other location,(2) Move existing cache directory to other location,(3) Configure server socket,(4) Configure server port,(5) Relocate datadir path to an existing data directory.Please type ‘y‘ for option that you want or press ctrl+c for exit.Current configuration:--------------------------------------Current config file: [/etc/my-ib.cnf]Current brighthouse.ini file: [/usr/local/infobright-4.0.6-x86_64/data/brighthouse.ini]Current datadir: [/usr/local/infobright-4.0.6-x86_64/data]Current CacheFolder in brighthouse.ini file: [/usr/local/infobright-4.0.6-x86_64/cache]Current socket: [/tmp/mysql-ib.sock]Current port: [5029]--------------------------------------(1) Do you want to copy current datadir [/usr/local/infobright-4.0.6-x86_64/data] to a new location? [y/n]:yGive new datadir path (e.g. /opt/datadirnewpath/data):/ieedata/data(2) Option to change CacheFolder is disabled when option 1 is chosen!(3) Do you want to change current socket [/tmp/mysql-ib.sock]? [y/n]:n(4) Do you want to change current port [5029]? [y/n]:n(5) Relocation is disabled when options 1-4 are chosen!--------------------------------------Datadir(/usr/local/infobright-4.0.6-x86_64/data) is going to be copied to /ieedata/data--------------------------------------Please confirm to proceed? [y/n]:yCopying /usr/local/infobright-4.0.6-x86_64/data to /ieedata/data ...is done.You can now remove/backup your old /usr/local/infobright-4.0.6-x86_64/data ...Done!
Infobright post configuration--------------------------------------Using postconfig you can:--------------------------------------(1) Move existing data directory to other location,(2) Move existing cache directory to other location,(3) Configure server socket,(4) Configure server port,(5) Relocate datadir path to an existing data directory.Please type ‘y‘ for option that you want or press ctrl+c for exit.Current configuration:--------------------------------------Current config file: [/etc/my-ib.cnf]Current brighthouse.ini file: [/ieedata/data/brighthouse.ini]Current datadir: [/ieedata/data]Current CacheFolder in brighthouse.ini file: [/usr/local/infobright-4.0.6-x86_64/cache]Current socket: [/tmp/mysql-ib.sock]Current port: [5029]--------------------------------------(1) Do you want to copy current datadir [/ieedata/data] to a new location? [y/n]:n(2) Do you want to move current CacheFolder [/usr/local/infobright-4.0.6-x86_64/cache] to a new location? [y/n]:y Give new CacheFolder path:/ieedata/cache(3) Do you want to change current socket [/tmp/mysql-ib.sock]? [y/n]:n(4) Do you want to change current port [5029]? [y/n]:n(5) Relocation is disabled when options 1-4 are chosen!--------------------------------------New CacheFolder is going to be /ieedata/cache--------------------------------------Please confirm to proceed? [y/n]:yCreating new cachedir /ieedata/cache ...is done.Done!
⑥启动IEE服务,进入数据库命令行,赋予IEE数据库的root用户所有权限,密码初始化为123456
# /etc/init.d/mysqld-ib start
# mysql-ib
Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 3Server version: 5.1.40 build number (revision)=IB_4.0.6_r16086_16275(iee - commercial) (static)Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.mysql> grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘ WITH GRANT OPTION;Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql>
⑦用户利用navicate工具连接到IEE数据库,进行建库建表,字符集的选择utf-8:
character set : utf8 -- UTF-8 Unicodecollation : utf8_bin
IEE数据库安装向导
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。