加入收藏 | 设为首页 | 会员中心 | 我要投稿 财气旺网 - 财气网 (https://www.caiqiwang.com/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > MySql教程 > 正文

Inception部署测验

发布时间:2022-04-09 02:30:36 所属栏目:MySql教程 来源:互联网
导读:如果你想学习inception 如果你想学习flask~ 那么此篇文章适合你~ 1、下载 2、安装 yum -y install cmake libncurses5-dev libssl-dev g++ bison openssl-devel.x86_64 unzip inception-master.zip cd inception-master sh -x inception_build.sh debug cd /c
      如果你想学习inception
      如果你想学习flask~
     那么此篇文章适合你~
 
1、下载
 
2、安装
     yum -y install cmake  libncurses5-dev libssl-dev g++ bison openssl-devel.x86_64
     unzip inception-master.zip
     cd  inception-master
     sh -x  inception_build.sh debug
 
cd /chunlei/inception/inception
mkdir log
mkdir etc
cd etc
安装完毕后添加配置文件:
vim inc.cnf
[inception]
general_log=1
general_log_file=/chunlei/inception/inception/log/inception.log
port=7001
socket=/chunlei/inception/inception/inc.socket
character-set-client-handshake=0
character-set-server=utf8
inception_remote_system_password=123456
inception_remote_system_user=root
inception_remote_backup_port=6001
inception_remote_backup_host=127.0.0.1
inception_support_charset=utf8mb4
inception_enable_nullable=0
inception_check_primary_key=1
inception_check_column_comment=1
inception_check_table_comment=1
inception_osc_min_table_size=1
inception_osc_bin_dir=/chunlei/osc
inception_osc_chunk_time=0.1
inception_ddl_support=1
inception_enable_blob_type=1
inception_check_column_default_value=1
3、启动
/chunlei/inception/inception-master/debug/mysql/bin/Inception --defaults-file=/chunlei/inception/inception/etc/inc.cnf &
 
登录:
mysql -uroot -h227.0.0.1 -P7001
elcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 2
Server version: Inception2.1.50 1
 
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
 
mysql> inception get variables;     测试
  
4、界面
界面化:网上有封装好的flask
在网上下载一个web封装的界面安装过程如下:
下载地址:https://github.com/dbalihui/inception_web
 
安装flask
easy_install flask
easy_install flask_wtf
 
easy_install flask-script
 
easy_install flask-debugtoolbar
 
数据库建立库:
create database sql_check
创建用户:
GRANT ALL PRIVILEGES ON *.* TO 'dba'@'%' identified by '123456'
 
修改配置文件
cd /chunlei/inception/flask/inception_web-master/app
vi inception.py
修改:
conn=MySQLdb.connect(host='127.0.0.1',user='dba',passwd='123456',db='sql_check',port=7001,use_unicode=True, charset="utf8")
运行:
./run.py runserver --host 172.16.16.2
http://182.61.39.142:5000/
测试:
create table test1 (id int auto_increment,name varchar(10),primary key(id)) 

(编辑:财气旺网 - 财气网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!