在CentOS_6.7_x86-64上一鍵安裝MySQL5.5.32
週末花了點時間,寫一個MySQL一鍵安裝的指令碼,留個記錄。安裝包是用原始碼編譯安裝後打包的。
一鍵安裝說明:
為避免給您帶來困擾,使用一鍵安裝指令碼請先理解指令碼的過程。
使用該指令碼您需要做的是:
1)準備好二進位制包
2)使用root執行指令碼
老男孩Linux培訓,請使用函式 oldboy_linux_train!
老男孩老師的部落格
http://oldboy.blog.51cto.com/
--安裝後,做個軟連結,方便升級後不改應用。
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)準備好二進位制包
2)使用root執行指令碼
老男孩Linux培訓,請使用函式 oldboy_linux_train!
老男孩老師的部落格
http://oldboy.blog.51cto.com/
-
--編譯安裝mysql
-
tar -zxf mysql-5.5.32.tar.gz
-
cd mysql-5.5.32
-
-
cmake \
-
-DCMAKE_INSTALL_PREFIX=/opt/mysql-5.5.32 \
-
-DMYSQL_DATADIR=/opt/mysql-5.5.32/data \
-
-DMYSQL_USER=mysql \
-
-DMYSQL_TCP_PORT=3306 \
-
-DDEFAULT_CHARSET=utf8 \
-
-DDEFAULT_COLLATION=utf8_general_ci \
-
-DEXTRA_CHARSETS=all \
-
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-
-DWITH_READLINE=1 \
-
-DENABLED_LOCAL_INFILE=1 \
-
-DWITH_ZLIB=bundled \
-
-DWITH_FAST_MUTEXES=1 \
-
-DWITH_EMBEDDED_SERVER=1 \
-
-DWITH_DEBUG=0 \
-
-DMYSQL_UNIX_ADDR=/opt/mysql-5.5.32/tmp/mysql.sock
-
-
make
-
make install
-
-
--支援的字符集
-
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii
- 最好用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
-
#!/bin/sh
-
#####################################################
-
# 老男孩linux運維實戰培訓中心
-
# 培訓諮詢:QQ: 41117397 70271111 41117483 80042789
-
# 培訓電話:18600338340 18911718229
-
# 老男孩老師 QQ:49000448 31333741
-
# 網站地址:http://www.etiantian.org
-
# 老男孩部落格:http://oldboy.blog.51cto.com
-
# 老男孩交流群 246054962208160987 226199307 44246017
-
# 網站運維交流群:114580181 45039636 37081784
-
#####################################################
-
-
i_install_port=3306
-
i_db_base_dir=/data/${i_install_port}
-
i_db_data_dir=$i_db_base_dir/data
-
i_root=root
-
i_root_pwd=123456
-
i_install_log=/tmp/mysql_install_`date +'%F_%T'`.log
-
-
i_step=0
-
#i_step=$(($i_step+1))
-
#i_step=`expr $i_step + 1`
-
#i_step=`echo $i_step + 1|bc`
-
-
-
function mysql_config_info
-
{
-
echo "*******************************************************" | tee -a $i_install_log
-
echo "** MySQL預設配置資訊 " | tee -a $i_install_log
-
echo "**軟體安裝路徑 :/opt/mysql/ " | tee -a $i_install_log
-
echo "**軟體包位置 :/root/tools/ " | tee -a $i_install_log
-
echo "**軟體包名 :mysql-5.5.32_bin_x86_64.tar.gz " | tee -a $i_install_log
-
echo "**例項base目錄 :$i_db_base_dir " | tee -a $i_install_log
-
echo "**例項data目錄 :$i_db_data_dir " | tee -a $i_install_log
-
echo "**例項預設埠 :$i_install_port " | tee -a $i_install_log
-
echo "**初始化root密碼 :$i_root_pwd " | tee -a $i_install_log
-
echo "*******************************************************" | tee -a $i_install_log
-
}
-
-
function mysql_flag_info
-
{
-
echo "*******************************************************" | tee -a $i_install_log
-
echo "** 操作選項 " | tee -a $i_install_log
-
echo "** 0 退出安裝 " | tee -a $i_install_log
-
echo "** 1 預設配置安裝 " | tee -a $i_install_log
-
echo "** 2 設定例項base目錄 " | tee -a $i_install_log
-
echo "** 3 設定例項data目錄 " | tee -a $i_install_log
-
echo "** 4 設定例項預設埠 " | tee -a $i_install_log
-
echo "** 5 初始化root密碼 " | tee -a $i_install_log
-
echo "** 6 檢視引數配置 " | tee -a $i_install_log
-
echo "** 7 操作選項幫助 " | tee -a $i_install_log
-
echo "** 8 完成引數設定,準備開始安裝 " | tee -a $i_install_log
-
echo "** 9 老男孩Linux培訓諮詢 " | tee -a $i_install_log
-
echo "*******************************************************" | tee -a $i_install_log
-
}
-
-
function oldboy_linux_train
-
{
-
echo "#####################################################" | tee -a $i_install_log
-
echo "# 老男孩linux運維實戰培訓中心 " | tee -a $i_install_log
-
echo "# 培訓諮詢:QQ: 41117397 70271111 41117483 80042789 " | tee -a $i_install_log
-
echo "# 培訓電話:18600338340 18911718229 " | tee -a $i_install_log
-
echo "# 老男孩老師 QQ:49000448 31333741 " | tee -a $i_install_log
-
echo "# 網站地址: " | tee -a $i_install_log
-
echo "# 老男孩部落格:http://oldboy.blog.51cto.com " | tee -a $i_install_log
-
echo "# 老男孩交流群 246054962208160987 226199307 44246017" | tee -a $i_install_log
-
echo "# 網站運維交流群:114580181 45039636 37081784 " | tee -a $i_install_log
-
echo "#####################################################" | tee -a $i_install_log
-
}
-
-
# 老男孩Linux培訓諮詢,歡迎大家
-
oldboy_linux_train
-
-
# 配置引數
-
mysql_config_info
-
-
# 操作選項幫助
-
mysql_flag_info
-
-
# 引數配置,輸入9,結束配置
-
while [ 1 = 1 ]
-
do
-
read -p "【Enter:[0-9]】" i_install_flag
-
case "$i_install_flag" in
-
0)
-
echo "**您輸入的是:$i_install_flag 退出安裝" | tee -a $i_install_log
-
exit 0
-
;;
-
1)
-
echo "**您輸入的是:$i_install_flag 預設配置安裝" | tee -a $i_install_log
-
;;
-
2)
-
echo "**您輸入的是:$i_install_flag 設定例項base目錄" | tee -a $i_install_log
-
read -p "【設定例項base目錄】:" i_db_base_dir
-
echo "-->例項base目錄為:$i_db_base_dir" | tee -a $i_install_log
-
;;
-
3)
-
echo "**您輸入的是:$i_install_flag 設定例項data目錄" | tee -a $i_install_log
-
read -p "【設定例項data目錄】:" i_db_data_dir
-
echo "-->例項data目錄為:$i_db_data_dir" | tee -a $i_install_log
-
;;
-
4)
-
echo "**您輸入的是:$i_install_flag 設定例項預設埠" | tee -a $i_install_log
-
read -p "【輸入埠[1000-65535]】:" i_install_port
-
echo "-->新埠號為:$i_install_port" | tee -a $i_install_log
-
;;
-
5)
-
echo "**您輸入的是:$i_install_flag 初始化root密碼" | tee -a $i_install_log
-
read -p "【初始化root密碼】:" i_root_pwd
-
echo "-->初始化root密碼為:$i_root_pwd" | tee -a $i_install_log
-
;;
-
6)
-
echo "**您輸入的是:$i_install_flag 檢視引數配置" | tee -a $i_install_log
-
mysql_config_info
-
;;
-
7)
-
echo "**您輸入的是:$i_install_flag 操作選項幫助" | tee -a $i_install_log
-
mysql_flag_info
-
;;
-
8)
-
echo "**您輸入的是:$i_install_flag 完成引數設定,準備開始安裝" | tee -a $i_install_log
-
break
-
;;
-
9)
-
echo "**您輸入的是:$i_install_flag 老男孩Linux培訓諮詢" | tee -a $i_install_log
-
oldboy_linux_train
-
;;
-
*)
-
echo "**您輸入的是:$i_install_flag Error!!" | tee -a $i_install_log
-
mysql_flag_info
-
;;
-
esac
-
done
-
# End while [ 1 = 1 ]
-
-
-
# 安裝前,最後檢查配置引數
-
echo "-->安裝前,最後檢查配置引數,請仔細核對資訊!" | tee -a $i_install_log
-
mysql_config_info
-
read -p "【Enter:Y[y]:開始一鍵安裝 其他:退出】" i_install_flag
-
-
if [ $i_install_flag = "Y" -o $i_install_flag = "y" ]
-
then
-
echo "-->Step $i_step,`date +'%F_%T'`,MySQL一鍵安裝開始..." | tee -a $i_install_log
-
i_step=$(($i_step+1))
-
else
-
echo "退出安裝" | tee -a $i_install_log
-
exit 0
-
fi
-
-
#echo "-->!! 對不起,還未準備好一鍵安裝,您太著急了!!"
-
-
# 開始一鍵安裝,若存在安裝包,則開始,否則退出。
-
if [ -f /root/tools/mysql-5.5.32_bin_x86_64.tar.gz ]
-
then
-
echo "-->Step $i_step,`date +'%F_%T'`,安裝軟體包." | tee -a $i_install_log
-
i_step=$(($i_step+1))
-
cd /root/tools
-
tar -zxf mysql-5.5.32_bin_x86_64.tar.gz -C /opt
-
cd /opt
-
ln -s mysql-5.5.32 mysql
-
ls -l /opt
-
echo "export PATH=/opt/mysql/bin:\$PATH" >> /etc/profile
-
tail -1 /etc/profile
-
source /etc/profile
-
echo $PATH | tee -a $i_install_log
-
-
# 建立使用者和組
-
echo "-->Step $i_step,`date +'%F_%T'`,建立使用者和組." | tee -a $i_install_log
-
i_step=$(($i_step+1))
-
groupadd mysql
-
useradd mysql -s /sbin/nologin -M -g mysql
-
-
# 建立資料目錄
-
echo "-->Step $i_step,`date +'%F_%T'`,建立例項目錄,屬主為mysql." | tee -a $i_install_log
-
i_step=$(($i_step+1))
-
mkdir -p $i_db_data_dir
-
mkdir -p $i_db_base_dir/binlog
-
mkdir -p /opt/mysql-5.5.32/data
-
chown -R mysql:mysql /opt/mysql-5.5.32
-
chmod 1777 /tmp
-
chown -R mysql:mysql $i_db_data_dir
-
-
# 若建立失敗,則退出
-
if [ ! -d $i_db_base_dir ]
-
then
-
echo "-->Step $i_step,`date +'%F_%T'`,例項目錄建立失敗,退出安裝." | tee -a $i_install_log
-
i_step=$(($i_step+1))
-
echo "!!! Mysql data dir $i_db_base_dir not exist!" | tee -a $i_install_log
-
exit 1
-
fi
-
-
###############################################################
-
# 一鍵生成mysql配置檔案 BEGIN
-
###############################################################
-
echo "-->Step $i_step,`date +'%F_%T'`,一鍵生成mysql配置檔案 ${i_db_base_dir}/my.cnf ." | tee -a $i_install_log
-
i_step=$(($i_step+1))
-
cat > $i_db_base_dir/my.cnf << EOF
-
[client]
-
port = $i_install_port
-
socket = $i_db_base_dir/mysql.sock
-
-
[mysql]
-
no-auto-rehash
-
-
[mysqld]
-
user = mysql
-
port = $i_install_port
-
socket = $i_db_base_dir/mysql.sock
-
basedir = /opt/mysql
-
datadir = $i_db_data_dir
-
open_files_limit = 1024
-
back_log = 600
-
max_connections = 800
-
max_connect_errors = 3000
-
table_cache = 614
-
external-locking = FALSE
-
max_allowed_packet =8M
-
sort_buffer_size = 1M
-
join_buffer_size = 1M
-
thread_cache_size = 100
-
thread_concurrency = 2
-
query_cache_size = 2M
-
query_cache_limit = 1M
-
query_cache_min_res_unit = 2k
-
#default_table_type = InnoDB
-
thread_stack = 192K
-
#transaction_isolation = READ-COMMITTED
-
tmp_table_size = 2M
-
max_heap_table_size = 2M
-
long_query_time = 1
-
#log_long_format
-
#log-error = $i_db_base_dir/error.log
-
#log-slow-queries = $i_db_base_dir/slow.log
-
pid-file = $i_db_base_dir/mysql.pid
-
log-bin = $i_db_base_dir/binlog/mysql-bin
-
relay-log = $i_db_base_dir/binlog/relay-bin
-
relay-log-info-file = $i_db_base_dir/binlog/relay-log.info
-
binlog_cache_size = 1M
-
max_binlog_cache_size = 1M
-
max_binlog_size = 2M
-
expire_logs_days = 7
-
key_buffer_size = 16M
-
read_buffer_size = 1M
-
read_rnd_buffer_size = 1M
-
bulk_insert_buffer_size = 1M
-
#myisam_sort_buffer_size = 1M
-
#myisam_max_sort_file_size = 10G
-
#myisam_max_extra_sort_file_size = 10G
-
#myisam_repair_threads = 1
-
#myisam_recover
-
-
lower_case_table_names = 1
-
skip-name-resolve
-
slave-skip-errors = 1032,1062
-
#replicate-ignore-db=mysql
-
-
server-id = 1
-
-
innodb_additional_mem_pool_size = 4M
-
innodb_buffer_pool_size = 32M
-
innodb_data_file_path = ibdata1:128M:autoextend
-
innodb_file_io_threads = 4
-
innodb_thread_concurrency = 8
-
innodb_flush_log_at_trx_commit = 2
-
innodb_log_buffer_size = 2M
-
innodb_log_file_size = 4M
-
innodb_log_files_in_group = 3
-
innodb_max_dirty_pages_pct = 90
-
innodb_lock_wait_timeout = 120
-
innodb_file_per_table = 0
-
-
[mysqldump]
-
quick
-
max_allowed_packet = 2M
-
-
[mysqld_safe]
-
log-error=$i_db_base_dir/mysql_${i_install_port}.err
-
pid-file=$i_db_base_dir/mysqld.pid
-
-
EOF
-
# END 一鍵生成mysql配置檔案
-
-
###############################################################
-
# 一鍵生成mysql啟停指令碼 BEGIN
-
###############################################################
-
echo "-->Step $i_step,`date +'%F_%T'`,一鍵生成mysql啟停指令碼 ${i_db_base_dir}/mysql ." | tee -a $i_install_log
-
i_step=$(($i_step+1))
-
cat > $i_db_base_dir/mysql <<EOF
-
-
#############################################################
-
# $i_db_base_dir/mysql 啟停指令碼
-
#############################################################
-
CmdPath="/opt/mysql/bin"
-
mysql_user="$i_root"
-
mysql_pwd="$i_root_pwd"
-
port=$i_install_port
-
mysql_db_base=$i_db_base_dir
-
mysql_sock="\${mysql_db_base}/mysql.sock"
-
-
#startup function
-
function_start_mysql()
-
{
-
if [ ! -e "\$mysql_sock" ];then
-
printf "Starting MySQL...\n"
-
/bin/sh \${CmdPath}/mysqld_safe --defaults-file=\${mysql_db_base}/my.cnf > /dev/null 2>&1 &
-
else
-
printf "MySQL is running...\n"
-
exit
-
fi
-
}
-
-
#stop function
-
function_stop_mysql()
-
{
-
if [ ! -e "\$mysql_sock" ];then
-
printf "MySQL is stopped...\n"
-
exit
-
else
-
printf "Stoping MySQL...\n"
-
\${CmdPath}/mysqladmin -u \${mysql_user} -p\${mysql_pwd} -S \${mysql_db_base}/mysql.sock shutdown
-
fi
-
}
-
-
#restart function
-
function_restart_mysql()
-
{
-
printf "Restarting MySQL...\n"
-
function_stop_mysql
-
sleep 2
-
function_start_mysql
-
}
-
-
case \$1 in
-
start)
-
function_start_mysql
-
;;
-
stop)
-
function_stop_mysql
-
;;
-
restart)
-
function_restart_mysql
-
;;
-
*)
-
printf "Usage: \${mysql_db_base}/mysql {start|stop|restart}\n"
-
esac
-
-
EOF
-
# END 一鍵生成mysql啟停指令碼
-
-
# 修改mysql資料目錄屬主
-
chown -R mysql:mysql $i_db_base_dir
-
chown -R mysql:mysql $i_db_data_dir
-
-
# 修改mysql啟停指令碼執行許可權
-
chmod +x $i_db_base_dir/mysql
-
-
# 模組載入
-
echo "/opt/mysql/include" >> /etc/ld.so.conf
-
echo "/opt/mysql/lib" >> /etc/ld.so.conf
-
ldconfig
-
-
# 初始化資料庫
-
echo "-->Step $i_step,`date +'%F_%T'`,初始化資料庫." | tee -a $i_install_log
-
i_step=$(($i_step+1))
-
echo " 【Command】:/opt/mysql/scripts/mysql_install_db --basedir=/opt/mysql --datadir=$i_db_data_dir --user=mysql" | tee -a $i_install_log
-
/opt/mysql/scripts/mysql_install_db --basedir=/opt/mysql --datadir=$i_db_data_dir --user=mysql >> $i_install_log
-
-
#初次啟動,root沒有密碼
-
echo "-->Step $i_step,`date +'%F_%T'`,mysql starting..." | tee -a $i_install_log
-
i_step=$(($i_step+1))
-
echo " 【Command】:/opt/mysql/bin/mysqld_safe --defaults-file=$i_db_base_dir/my.cnf > /dev/null 2>&1 &" | tee -a $i_install_log
-
/opt/mysql/bin/mysqld_safe --defaults-file=$i_db_base_dir/my.cnf > /dev/null 2>&1 &
-
-
# 睡眠時間要足夠長,等待mysql啟動成功後初始化密碼
-
echo "-->Step $i_step,`date +'%F_%T'`,sleep 60 seconds." | tee -a $i_install_log
-
i_step=$(($i_step+1))
-
sleep 60
-
-
# 設定root密碼
-
echo "-->Step $i_step,`date +'%F_%T'`,設定root密碼." | tee -a $i_install_log
-
i_step=$(($i_step+1))
-
echo " 【Command】:/opt/mysql/bin/mysqladmin -S $i_db_base_dir/mysql.sock -u${i_root} password \"${i_root_pwd}\" " >> $i_install_log
-
/opt/mysql/bin/mysqladmin -S $i_db_base_dir/mysql.sock -u${i_root} password "${i_root_pwd}"
-
sleep 1
-
-
# 登入測試
-
echo "-->Step $i_step,`date +'%F_%T'`,一切OK了,登入測試一把." | tee -a $i_install_log
-
i_step=$(($i_step+1))
-
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
-
/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
-
-
else
-
echo "-->Step $i_step,`date +'%F_%T'`,mysql-5.5.32_bin_x86_64.tar.gz 不存在,請重新上傳!!" | tee -a $i_install_log
-
i_step=$(($i_step+1))
-
exit 1
- fi
# 安裝過程日誌
###################################################################
-
#####################################################
-
# 老男孩linux運維實戰培訓中心
-
# 培訓諮詢:QQ: 41117397 70271111 41117483 80042789
-
# 培訓電話:18600338340 18911718229
-
# 老男孩老師 QQ:49000448 31333741
-
# 網站地址:http://www.etiantian.org
-
# 老男孩部落格:http://oldboy.blog.51cto.com
-
# 老男孩交流群 246054962208160987 226199307 44246017
-
# 網站運維交流群:114580181 45039636 37081784
-
#####################################################
-
*******************************************************
-
** MySQL預設配置資訊
-
**軟體安裝路徑 :/opt/mysql/
-
**軟體包位置 :/root/tools/
-
**軟體包名 :mysql-5.5.32_bin_x86_64.tar.gz
-
**例項base目錄 :/data/3306
-
**例項data目錄 :/data/3306/data
-
**例項預設埠 :3306
-
**初始化root密碼 :123456
-
*******************************************************
-
*******************************************************
-
** 操作選項
-
** 0 退出安裝
-
** 1 預設配置安裝
-
** 2 設定例項base目錄
-
** 3 設定例項data目錄
-
** 4 設定例項預設埠
-
** 5 初始化root密碼
-
** 6 檢視引數配置
-
** 7 操作選項幫助
-
** 8 完成引數設定,準備開始安裝
-
** 9 老男孩Linux培訓諮詢
-
*******************************************************
-
**您輸入的是:2 設定例項base目錄
-
-->例項base目錄為:/data/3307
-
**您輸入的是:3 設定例項data目錄
-
-->例項data目錄為:/data/3307/data
-
**您輸入的是:4 設定例項預設埠
-
-->新埠號為:3307
-
**您輸入的是:5 初始化root密碼
-
-->初始化root密碼為:123456789
-
**您輸入的是:6 檢視引數配置
-
*******************************************************
-
** MySQL預設配置資訊
-
**軟體安裝路徑 :/opt/mysql/
-
**軟體包位置 :/root/tools/
-
**軟體包名 :mysql-5.5.32_bin_x86_64.tar.gz
-
**例項base目錄 :/data/3307
-
**例項data目錄 :/data/3307/data
-
**例項預設埠 :3307
-
**初始化root密碼 :123456789
-
*******************************************************
-
**您輸入的是:9 老男孩Linux培訓諮詢
-
#####################################################
-
# 老男孩linux運維實戰培訓中心
-
# 培訓諮詢:QQ: 41117397 70271111 41117483 80042789
-
# 培訓電話:18600338340 18911718229
-
# 老男孩老師 QQ:49000448 31333741
-
# 網站地址:http://www.etiantian.org
-
# 老男孩部落格:http://oldboy.blog.51cto.com
-
# 老男孩交流群 246054962208160987 226199307 44246017
-
# 網站運維交流群:114580181 45039636 37081784
-
#####################################################
-
**您輸入的是:h
-
*******************************************************
-
** 操作選項
-
** 0 退出安裝
-
** 1 預設配置安裝
-
** 2 設定例項base目錄
-
** 3 設定例項data目錄
-
** 4 設定例項預設埠
-
** 5 初始化root密碼
-
** 6 檢視引數配置
-
** 7 操作選項幫助
-
** 8 完成引數設定,準備開始安裝
-
** 9 老男孩Linux培訓諮詢
-
*******************************************************
-
**您輸入的是:6 檢視引數配置
-
*******************************************************
-
** MySQL預設配置資訊
-
**軟體安裝路徑 :/opt/mysql/
-
**軟體包位置 :/root/tools/
-
**軟體包名 :mysql-5.5.32_bin_x86_64.tar.gz
-
**例項base目錄 :/data/3307
-
**例項data目錄 :/data/3307/data
-
**例項預設埠 :3307
-
**初始化root密碼 :123456789
-
*******************************************************
-
**您輸入的是:8 完成引數設定,準備開始安裝
-
-->安裝前,最後檢查配置引數,請仔細核對資訊!
-
*******************************************************
-
** MySQL預設配置資訊
-
**軟體安裝路徑 :/opt/mysql/
-
**軟體包位置 :/root/tools/
-
**軟體包名 :mysql-5.5.32_bin_x86_64.tar.gz
-
**例項base目錄 :/data/3307
-
**例項data目錄 :/data/3307/data
-
**例項預設埠 :3307
-
**初始化root密碼 :123456789
-
*******************************************************
-
-->Step 0,2015-12-05_17:05:28,MySQL一鍵安裝開始...
-
-->Step 1,2015-12-05_17:05:28,安裝軟體包.
-
/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
-
-->Step 2,2015-12-05_17:06:00,建立使用者和組.
-
-->Step 3,2015-12-05_17:06:01,建立例項目錄,屬主為mysql.
-
-->Step 4,2015-12-05_17:06:01,一鍵生成mysql配置檔案 /data/3307/my.cnf .
-
-->Step 5,2015-12-05_17:06:01,一鍵生成mysql啟停指令碼 /data/3307/mysql .
-
-->Step 6,2015-12-05_17:06:01,初始化資料庫.
-
【Command】:/opt/mysql/scripts/mysql_install_db --basedir=/opt/mysql --datadir=/data/3307/data --user=mysql
-
Installing MySQL system tables...
-
OK
-
Filling help tables...
-
OK
-
-
To start mysqld at boot time you have to copy
-
support-files/mysql.server to the right place for your system
-
-
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
-
To do so, start the server, then issue the following commands:
-
-
/opt/mysql/bin/mysqladmin -u root password 'new-password'
-
/opt/mysql/bin/mysqladmin -u root -h data-1-2 password 'new-password'
-
-
Alternatively you can run:
-
/opt/mysql/bin/mysql_secure_installation
-
-
which will also give you the option of removing the test
-
databases and anonymous user created by default. This is
-
strongly recommended for production servers.
-
-
See the manual for more instructions.
-
-
You can start the MySQL daemon with:
-
cd /opt/mysql ; /opt/mysql/bin/mysqld_safe &
-
-
You can test the MySQL daemon with mysql-test-run.pl
-
cd /opt/mysql/mysql-test ; perl mysql-test-run.pl
-
-
Please report any problems with the /opt/mysql/scripts/mysqlbug
-
-
-->Step 7,2015-12-05_17:06:02,mysql starting...
-
【Command】:/opt/mysql/bin/mysqld_safe --defaults-file=/data/3307/my.cnf > /dev/null 2>&1 &
-
-->Step 8,2015-12-05_17:06:02,sleep 60 seconds.
-
-->Step 9,2015-12-05_17:07:02,設定root密碼.
-
【Command】:/opt/mysql/bin/mysqladmin -S /data/3307/mysql.sock -uroot password "123456789"
-
-->Step 10,2015-12-05_17:07:03,一切OK了,登入測試一把.
-
【Command】:/opt/mysql/bin/mysql -uroot -p123456789 -S /data/3307/mysql.sock -e "show variables like '%character%'"
-
+--------------------------+-----------------------------------+
-
| Variable_name | Value |
-
+--------------------------+-----------------------------------+
-
| character_set_client | utf8 |
-
| character_set_connection | utf8 |
-
| character_set_database | utf8 |
-
| character_set_filesystem | binary |
-
| character_set_results | utf8 |
-
| character_set_server | utf8 |
-
| character_set_system | utf8 |
-
| character_sets_dir | /opt/mysql-5.5.32/share/charsets/ |
- +--------------------------+-----------------------------------+
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22661144/viewspace-1867159/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- CentOS6.7下使用cmake編譯安裝MySQL5.5.32CentOS編譯MySql
- zabbix一鍵安裝
- 在CentOS上安裝GitCentOSGit
- 在centos上安裝molochCentOS
- 在Windows上安裝MavenWindowsMaven
- 在CentOS上安裝dockerCentOSDocker
- 在CentOS上安裝PowerShellCentOS
- 在windows上安裝numpyWindows
- 在mac上安裝DockerMacDocker
- mysql 在windows上安裝MySqlWindows
- 在Centos上安裝wordpressCentOS
- 在AIX上安裝GCCAIGC
- hive在centos上安裝HiveCentOS
- 在lfs上安裝tcpdumpTCP
- 在AIX上安裝VNCAIVNC
- SDL在win上安裝
- Kaldi學習(一)kaldi在ubuntu上的安裝Ubuntu
- LNMP一鍵安裝包LNMP
- centos 一鍵安裝jdkCentOSJDK
- ODA一鍵式安裝
- 在Linux上安裝gskitLinux
- 在CentOS 8.1上安裝 DockerCentOSDocker
- 在Ubuntu上安裝MariaDBUbuntu
- 在 Ubuntu 上安裝 Budgie 桌面Ubuntu
- 在docker上安裝AWVSDocker
- SonarQube在CentOS上的安裝CentOS
- 在Android上安裝EntwareAndroid
- 在 Mac OSX 上安裝 nginxMacNginx
- ZabbixAgent在Windows上安裝部署Windows
- 在CentOS上安裝GITLABCentOSGitlab
- 在Linux上安裝postgresqlLinuxSQL
- 在 Linux 上安裝 PostgreSQLLinuxSQL
- 在Ubuntu上安裝openssh(轉)Ubuntu
- 在virtualbox上安裝ubuntuUbuntu
- 在 Rainbond 中一鍵安裝高可用 Nacos 叢集AI
- 一鍵安裝PHP8.0PHP
- LAMPorLNMP一鍵安裝指令碼LAMPLNMP指令碼
- CentOS 5.5一鍵安裝pptpCentOSpptp