產(chǎn)品saca dataviz最佳實(shí)踐linux下的mysql安裝

1、SaCa DataViz 最佳實(shí)踐Linux 下的安裝基礎(chǔ)東軟事業(yè)部（大連）目錄第 1 章第 2 章概述3安裝步驟32第1章 概述Dataviz 在部署的時(shí)候需要一個(gè)數(shù)據(jù)庫來運(yùn)行支撐庫，有時(shí)候就需要在客戶的 Linux 環(huán)境上安裝。第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及相關(guān) RPM 包，是否安裝，如果有安裝，則移除（rpm e 名稱）-libs-5.1.66-2.el6_3.x86_

2、64yum -y remove-libs*進(jìn)入 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添加系統(tǒng)groupadd useradd -r -g進(jìn)入cd組和用戶目錄38.修改當(dāng)前目錄擁有者為用戶n -R:./9.進(jìn)入 support-files 目錄，查看是否有cd support-files / llf 文件f 文件上傳到/usr/local/support-files 目10. 如果沒有，則需要?jiǎng)?chuàng)建一個(gè)錄

3、下。文件內(nèi)容如下：# 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. 安裝數(shù)據(jù)庫cd .6./scripts/_install_db -user=配置文件，提示是否覆蓋-datadir=/usr/local/輸入“Y”f/data/12.cp support-fif13. 添加開機(jī)啟動(dòng)，提示是否覆蓋輸入“Y”cp

8、support-files/.server /etc/init.d/14. 修改啟動(dòng)vi /etc/init.d/15. 修改項(xiàng)：basedir=/usr/local/ datadir=/usr/local/data/16. 創(chuàng)建 socket 目錄，并mkdir -p /var/run/d/var/run/n:d17. 啟動(dòng)服務(wù)servicestart18. 查看是否啟動(dòng)成功ps -ef|grep19. 加入環(huán)境變量，這樣可以在任何地方用令了export PATH=$PATH:/usr/local/source /etc/profile/bin720. 修改root 賬戶admin -u root password 連接uroot p輸入后連進(jìn)入控制臺(tái)23. 修改可set sql_safe_updates=0; useupdate user set host = % where user = root; flush privileges;exit24. 如果有還需要修改的配