centos67mysql5716源碼編譯安裝(編輯修改稿)
2024-09-01 00:27 本頁面
【文章內(nèi)容簡介】 改/etc/ 操作如下:可以:mv /etc/ /etc/也可以:刪除掉/etc/ 這個文件:rm /etc/ 如果你需要用于生產(chǎn)環(huán)境，不要急著做下面的 mysql 啟動操作。建議把上一步驟中 mysql初始化生成的/usr/local/mysql/ 刪除，然后把你優(yōu)化好的 mysql 配置文件 放到/etc 下。(這是做 mysql 主從復(fù)制和 mysql 優(yōu)化的經(jīng)驗!) (我們這里使用/etc/) 1編輯/etc/: vi /etc/ [client]defaultcharacterset=utf8port = 3306socket = /usr/local/mysql/[mysqld]charactersetserver = utf8 init_connect=39。SET NAMES utf839。collationserver = utf8_general_ciskipexternallockingskipnameresolveuser = mysqlport = 3306basedir = /usr/local/mysqldatadir = /home/mysql/datatmpdir = /home/mysql/temp server_id = .....socket = /usr/local/mysql/logerror = /home/mysql/logs/pidfile = /home/mysql/open_files_limit = 10240back_log = 600max_connections=500max_connect_errors = 6000wait_timeout=605800open_tables = 600table_cache = 650opened_tables = 630max_allowed_packet = 32Msort_buffer_size = 4Mjoin_buffer_size = 4Mthread_cache_size = 300query_cache_type = 1query_cache_size = 256Mquery_cache_limit = 2Mquery_cache_min_res_unit = 16ktmp_table_size = 256Mmax_heap_table_size = 256Mkey_buffer_size = 256Mread_buffer_size = 1Mread_rnd_buffer_size = 16Mbulk_insert_buffer_size = 64Mlower_case_table_names=1defaultstorageengine = INNODBinnodb_buffer_pool_size = 2Ginnodb_log_buffer_size = 32Minnodb_log_file_size = 128Minnodb_flush_method = O_DIRECTthread_concurrency = 32 //long_query_time= 2slowquerylog = onslowquerylogfile = /home/mysql/logs/[mysqldump]quickmax_allowed_packet = 32M[mysqld_safe]logerror=/var/log/pidfile=/var/run/mysqld/執(zhí)行初始化配置腳本，創(chuàng)建系統(tǒng)自帶的數(shù)據(jù)庫和表(注意:路徑/home/mysql/data 需要 換成你自定定義的數(shù)據(jù)庫存放路徑):? /usr/local/mysql/bin/mysql_install_db user=mysql basedir=/usr/local/mysql datadir=/home/mysql/data執(zhí)行該命令后，可能會找不到root用戶的初始化密碼（后面有設(shè)置密碼介紹）2復(fù)制服務(wù)啟動腳本: cp /usr/local/mysql/supportfiles/ /etc/2啟動 MySQL 服務(wù): service mysql startStarting MySQL.. SUCCESS!?(初次啟動會在/usr/local/mysql 目錄下生成 文件) 2
研究報告相關(guān)推薦
鄂ICP備17016276號-1