centos67mysql5716源碼編譯安裝-wenkub
2022-09-02 00:27:10 本頁面
【正文】 ome/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設(shè)置 MySQL 開機自動啟動服務(wù): chkconfig mysql on?2設(shè)置密碼設(shè)置 MySQL 數(shù)據(jù)庫 root 用戶的本地登錄密碼(初始用戶沒有密碼): （1）編輯MySQL配置文件/etc/，找到[mysqld]，在下面添加一行skipgranttables（2）重啟MySQL service mysql restart（3）使用root用戶登錄MySQL，提示密碼直接回車 mysql) where user=39。 mysql flush privileges。localhost39。 or \g.Your MySQL connection id is 6Server version: Source distributionCopyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respecti
研究報告相關(guān)推薦
鄂ICP備17016276號-1