mysql一鍵安裝教程 mysql5.1.45全自動(dòng)安裝（編譯安裝）
更新時(shí)間：2016年06月22日 11:32:30 作者：persist-win
這篇文章主要介紹了mysql一鍵安裝教程，一鍵安裝MySQL5.1.45，全自動(dòng)安裝MySQL SHELL程序，實(shí)現(xiàn)編譯安裝，感興趣的
一.問(wèn)題來(lái)源
安裝MySQL如果手動(dòng)安裝一臺(tái)還可以，但安裝多臺(tái)，手動(dòng)安裝很麻煩，需要編寫(xiě)一個(gè)shell程序 install_mysql.sh來(lái)進(jìn)行安裝
二.程序說(shuō)明
將MySQL5.1.45安裝到了 /home/longxibendi/mysql/usrl/local/mysql
數(shù)據(jù)文件以及日志文件設(shè)置在了 /home/longxibendi/mysql/3309/
配置文件my.cnf 在 /home/longxibendi/mysql/3309
端口使用 3309
三.源程序 install_mysql.sh
#!/bin/bash #author longxibendi #function install MySQL5.1.45 ###################################### configure and install ##################################################### mkdir -p /home/longxibendi/mysql/usr/local/mysql cd mkdir mysql cd mysql wget http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.45.tar.gz tar zxvf mysql-5.1.45.tar.gz cd mysql-5.1.45 ./configure --prefix=/home/longxibendi/mysql/usr/local/mysql --without-debug --without-bench --enable-thread-safe-client --enable-assembler --enable-profiling --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-charset=latin1 --with-extra-charset=utf8,gbk --with-innodb --with-mysqld-user=longxibendi --without-embedded-server --with-server-sufix=community --with-unix-socket-path=/home/longxibendi/mysql/usr/local/mysql/sock/mysql.sock --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-plugins=partition,heap,innobase,myisam,myisammrg,csv make -j `cat /proc/cpuinfo | grep 'model name' | wc -l ` && make install ###################################### set log and data storage path ##################################################### chmod +w /home/longxibendi/mysql/usr/local/mysql mkdir -p /home/longxibendi/mysql/3309/data/ mkdir -p /home/longxibendi/mysql/3309/binlog/ mkdir -p /home/longxibendi/mysql/3309/relaylog/ ###################################### create data file ##################################################### /home/longxibendi/mysql/usr/local/mysql/bin/mysql_install_db --basedir=/home/longxibendi/mysql/usr/local/mysql --datadir=/home/longxibendi/mysql/3309/data --user=longxibendi ####################################### create my.cnf profile ##################################################### echo " [client] character-set-server = utf8 port = 3309 socket = /home/longxibendi/mysql/usr/local/mysql/sock/mysql.sock [mysqld] character-set-server = utf8 replicate-ignore-db = mysql replicate-ignore-db = test replicate-ignore-db = information_schema user = mysql port = 3309 socket = /home/longxibendi/mysql/usr/local/mysql/sock/mysql.sock basedir = /home/longxibendi/mysql datadir = /home/longxibendi/mysql/3309/data log-error = /home/longxibendi/mysql/3309/mysql_error.log pid-file = /home/longxibendi/mysql/3309/mysql.pid open_files_limit = 10240 back_log = 600 max_connections = 5000 max_connect_errors = 6000 table_cache = 614 external-locking = FALSE max_allowed_packet = 16M sort_buffer_size = 1M join_buffer_size = 1M thread_cache_size = 300 #thread_concurrency = 8 query_cache_size = 20M query_cache_limit = 2M query_cache_min_res_unit = 2k default-storage-engine = MyISAM thread_stack = 192K transaction_isolation = READ-COMMITTED tmp_table_size = 20M max_heap_table_size = 20M long_query_time = 3 log-slave-updates log-bin = /home/longxibendi/mysql/3309/binlog/binlog binlog_cache_size = 4M binlog_format = MIXED max_binlog_cache_size = 8M max_binlog_size = 20M relay-log-index = /home/longxibendi/mysql/3309/relaylog/relaylog relay-log-info-file = /home/longxibendi/mysql/3309/relaylog/relaylog relay-log = /home/longxibendi/mysql/3309/relaylog/relaylog expire_logs_days = 30 key_buffer_size = 10M read_buffer_size = 1M read_rnd_buffer_size = 6M bulk_insert_buffer_size = 4M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 20M myisam_repair_threads = 1 myisam_recover interactive_timeout = 120 wait_timeout = 120 skip-name-resolve #master-connect-retry = 10 slave-skip-errors = 1032,1062,126,1114,1146,1048,1396 #master-host = 192.168.1.2 #master-user = username #master-password = password #master-port = 3309 server-id = 1 innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 20M innodb_data_file_path = ibdata1:56M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 8 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 16M innodb_log_file_size = 20M innodb_log_files_in_group = 3 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 innodb_file_per_table = 0 #log-slow-queries = /home/longxibendi/mysql/3309/slow.log #long_query_time = 10 [mysqldump] quick max_allowed_packet = 32M " > /home/longxibendi/mysql/3309/my.cnf ############################### solve bug http://bugs.mysql.com/bug.php?id=37942 ############################################# mkdir -p /home/longxibendi/mysql/share/mysql/english/ cp /home/longxibendi/mysql/usr/local/mysql/share/mysql/english/errmsg.sys /home/longxibendi/mysql/share/mysql/english/ ############################### start MySQL Server ############################################# /bin/sh /home/longxibendi/mysql/usr/local/mysql/bin/mysqld_safe --defaults-file=/home/longxibendi/mysql/3309/my.cnf 2>&1 > /dev/null & ############################### try use MySQL Server ############################################# /home/longxibendi/mysql/usr/local/mysql/bin/mysql -u root -p -S /home/longxibendi/mysql/usr/local/mysql/sock/mysql.sock -P3309 -h127.0.0.1 -e "show databases;"
#!/bin/bash #author longxibendi #function install MySQL5.1.45 ###################################### configure and install ##################################################### mkdir -p /home/longxibendi/mysql/usr/local/mysql cd mkdir mysql cd mysql wget http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.45.tar.gz tar zxvf mysql-5.1.45.tar.gz cd mysql-5.1.45 ./configure --prefix=/home/longxibendi/mysql/usr/local/mysql --without-debug --without-bench --enable-thread-safe-client --enable-assembler --enable-profiling --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-charset=latin1 --with-extra-charset=utf8,gbk --with-innodb --with-mysqld-user=longxibendi --without-embedded-server --with-server-sufix=community --with-unix-socket-path=/home/longxibendi/mysql/usr/local/mysql/sock/mysql.sock --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-plugins=partition,heap,innobase,myisam,myisammrg,csv make -j `cat /proc/cpuinfo | grep 'model name' | wc -l ` && make install ###################################### set log and data storage path ##################################################### chmod +w /home/longxibendi/mysql/usr/local/mysql mkdir -p /home/longxibendi/mysql/3309/data/ mkdir -p /home/longxibendi/mysql/3309/binlog/ mkdir -p /home/longxibendi/mysql/3309/relaylog/ ###################################### create data file ##################################################### /home/longxibendi/mysql/usr/local/mysql/bin/mysql_install_db --basedir=/home/longxibendi/mysql/usr/local/mysql --datadir=/home/longxibendi/mysql/3309/data --user=longxibendi ####################################### create my.cnf profile ##################################################### echo " [client] character-set-server = utf8 port = 3309 socket = /home/longxibendi/mysql/usr/local/mysql/sock/mysql.sock [mysqld] character-set-server = utf8 replicate-ignore-db = mysql replicate-ignore-db = test replicate-ignore-db = information_schema user = mysql port = 3309 socket = /home/longxibendi/mysql/usr/local/mysql/sock/mysql.sock basedir = /home/longxibendi/mysql datadir = /home/longxibendi/mysql/3309/data log-error = /home/longxibendi/mysql/3309/mysql_error.log pid-file = /home/longxibendi/mysql/3309/mysql.pid open_files_limit = 10240 back_log = 600 max_connections = 5000 max_connect_errors = 6000 table_cache = 614 external-locking = FALSE max_allowed_packet = 16M sort_buffer_size = 1M join_buffer_size = 1M thread_cache_size = 300 #thread_concurrency = 8 query_cache_size = 20M query_cache_limit = 2M query_cache_min_res_unit = 2k default-storage-engine = MyISAM thread_stack = 192K transaction_isolation = READ-COMMITTED tmp_table_size = 20M max_heap_table_size = 20M long_query_time = 3 log-slave-updates log-bin = /home/longxibendi/mysql/3309/binlog/binlog binlog_cache_size = 4M binlog_format = MIXED max_binlog_cache_size = 8M max_binlog_size = 20M relay-log-index = /home/longxibendi/mysql/3309/relaylog/relaylog relay-log-info-file = /home/longxibendi/mysql/3309/relaylog/relaylog relay-log = /home/longxibendi/mysql/3309/relaylog/relaylog expire_logs_days = 30 key_buffer_size = 10M read_buffer_size = 1M read_rnd_buffer_size = 6M bulk_insert_buffer_size = 4M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 20M myisam_repair_threads = 1 myisam_recover interactive_timeout = 120 wait_timeout = 120 skip-name-resolve #master-connect-retry = 10 slave-skip-errors = 1032,1062,126,1114,1146,1048,1396 #master-host = 192.168.1.2 #master-user = username #master-password = password #master-port = 3309 server-id = 1 innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 20M innodb_data_file_path = ibdata1:56M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 8 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 16M innodb_log_file_size = 20M innodb_log_files_in_group = 3 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 innodb_file_per_table = 0 #log-slow-queries = /home/longxibendi/mysql/3309/slow.log #long_query_time = 10 [mysqldump] quick max_allowed_packet = 32M " > /home/longxibendi/mysql/3309/my.cnf ############################### solve bug http://bugs.mysql.com/bug.php?id=37942 ############################################# mkdir -p /home/longxibendi/mysql/share/mysql/english/ cp /home/longxibendi/mysql/usr/local/mysql/share/mysql/english/errmsg.sys /home/longxibendi/mysql/share/mysql/english/ ############################### start MySQL Server ############################################# /bin/sh /home/longxibendi/mysql/usr/local/mysql/bin/mysqld_safe --defaults-file=/home/longxibendi/mysql/3309/my.cnf 2>&1 > /dev/null & ############################### try use MySQL Server ############################################# /home/longxibendi/mysql/usr/local/mysql/bin/mysql -u root -p -S /home/longxibendi/mysql/usr/local/mysql/sock/mysql.sock -P3309 -h127.0.0.1 -e "show databases;"
四.成功安裝結(jié)果
當(dāng)安裝完成之后，直接回車，就可以看到以下信息
information_schema
mysql
test
以上就是mysql 5.1.45編譯安裝配置方法，希望對(duì)大家的學(xué)習(xí)有所幫助。
您可能感興趣的文章:
- MySQL自動(dòng)安裝批處理腳本實(shí)例代碼
- 詳解docker?制作mysql鏡像并自動(dòng)安裝腳本
- mysql8.0.14.zip安裝時(shí)自動(dòng)創(chuàng)建data文件夾失敗服務(wù)無(wú)法啟動(dòng)
- Linux下mysql5.6.24（二進(jìn)制）自動(dòng)安裝腳本
- 生產(chǎn)庫(kù)自動(dòng)化MySQL5.6安裝部署詳細(xì)教程
- MySQL的源碼安裝及使用UDFs進(jìn)行數(shù)據(jù)自動(dòng)更新的教程
- 集群運(yùn)維自動(dòng)化工具ansible使用playbook安裝mysql
- 分享MySQL的自動(dòng)化安裝部署的方法
- mysql自動(dòng)化安裝腳本(ubuntu and centos64)
- MySQL自動(dòng)安裝腳本代碼實(shí)例分享
相關(guān)文章
LIMIT 語(yǔ)句用于限制查詢返回的行數(shù),常用于分頁(yè)查詢或取部分?jǐn)?shù)據(jù),提高查詢效率,這篇文章主要介紹了MySQL 中的 LIMIT 語(yǔ)句,需要的朋友可以參考下2025-04-04
MySQL定時(shí)備份之使用Linux下的crontab定時(shí)備份實(shí)例
這篇文章主要介紹了使用Linux下的crontab進(jìn)行MySQL定時(shí)備份的例子,需要的朋友可以參考下2014-04-04
MySQL如何從數(shù)據(jù)庫(kù)中刪除表中所有數(shù)據(jù)
這篇文章主要介紹了MySQL如何從數(shù)據(jù)庫(kù)中刪除表中所有數(shù)據(jù)問(wèn)題，具有很好的參考價(jià)值，希望對(duì)大家有所幫助。如有錯(cuò)誤或未考慮完全的地方，望不吝賜教2023-06-06
mysql 5.7.17 winx64免安裝版配置方法圖文教程
這篇文章主要為大家詳細(xì)介紹了mysql 5.7.17 winx64免安裝版配置方法圖文教程，具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下2017-01-01
關(guān)于mysql時(shí)間區(qū)間問(wèn)題淺析
在很多地方都使用到了mysql的日期查詢,下面這篇文章主要給大家介紹了關(guān)于mysql時(shí)間區(qū)間問(wèn)題的相關(guān)資料,文中通過(guò)實(shí)例代碼介紹的非常詳細(xì),需要的朋友可以參考下2022-04-04
一個(gè)單引號(hào)引發(fā)的MYSQL性能問(wèn)題分析
剛剛我們說(shuō)過(guò)了，生活中難免會(huì)有一些不如意，比如，我們用一個(gè)字符串類型的字段來(lái)作為主鍵，表面上，這太不如意了，然而，事實(shí)也證明這是有用的。2011-03-03
這篇文章主要為大家詳細(xì)介紹了linux下使用RPM安裝mysql5.7.17的相關(guān)代碼，具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下2017-03-03
MySQL事務(wù)與隔離級(jí)別的使用基礎(chǔ)理論
這篇文章主要介紹了MySQL事務(wù)的隔離級(jí)別詳情，事務(wù)隔離級(jí)別越高，為避免沖突所花費(fèi)的性能也就越多，即效率低。在“可重復(fù)讀”級(jí)別，實(shí)際上可以解決部分的虛讀問(wèn)題，但是不能防止update更新產(chǎn)生的虛讀問(wèn)題，要禁止虛讀產(chǎn)生，還是需要設(shè)置串行化隔離級(jí)別2023-02-02
從零開(kāi)始學(xué)習(xí)SQL查詢語(yǔ)句執(zhí)行順序
sql語(yǔ)言中的查詢的執(zhí)行順序，以前不是很了解，最近查閱了相關(guān)資料，在sql語(yǔ)言中，第一個(gè)被處理的字句總是from字句，最后執(zhí)行的limit操作，現(xiàn)在小編來(lái)和大家一起學(xué)習(xí)一下2019-05-05
MySQL中查看數(shù)據(jù)庫(kù)安裝路徑的方法
有時(shí)候在我們開(kāi)發(fā)的過(guò)程中并不一定記得數(shù)據(jù)庫(kù)的安裝路徑，比如要查看mysql 數(shù)據(jù)庫(kù)的安裝目錄在哪里，這里就為大家分享一下2021-03-03