mysql一键安装教程 mysql5.1.45全自动安装（编译安装）
一.问题来源
安装MySQL如果手动安装一台还可以，但安装多台，手动安装很麻烦，需要编写一个shell程序install_mysql.sh来进行安装
二.程序说明
将MySQL5.1.45安装到了/home/longxibendi/mysql/usrl/local/mysql
数据文件以及日志文件设置在了/home/longxibendi/mysql/3309/
配置文件my.cnf在 /home/longxibendi/mysql/3309
端口使用 3309
三.源程序install_mysql.sh
#!/bin/bash #authorlongxibendi #functioninstallMySQL5.1.45 ######################################configureandinstall##################################################### mkdir-p/home/longxibendi/mysql/usr/local/mysql cd mkdirmysql cdmysql wgethttp://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.45.tar.gz tarzxvfmysql-5.1.45.tar.gz cdmysql-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'modelname'|wc-l`&&makeinstall ######################################setloganddatastoragepath##################################################### 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/ ######################################createdatafile##################################################### /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 #######################################createmy.cnfprofile##################################################### 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 ###############################solvebughttp://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/ ###############################startMySQLServer############################################# /bin/sh/home/longxibendi/mysql/usr/local/mysql/bin/mysqld_safe--defaults-file=/home/longxibendi/mysql/3309/my.cnf2>&1>/dev/null& ###############################tryuseMySQLServer############################################# /home/longxibendi/mysql/usr/local/mysql/bin/mysql-uroot-p-S/home/longxibendi/mysql/usr/local/mysql/sock/mysql.sock-P3309-h127.0.0.1-e"showdatabases;"
#!/bin/bash #authorlongxibendi #functioninstallMySQL5.1.45 ######################################configureandinstall##################################################### mkdir-p/home/longxibendi/mysql/usr/local/mysql cd mkdirmysql cdmysql wgethttp://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.45.tar.gz tarzxvfmysql-5.1.45.tar.gz cdmysql-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'modelname'|wc-l`&&makeinstall ######################################setloganddatastoragepath##################################################### 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/ ######################################createdatafile##################################################### /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 #######################################createmy.cnfprofile##################################################### 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 ###############################solvebughttp://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/ ###############################startMySQLServer############################################# /bin/sh/home/longxibendi/mysql/usr/local/mysql/bin/mysqld_safe--defaults-file=/home/longxibendi/mysql/3309/my.cnf2>&1>/dev/null& ###############################tryuseMySQLServer############################################# /home/longxibendi/mysql/usr/local/mysql/bin/mysql-uroot-p-S/home/longxibendi/mysql/usr/local/mysql/sock/mysql.sock-P3309-h127.0.0.1-e"showdatabases;"
四.成功安装结果
当安装完成之后，直接回车，就可以看到以下信息
information_schema
mysql
test
以上就是mysql5.1.45编译安装配置方法，希望对大家的学习有所帮助。