在CentOS_6.7_x86-64上一鍵安裝MySQL5.5.32

fjzcau發表於2015-12-06
週末花了點時間,寫一個MySQL一鍵安裝的指令碼,留個記錄。安裝包是用原始碼編譯安裝後打包的。

一鍵安裝說明:
為避免給您帶來困擾,使用一鍵安裝指令碼請先理解指令碼的過程。

使用該指令碼您需要做的是:
1)準備好二進位制包
2)使用root執行指令碼

老男孩Linux培訓,請使用函式 oldboy_linux_train

老男孩老師的部落格

http://oldboy.blog.51cto.com/



  1. --編譯安裝mysql
  2. tar -zxf mysql-5.5.32.tar.gz
  3. cd mysql-5.5.32

  4. cmake \
  5. -DCMAKE_INSTALL_PREFIX=/opt/mysql-5.5.32 \
  6. -DMYSQL_DATADIR=/opt/mysql-5.5.32/data \
  7. -DMYSQL_USER=mysql \
  8. -DMYSQL_TCP_PORT=3306 \
  9. -DDEFAULT_CHARSET=utf8 \
  10. -DDEFAULT_COLLATION=utf8_general_ci \
  11. -DEXTRA_CHARSETS=all \
  12. -DWITH_MYISAM_STORAGE_ENGINE=1 \
  13. -DWITH_INNOBASE_STORAGE_ENGINE=1 \
  14. -DWITH_MEMORY_STORAGE_ENGINE=1 \
  15. -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
  16. -DWITH_FEDERATED_STORAGE_ENGINE=1 \
  17. -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
  18. -DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
  19. -DWITH_READLINE=1 \
  20. -DENABLED_LOCAL_INFILE=1 \
  21. -DWITH_ZLIB=bundled \
  22. -DWITH_FAST_MUTEXES=1 \
  23. -DWITH_EMBEDDED_SERVER=1 \
  24. -DWITH_DEBUG=0 \
  25. -DMYSQL_UNIX_ADDR=/opt/mysql-5.5.32/tmp/mysql.sock

  26. make
  27. make install

  28. --支援的字符集
  29. -DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii
  30. 最好用all
 
--安裝後,做個軟連結,方便升級後不改應用。
cd /opt
ln -s mysql-5.5.32 mysql

