产品saca dataviz最佳实践linux下的mysql安装

1、SaCa DataViz 最佳实践Linux 下的安装基础东软事业部（大连）目录第 1 章第 2 章概述3安装步骤32第1章 概述Dataviz 在部署的时候需要一个数据库来运行支撑库，有时候就需要在客户的 Linux 环境上安装。第2章 安装步骤1.获取-5.5.57-linux-glibc2.12-x86_64.tar.gz，并把-5.5.57-linux-glibc2.12-x86_64.tar.gz 上传到 /usr/local2.检查rpm -qa | grep -i及相关 RPM 包，是否安装，如果有安装，则移除（rpm e 名称）-libs-5.1.66-2.el6_3.x86_

2、64yum -y remove-libs*进入 usr/local/目录cd /usr/local/解压tar -zxvf-5.5.57-linux-glibc2.12-x86_64.tar.gz5.重命名文件夹名称mv-5.5.57-linux-glibc2.12-x86_64添加系统groupadd useradd -r -g进入cd组和用户目录38.修改当前目录拥有者为用户n -R:./9.进入 support-files 目录，查看是否有cd support-files / llf 文件f 文件上传到/usr/local/support-files 目10. 如果没有，则需要创建一个录

3、下。文件内容如下：# For advice on how to change settings please see# ht/doc/refman/5.7/en/server-configuration-defaults.html # * DO NOT EDIT THIS FILE. Its a template which will be copied to the# * default location during install, and will be replaced if you# * upgrade to a newer ver of .dsql_mode=NO_ENGINE_

4、SUBSTITUTION,STRICT_TRANS_TABLES 4port = 3306socket = /var/run/d/d.sockcharacter-set-server=utf8back_log = 300max_connections = 3000max_connect_errors = 50table_open_cache = 4096 max_allowed_packet = 32M #binlog_cache_size = 4Mmax_heap_table_size = 128Mread_rnd_buffer_size = 16M sort_buffer_size = 1

5、6M join_buffer_size = 16M thread_cache_size = 16 query_cache_size = 128M query_cache_limit = 4M ft_min_word_len = 8thread_stack = 512Ktranion_isolation = REPEATABLE-READtmp_table_size = 128M#log-bysql-binlong_query_time = 6server_id=1innodb_buffer_pool_size = 1Ginnodb_thread_concurrency = 16 innodb_

6、log_buffer_size = 16M5basedir = /usr/local/datadir = /usr/local/datainnodb_log_file_size = 512Minnodb_log_files_in_group = 3innodb_max_dirty_pages_pct = 90innodb_lock_wait_timeout = 120 innodb_file_per_table = ondumpquickmax_allowed_packet = 32Mno-auto-rehashdefault-character-set=utf8 safe-updatesmy

7、isamchkkey_buffer = 16M sort_buffer_size = 16M read_buffer = 8M write_buffer = 8Mhotcopyeractive-timeoutd_safeopen-files-limit = 8192cntport = 3306socket = /var/run/d/d.sock11. 安装数据库cd .6./scripts/_install_db -user=配置文件，提示是否覆盖-datadir=/usr/local/输入“Y”f/data/12.cp support-fif13. 添加开机启动，提示是否覆盖输入“Y”cp

8、support-files/.server /etc/init.d/14. 修改启动vi /etc/init.d/15. 修改项：basedir=/usr/local/ datadir=/usr/local/data/16. 创建 socket 目录，并mkdir -p /var/run/d/var/run/n:d17. 启动服务servicestart18. 查看是否启动成功ps -ef|grep19. 加入环境变量，这样可以在任何地方用令了export PATH=$PATH:/usr/local/source /etc/profile/bin720. 修改root 账户admin -u root password 连接uroot p输入后连进入控制台23. 修改可set sql_safe_updates=0; useupdate user set host = % where user = root; flush privileges;exit24. 如果有还需要修改的配