--打包為下面的二進位制安裝做準備
cd /opt
tar -zcf mysql-5.5.32_bin_x86_64.tar.gz mysql-5.5.32



  1. #!/bin/sh
  2. #####################################################
  3. # 老男孩linux運維實戰培訓中心
  4. # 培訓諮詢:QQ: 41117397 70271111 41117483 80042789
  5. # 培訓電話:18600338340 18911718229
  6. # 老男孩老師 QQ:49000448 31333741
  7. # 網站地址:http://www.etiantian.org
  8. # 老男孩部落格:http://oldboy.blog.51cto.com
  9. # 老男孩交流群 246054962208160987 226199307 44246017
  10. # 網站運維交流群:114580181 45039636 37081784
  11. #####################################################

  12. i_install_port=3306
  13. i_db_base_dir=/data/${i_install_port}
  14. i_db_data_dir=$i_db_base_dir/data
  15. i_root=root
  16. i_root_pwd=123456
  17. i_install_log=/tmp/mysql_install_`date +'%F_%T'`.log

  18. i_step=0
  19. #i_step=$(($i_step+1))
  20. #i_step=`expr $i_step + 1`
  21. #i_step=`echo $i_step + 1|bc`


  22. function mysql_config_info
  23. {
  24.   echo "*******************************************************" | tee -a $i_install_log
  25.   echo "** MySQL預設配置資訊 " | tee -a $i_install_log
  26.   echo "**軟體安裝路徑 :/opt/mysql/ " | tee -a $i_install_log
  27.   echo "**軟體包位置 :/root/tools/ " | tee -a $i_install_log
  28.   echo "**軟體包名 :mysql-5.5.32_bin_x86_64.tar.gz " | tee -a $i_install_log
  29.   echo "**例項base目錄 :$i_db_base_dir " | tee -a $i_install_log
  30.   echo "**例項data目錄 :$i_db_data_dir " | tee -a $i_install_log
  31.   echo "**例項預設埠 :$i_install_port " | tee -a $i_install_log
  32.   echo "**初始化root密碼 :$i_root_pwd " | tee -a $i_install_log
  33.   echo "*******************************************************" | tee -a $i_install_log
  34. }

  35. function mysql_flag_info
  36. {
  37.   echo "*******************************************************" | tee -a $i_install_log
  38.   echo "** 操作選項 " | tee -a $i_install_log
  39.   echo "** 0 退出安裝 " | tee -a $i_install_log
  40.   echo "** 1 預設配置安裝 " | tee -a $i_install_log
  41.   echo "** 2 設定例項base目錄 " | tee -a $i_install_log
  42.   echo "** 3 設定例項data目錄 " | tee -a $i_install_log
  43.   echo "** 4 設定例項預設埠 " | tee -a $i_install_log
  44.   echo "** 5 初始化root密碼 " | tee -a $i_install_log
  45.   echo "** 6 檢視引數配置 " | tee -a $i_install_log
  46.   echo "** 7 操作選項幫助 " | tee -a $i_install_log
  47.   echo "** 8 完成引數設定,準備開始安裝 " | tee -a $i_install_log
  48.   echo "** 9 老男孩Linux培訓諮詢 " | tee -a $i_install_log
  49.   echo "*******************************************************" | tee -a $i_install_log
  50. }

  51. function oldboy_linux_train
  52. {
  53.   echo "#####################################################" | tee -a $i_install_log
  54.   echo "# 老男孩linux運維實戰培訓中心 " | tee -a $i_install_log
  55.   echo "# 培訓諮詢:QQ: 41117397 70271111 41117483 80042789 " | tee -a $i_install_log
  56.   echo "# 培訓電話:18600338340 18911718229 " | tee -a $i_install_log
  57.   echo "# 老男孩老師 QQ:49000448 31333741 " | tee -a $i_install_log
  58.   echo "# 網站地址: " | tee -a $i_install_log
  59.   echo "# 老男孩部落格:http://oldboy.blog.51cto.com " | tee -a $i_install_log
  60.   echo "# 老男孩交流群 246054962208160987 226199307 44246017" | tee -a $i_install_log
  61.   echo "# 網站運維交流群:114580181 45039636 37081784 " | tee -a $i_install_log
  62.   echo "#####################################################" | tee -a $i_install_log
  63. }

  64. # 老男孩Linux培訓諮詢,歡迎大家
  65. oldboy_linux_train

  66. # 配置引數
  67. mysql_config_info

  68. # 操作選項幫助
  69. mysql_flag_info

  70. # 引數配置,輸入9,結束配置
  71. while [ 1 = 1 ]
  72. do
  73.   read -p "【Enter:[0-9]】" i_install_flag
  74.   case "$i_install_flag" in
  75.     0)
  76.       echo "**您輸入的是:$i_install_flag 退出安裝" | tee -a $i_install_log
  77.       exit 0
  78.     ;;
  79.     1)
  80.       echo "**您輸入的是:$i_install_flag 預設配置安裝" | tee -a $i_install_log
  81.     ;;
  82.     2)
  83.       echo "**您輸入的是:$i_install_flag 設定例項base目錄" | tee -a $i_install_log
  84.       read -p "【設定例項base目錄】:" i_db_base_dir
  85.       echo "-->例項base目錄為:$i_db_base_dir" | tee -a $i_install_log
  86.     ;;
  87.     3)
  88.       echo "**您輸入的是:$i_install_flag 設定例項data目錄" | tee -a $i_install_log
  89.       read -p "【設定例項data目錄】:" i_db_data_dir
  90.       echo "-->例項data目錄為:$i_db_data_dir" | tee -a $i_install_log
  91.     ;;
  92.     4)
  93.       echo "**您輸入的是:$i_install_flag 設定例項預設埠" | tee -a $i_install_log
  94.       read -p "【輸入埠[1000-65535]】:" i_install_port
  95.       echo "-->新埠號為:$i_install_port" | tee -a $i_install_log
  96.     ;;
  97.     5)
  98.       echo "**您輸入的是:$i_install_flag 初始化root密碼" | tee -a $i_install_log
  99.       read -p "【初始化root密碼】:" i_root_pwd
  100.       echo "-->初始化root密碼為:$i_root_pwd" | tee -a $i_install_log
  101.     ;;
  102.     6)
  103.       echo "**您輸入的是:$i_install_flag 檢視引數配置" | tee -a $i_install_log
  104.       mysql_config_info
  105.     ;;
  106.     7)
  107.       echo "**您輸入的是:$i_install_flag 操作選項幫助" | tee -a $i_install_log
  108.       mysql_flag_info
  109.     ;;
  110.     8)
  111.       echo "**您輸入的是:$i_install_flag 完成引數設定,準備開始安裝" | tee -a $i_install_log
  112.       break
  113.     ;;
  114.     9)
  115.       echo "**您輸入的是:$i_install_flag 老男孩Linux培訓諮詢" | tee -a $i_install_log
  116.       oldboy_linux_train
  117.     ;;
  118.     *)
  119.       echo "**您輸入的是:$i_install_flag Error!!" | tee -a $i_install_log
  120.       mysql_flag_info
  121.     ;;
  122.   esac
  123. done
  124. # End while [ 1 = 1 ]


  125. # 安裝前,最後檢查配置引數
  126. echo "-->安裝前,最後檢查配置引數,請仔細核對資訊!" | tee -a $i_install_log
  127. mysql_config_info
  128. read -p "【Enter:Y[y]:開始一鍵安裝 其他:退出】" i_install_flag

  129. if [ $i_install_flag = "Y" -o $i_install_flag = "y" ]
  130. then
  131.   echo "-->Step $i_step,`date +'%F_%T'`,MySQL一鍵安裝開始..." | tee -a $i_install_log
  132.   i_step=$(($i_step+1))
  133. else
  134.   echo "退出安裝" | tee -a $i_install_log
  135.   exit 0
  136. fi

  137. #echo "-->!! 對不起,還未準備好一鍵安裝,您太著急了!!"

  138. # 開始一鍵安裝,若存在安裝包,則開始,否則退出。
  139. if [ -f /root/tools/mysql-5.5.32_bin_x86_64.tar.gz ]
  140. then
  141.   echo "-->Step $i_step,`date +'%F_%T'`,安裝軟體包." | tee -a $i_install_log
  142.   i_step=$(($i_step+1))
  143.   cd /root/tools
  144.   tar -zxf mysql-5.5.32_bin_x86_64.tar.gz -C /opt
  145.   cd /opt
  146.   ln -s mysql-5.5.32 mysql
  147.   ls -l /opt
  148.   echo "export PATH=/opt/mysql/bin:\$PATH" >> /etc/profile
  149.   tail -1 /etc/profile
  150.   source /etc/profile
  151.   echo $PATH | tee -a $i_install_log
  152.   
  153.   # 建立使用者和組
  154.   echo "-->Step $i_step,`date +'%F_%T'`,建立使用者和組." | tee -a $i_install_log
  155.   i_step=$(($i_step+1))
  156.   groupadd mysql
  157.   useradd mysql -s /sbin/nologin -M -g mysql
  158.   
  159.   # 建立資料目錄
  160.   echo "-->Step $i_step,`date +'%F_%T'`,建立例項目錄,屬主為mysql." | tee -a $i_install_log
  161.   i_step=$(($i_step+1))
  162.   mkdir -p $i_db_data_dir
  163.   mkdir -p $i_db_base_dir/binlog
  164.   mkdir -p /opt/mysql-5.5.32/data
  165.   chown -R mysql:mysql /opt/mysql-5.5.32
  166.   chmod 1777 /tmp
  167.   chown -R mysql:mysql $i_db_data_dir
  168.   
  169.   # 若建立失敗,則退出
  170.   if [ ! -d $i_db_base_dir ]
  171.   then
  172.     echo "-->Step $i_step,`date +'%F_%T'`,例項目錄建立失敗,退出安裝." | tee -a $i_install_log
  173.     i_step=$(($i_step+1))
  174.     echo "!!! Mysql data dir $i_db_base_dir not exist!" | tee -a $i_install_log
  175.     exit 1
  176.   fi
  177.   
  178.   ###############################################################
  179.   # 一鍵生成mysql配置檔案 BEGIN
  180.   ###############################################################
  181.   echo "-->Step $i_step,`date +'%F_%T'`,一鍵生成mysql配置檔案 ${i_db_base_dir}/my.cnf ." | tee -a $i_install_log
  182.   i_step=$(($i_step+1))
  183.   cat > $i_db_base_dir/my.cnf << EOF
  184. [client]
  185. port = $i_install_port
  186. socket = $i_db_base_dir/mysql.sock

  187. [mysql]
  188. no-auto-rehash

  189. [mysqld]
  190. user = mysql
  191. port = $i_install_port
  192. socket = $i_db_base_dir/mysql.sock
  193. basedir = /opt/mysql
  194. datadir = $i_db_data_dir
  195. open_files_limit = 1024
  196. back_log = 600
  197. max_connections = 800
  198. max_connect_errors = 3000
  199. table_cache = 614
  200. external-locking = FALSE
  201. max_allowed_packet =8M
  202. sort_buffer_size = 1M
  203. join_buffer_size = 1M
  204. thread_cache_size = 100
  205. thread_concurrency = 2
  206. query_cache_size = 2M
  207. query_cache_limit = 1M
  208. query_cache_min_res_unit = 2k
  209. #default_table_type = InnoDB
  210. thread_stack = 192K
  211. #transaction_isolation = READ-COMMITTED
  212. tmp_table_size = 2M
  213. max_heap_table_size = 2M
  214. long_query_time = 1
  215. #log_long_format
  216. #log-error = $i_db_base_dir/error.log
  217. #log-slow-queries = $i_db_base_dir/slow.log
  218. pid-file = $i_db_base_dir/mysql.pid
  219. log-bin = $i_db_base_dir/binlog/mysql-bin
  220. relay-log = $i_db_base_dir/binlog/relay-bin
  221. relay-log-info-file = $i_db_base_dir/binlog/relay-log.info
  222. binlog_cache_size = 1M
  223. max_binlog_cache_size = 1M
  224. max_binlog_size = 2M
  225. expire_logs_days = 7
  226. key_buffer_size = 16M
  227. read_buffer_size = 1M
  228. read_rnd_buffer_size = 1M
  229. bulk_insert_buffer_size = 1M
  230. #myisam_sort_buffer_size = 1M
  231. #myisam_max_sort_file_size = 10G
  232. #myisam_max_extra_sort_file_size = 10G
  233. #myisam_repair_threads = 1
  234. #myisam_recover

  235. lower_case_table_names = 1
  236. skip-name-resolve
  237. slave-skip-errors = 1032,1062
  238. #replicate-ignore-db=mysql

  239. server-id = 1

  240. innodb_additional_mem_pool_size = 4M
  241. innodb_buffer_pool_size = 32M
  242. innodb_data_file_path = ibdata1:128M:autoextend
  243. innodb_file_io_threads = 4
  244. innodb_thread_concurrency = 8
  245. innodb_flush_log_at_trx_commit = 2
  246. innodb_log_buffer_size = 2M
  247. innodb_log_file_size = 4M
  248. innodb_log_files_in_group = 3
  249. innodb_max_dirty_pages_pct = 90
  250. innodb_lock_wait_timeout = 120
  251. innodb_file_per_table = 0

  252. [mysqldump]
  253. quick
  254. max_allowed_packet = 2M

  255. [mysqld_safe]
  256. log-error=$i_db_base_dir/mysql_${i_install_port}.err
  257. pid-file=$i_db_base_dir/mysqld.pid

  258. EOF
  259. # END 一鍵生成mysql配置檔案

  260. ###############################################################
  261. # 一鍵生成mysql啟停指令碼 BEGIN
  262. ###############################################################
  263.   echo "-->Step $i_step,`date +'%F_%T'`,一鍵生成mysql啟停指令碼 ${i_db_base_dir}/mysql ." | tee -a $i_install_log
  264.   i_step=$(($i_step+1))
  265.   cat > $i_db_base_dir/mysql <<EOF

  266. #############################################################
  267. # $i_db_base_dir/mysql 啟停指令碼
  268. #############################################################
  269. CmdPath="/opt/mysql/bin"
  270. mysql_user="$i_root"
  271. mysql_pwd="$i_root_pwd"
  272. port=$i_install_port
  273. mysql_db_base=$i_db_base_dir
  274. mysql_sock="\${mysql_db_base}/mysql.sock"

  275. #startup function
  276. function_start_mysql()
  277. {
  278.     if [ ! -e "\$mysql_sock" ];then
  279.       printf "Starting MySQL...\n"
  280.       /bin/sh \${CmdPath}/mysqld_safe --defaults-file=\${mysql_db_base}/my.cnf > /dev/null 2>&1 &
  281.     else
  282.       printf "MySQL is running...\n"
  283.       exit
  284.     fi
  285. }

  286. #stop function
  287. function_stop_mysql()
  288. {
  289.     if [ ! -e "\$mysql_sock" ];then
  290.        printf "MySQL is stopped...\n"
  291.        exit
  292.     else
  293.        printf "Stoping MySQL...\n"
  294.        \${CmdPath}/mysqladmin -u \${mysql_user} -p\${mysql_pwd} -S \${mysql_db_base}/mysql.sock shutdown
  295.    fi
  296. }

  297. #restart function
  298. function_restart_mysql()
  299. {
  300.     printf "Restarting MySQL...\n"
  301.     function_stop_mysql
  302.     sleep 2
  303.     function_start_mysql
  304. }

  305. case \$1 in
  306. start)
  307.     function_start_mysql
  308. ;;
  309. stop)
  310.     function_stop_mysql
  311. ;;
  312. restart)
  313.     function_restart_mysql
  314. ;;
  315. *)
  316.     printf "Usage: \${mysql_db_base}/mysql {start|stop|restart}\n"
  317. esac

  318. EOF
  319. # END 一鍵生成mysql啟停指令碼

  320.   # 修改mysql資料目錄屬主
  321.   chown -R mysql:mysql $i_db_base_dir
  322.   chown -R mysql:mysql $i_db_data_dir

  323.   # 修改mysql啟停指令碼執行許可權
  324.   chmod +x $i_db_base_dir/mysql

  325.   # 模組載入
  326.   echo "/opt/mysql/include" >> /etc/ld.so.conf
  327.   echo "/opt/mysql/lib" >> /etc/ld.so.conf
  328.   ldconfig

  329.   # 初始化資料庫
  330.   echo "-->Step $i_step,`date +'%F_%T'`,初始化資料庫." | tee -a $i_install_log
  331.   i_step=$(($i_step+1))
  332.   echo " 【Command】:/opt/mysql/scripts/mysql_install_db --basedir=/opt/mysql --datadir=$i_db_data_dir --user=mysql" | tee -a $i_install_log
  333.   /opt/mysql/scripts/mysql_install_db --basedir=/opt/mysql --datadir=$i_db_data_dir --user=mysql >> $i_install_log
  334.   
  335.   #初次啟動,root沒有密碼
  336.   echo "-->Step $i_step,`date +'%F_%T'`,mysql starting..." | tee -a $i_install_log
  337.   i_step=$(($i_step+1))
  338.   echo " 【Command】:/opt/mysql/bin/mysqld_safe --defaults-file=$i_db_base_dir/my.cnf > /dev/null 2>&1 &" | tee -a $i_install_log
  339.   /opt/mysql/bin/mysqld_safe --defaults-file=$i_db_base_dir/my.cnf > /dev/null 2>&1 &
  340.  
  341.   # 睡眠時間要足夠長,等待mysql啟動成功後初始化密碼
  342.   echo "-->Step $i_step,`date +'%F_%T'`,sleep 60 seconds." | tee -a $i_install_log
  343.   i_step=$(($i_step+1))
  344.   sleep 60

  345.   # 設定root密碼
  346.   echo "-->Step $i_step,`date +'%F_%T'`,設定root密碼." | tee -a $i_install_log
  347.   i_step=$(($i_step+1))
  348.   echo " 【Command】:/opt/mysql/bin/mysqladmin -S $i_db_base_dir/mysql.sock -u${i_root} password \"${i_root_pwd}\" " >> $i_install_log
  349.   /opt/mysql/bin/mysqladmin -S $i_db_base_dir/mysql.sock -u${i_root} password "${i_root_pwd}"
  350.   sleep 1
  351.   
  352.   # 登入測試
  353.   echo "-->Step $i_step,`date +'%F_%T'`,一切OK了,登入測試一把." | tee -a $i_install_log
  354.   i_step=$(($i_step+1))
  355.   echo " 【Command】:/opt/mysql/bin/mysql -u${i_root} -p${i_root_pwd} -S $i_db_base_dir/mysql.sock -e \"show variables like '%character%'\" " | tee -a $i_install_log
  356.   /opt/mysql/bin/mysql -u${i_root} -p${i_root_pwd} -S $i_db_base_dir/mysql.sock -e "show variables like '%character%'" >> $i_install_log
  357.   
  358. else
  359.   echo "-->Step $i_step,`date +'%F_%T'`,mysql-5.5.32_bin_x86_64.tar.gz 不存在,請重新上傳!!" | tee -a $i_install_log
  360.   i_step=$(($i_step+1))
  361.   exit 1
  362. fi
###################################################################
#  安裝過程日誌
###################################################################

  1. #####################################################
  2. # 老男孩linux運維實戰培訓中心
  3. # 培訓諮詢:QQ: 41117397 70271111 41117483 80042789
  4. # 培訓電話:18600338340 18911718229
  5. # 老男孩老師 QQ:49000448 31333741
  6. # 網站地址:http://www.etiantian.org
  7. # 老男孩部落格:http://oldboy.blog.51cto.com
  8. # 老男孩交流群 246054962208160987 226199307 44246017
  9. # 網站運維交流群:114580181 45039636 37081784
  10. #####################################################
  11. *******************************************************
  12. ** MySQL預設配置資訊
  13. **軟體安裝路徑 :/opt/mysql/
  14. **軟體包位置 :/root/tools/
  15. **軟體包名 :mysql-5.5.32_bin_x86_64.tar.gz
  16. **例項base目錄 :/data/3306
  17. **例項data目錄 :/data/3306/data
  18. **例項預設埠 :3306
  19. **初始化root密碼 :123456
  20. *******************************************************
  21. *******************************************************
  22. ** 操作選項
  23. ** 0 退出安裝
  24. ** 1 預設配置安裝
  25. ** 2 設定例項base目錄
  26. ** 3 設定例項data目錄
  27. ** 4 設定例項預設埠
  28. ** 5 初始化root密碼
  29. ** 6 檢視引數配置
  30. ** 7 操作選項幫助
  31. ** 8 完成引數設定,準備開始安裝
  32. ** 9 老男孩Linux培訓諮詢
  33. *******************************************************
  34. **您輸入的是:2 設定例項base目錄
  35. -->例項base目錄為:/data/3307
  36. **您輸入的是:3 設定例項data目錄
  37. -->例項data目錄為:/data/3307/data
  38. **您輸入的是:4 設定例項預設埠
  39. -->新埠號為:3307
  40. **您輸入的是:5 初始化root密碼
  41. -->初始化root密碼為:123456789
  42. **您輸入的是:6 檢視引數配置
  43. *******************************************************
  44. ** MySQL預設配置資訊
  45. **軟體安裝路徑 :/opt/mysql/
  46. **軟體包位置 :/root/tools/
  47. **軟體包名 :mysql-5.5.32_bin_x86_64.tar.gz
  48. **例項base目錄 :/data/3307
  49. **例項data目錄 :/data/3307/data
  50. **例項預設埠 :3307
  51. **初始化root密碼 :123456789
  52. *******************************************************
  53. **您輸入的是:9 老男孩Linux培訓諮詢
  54. #####################################################
  55. # 老男孩linux運維實戰培訓中心
  56. # 培訓諮詢:QQ: 41117397 70271111 41117483 80042789
  57. # 培訓電話:18600338340 18911718229
  58. # 老男孩老師 QQ:49000448 31333741
  59. # 網站地址:http://www.etiantian.org
  60. # 老男孩部落格:http://oldboy.blog.51cto.com
  61. # 老男孩交流群 246054962208160987 226199307 44246017
  62. # 網站運維交流群:114580181 45039636 37081784
  63. #####################################################
  64. **您輸入的是:h
  65. *******************************************************
  66. ** 操作選項
  67. ** 0 退出安裝
  68. ** 1 預設配置安裝
  69. ** 2 設定例項base目錄
  70. ** 3 設定例項data目錄
  71. ** 4 設定例項預設埠
  72. ** 5 初始化root密碼
  73. ** 6 檢視引數配置
  74. ** 7 操作選項幫助
  75. ** 8 完成引數設定,準備開始安裝
  76. ** 9 老男孩Linux培訓諮詢
  77. *******************************************************
  78. **您輸入的是:6 檢視引數配置
  79. *******************************************************
  80. ** MySQL預設配置資訊
  81. **軟體安裝路徑 :/opt/mysql/
  82. **軟體包位置 :/root/tools/
  83. **軟體包名 :mysql-5.5.32_bin_x86_64.tar.gz
  84. **例項base目錄 :/data/3307
  85. **例項data目錄 :/data/3307/data
  86. **例項預設埠 :3307
  87. **初始化root密碼 :123456789
  88. *******************************************************
  89. **您輸入的是:8 完成引數設定,準備開始安裝
  90. -->安裝前,最後檢查配置引數,請仔細核對資訊!
  91. *******************************************************
  92. ** MySQL預設配置資訊
  93. **軟體安裝路徑 :/opt/mysql/
  94. **軟體包位置 :/root/tools/
  95. **軟體包名 :mysql-5.5.32_bin_x86_64.tar.gz
  96. **例項base目錄 :/data/3307
  97. **例項data目錄 :/data/3307/data
  98. **例項預設埠 :3307
  99. **初始化root密碼 :123456789
  100. *******************************************************
  101. -->Step 0,2015-12-05_17:05:28,MySQL一鍵安裝開始...
  102. -->Step 1,2015-12-05_17:05:28,安裝軟體包.
  103. /opt/mysql/bin:/opt/mysql/bin:/opt/mysql/bin:/opt/mysql/bin:/opt/mysql/bin:/opt/mysql/bin:/opt/mysql/bin:/opt/mysql/bin:/opt/mysql/bin:/opt/mysql/bin:/opt/mysql/bin:/opt/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
  104. -->Step 2,2015-12-05_17:06:00,建立使用者和組.
  105. -->Step 3,2015-12-05_17:06:01,建立例項目錄,屬主為mysql.
  106. -->Step 4,2015-12-05_17:06:01,一鍵生成mysql配置檔案 /data/3307/my.cnf .
  107. -->Step 5,2015-12-05_17:06:01,一鍵生成mysql啟停指令碼 /data/3307/mysql .
  108. -->Step 6,2015-12-05_17:06:01,初始化資料庫.
  109.  【Command】:/opt/mysql/scripts/mysql_install_db --basedir=/opt/mysql --datadir=/data/3307/data --user=mysql
  110. Installing MySQL system tables...
  111. OK
  112. Filling help tables...
  113. OK

  114. To start mysqld at boot time you have to copy
  115. support-files/mysql.server to the right place for your system

  116. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
  117. To do so, start the server, then issue the following commands:

  118. /opt/mysql/bin/mysqladmin -u root password 'new-password'
  119. /opt/mysql/bin/mysqladmin -u root -h data-1-2 password 'new-password'

  120. Alternatively you can run:
  121. /opt/mysql/bin/mysql_secure_installation

  122. which will also give you the option of removing the test
  123. databases and anonymous user created by default. This is
  124. strongly recommended for production servers.

  125. See the manual for more instructions.

  126. You can start the MySQL daemon with:
  127. cd /opt/mysql ; /opt/mysql/bin/mysqld_safe &

  128. You can test the MySQL daemon with mysql-test-run.pl
  129. cd /opt/mysql/mysql-test ; perl mysql-test-run.pl

  130. Please report any problems with the /opt/mysql/scripts/mysqlbug

  131. -->Step 7,2015-12-05_17:06:02,mysql starting...
  132.   【Command】:/opt/mysql/bin/mysqld_safe --defaults-file=/data/3307/my.cnf > /dev/null 2>&1 &
  133. -->Step 8,2015-12-05_17:06:02,sleep 60 seconds.
  134. -->Step 9,2015-12-05_17:07:02,設定root密碼.
  135.   【Command】:/opt/mysql/bin/mysqladmin -S /data/3307/mysql.sock -uroot password "123456789"
  136. -->Step 10,2015-12-05_17:07:03,一切OK了,登入測試一把.
  137.   【Command】:/opt/mysql/bin/mysql -uroot -p123456789 -S /data/3307/mysql.sock -e "show variables like '%character%'"
  138. +--------------------------+-----------------------------------+
  139. | Variable_name | Value |
  140. +--------------------------+-----------------------------------+
  141. | character_set_client | utf8 |
  142. | character_set_connection | utf8 |
  143. | character_set_database | utf8 |
  144. | character_set_filesystem | binary |
  145. | character_set_results | utf8 |
  146. | character_set_server | utf8 |
  147. | character_set_system | utf8 |
  148. | character_sets_dir | /opt/mysql-5.5.32/share/charsets/ |
  149. +--------------------------+-----------------------------------+

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22661144/viewspace-1867159/,如需轉載,請註明出處,否則將追究法律責任。

相關文章